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
网友评论