- #!/bin/bash
- source /usr/local/greenplum-db-clients/greenplum_loaders_path.sh
- table=$1
- # 由于gpload需要输入密码，这里需要使用expect执行
- password=sqmdb_1QAZ
- expect -c "
- set timeout 300
- spawn gpload -f /data/site_info/gpload/${table}.yml
- expect {
- \"connecting (yes/no)?\" { send \"yes\n\";exp_continue }
- \"Password:\" { send \"${password}\n\"; exp_continue}
- timeout { puts \"超时\" exit 2}
- }
- "
|
