pm_5g/build-dir/gpload/pm_nr_gpload.sh

#!/bin/bash

source /usr/local/greenplum-db-clients/greenplum_loaders_path.sh
filename=$1

# 修改gpload配置文件
sed -i 's/\/data1\/pm_5g\/distinct\/\S\+/\/data1\/pm_5g\/distinct\/'"${filename}"'/' /data1/pm_5g/gpload/pm_nr_gpload.yml

# 由于gpload需要输入密码，这里需要使用expect执行
password=Richr00t#
expect -c "
set timeout 310
spawn gpload -f /data1/pm_5g/gpload/pm_nr_gpload.yml --gpfdist_timeout 300
expect {
\"connecting (yes/no)?\" { send \"yes\n\";exp_continue }
\"Password:\" { send \"${password}\n\"; exp_continue}
timeout { puts \"超时\" exit 2}
}
"