pm-4G/other/gpload/pm_lte_gpload.sh

#!/bin/bash

source /data/xxl-job/greenplum_loaders_path.sh

new_date=$1

# 修改gpload配置文件
sed -i 's/\/data\/xxl-job\/distinct\/pm_4g_hour_[0-9]\{10\}.csv/\/data\/xxl-job\/distinct\/pm_4g_hour_'${new_date}'.csv/' /data/xxl-job/pm_lte_gpload2.yml

# 由于gpload需要输入密码，这里需要使用expect执行
password=Richr00t#

expect -c "
set timeout 300
spawn gpload -f /data/xxl-job/pm_lte_gpload2.yml
expect {
\"connecting (yes/no)?\" { send \"yes\n\";exp_continue }
\"Password:\" { send \"${password}\n\"; exp_continue}
timeout { puts \"超时\" exit 2}
}
"