利用impala去查询kudu表,需要导出成csv文件。
impala-shell -k -q "select '$name' as dic_code, ${col1}, ${col2}, row_number() over(order by ${col1}) rank from kudu_dim2.dim_shop_info group by ${col1}, ${col2}
" -B --output_delimiter="," --print_header -o ${name}.csv
-k 是使用kerberos安全加密方式运行impala-shell
-q 执行查询