impala-shell 导出查询结果到文件

impala-shell 在ldap模式下导出查询结果到文件

#!/bin/bash

select_sql=$1
outFile=$2
echo $select_sql
expect <<- EOF
set timeout -1
spawn impala-shell -i node1:21000 -l -u "admin" --auth_creds_ok_in_clear -q "$select_sql" --output_delimiter="\t" --print_header -o $outFile; 
expect "LDAP password*"
send "123456!\r"
expect "*#*"
EOF