impala-shell 导出查询结果到文件
2019-04-04 本文已影响0人
夜空最亮的9星
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