linux使用impala执行sql导出excel
解决方法:
如下脚本使用impala执行sql获取kudu的数据填充到test.csv文件,文件的列用逗号隔开(output_delimiter=","),打印sql中的列表(print_header)
filepath=/home/scapp/sh/cite_core_user/test.csv
impala-shell -q "SELECT info.userid '会员号', info.phone '手机号' FROM city where 1=1" -B --output_delimiter="," --print_header -o ${filepath}