dm_path=xxx
username=xxx
password=xxx
ip="xxxx"
port=xxx
query="
select * from xxx;
"
localpath="xxx"
connect_info=${username}/${password}@${ip}:$port
echo "连接信息:"$connect_info
echo "
OPTIONS
(
SKIP = 0
ROWS = 50000
DIRECT = TRUE
INDEX_OPTION = 2
)
LOAD DATA
INFILE '${localpath}/dmtest.csv'
BADFILE 'xxx/dmtest.bad'
INTO TABLE xxx
FIELDS ','
(
A,M
)
">${localpath}/dm.ctl
${dm_path}/dmfldr userid=xxx/xxx@localhost:5236 control='xxx/dm.ctl' data='${localpath}/dmtest.csv'
error:dmfldr: 2024-01-29 15:39:03 Encryption module failed to load
如果改成
cd ${dm_path}
./dmfldr userid=xxx/xxx@localhost:5236 control='xxx/dm.ctl' data='${localpath}/dmtest.csv'
会有问题么?看起来只是环境变量依赖的问题。