kettle 无法调用gpload-问答-阿里云开发者社区-阿里云

开发者社区> 问答> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

kettle 无法调用gpload

2016-12-16 09:40:01 7766 0

在gpload安装的机器,命令行执行gpload命令
[root@kettle bin]# gpload -f my_load.yml
2016-12-15 19:35:41|INFO|gpload session started 2016-12-15 19:35:41
2016-12-15 19:35:41|INFO|started gpfdist -p 8899 -P 8900 -f "/home/admin/gpe
xtdata/c.txt" -t 302016-12-15 19:35:42|INFO|running time: 0.67 seconds
2016-12-15 19:35:42|INFO|rows Inserted = 7
2016-12-15 19:35:42|INFO|rows Updated = 0
2016-12-15 19:35:42|INFO|data formatting errors = 0
2016-12-15 19:35:42|INFO|gpload succeeded
[root@kettle bin]#

在master主机中查看数据
tutorial=> select * from public.test001;

id name
1 2
3 3
1 2
1 3
1 22
1 222
1 22222

(7 rows)

现在是kettle调用gpload时报错信息如下

2016/12/15 05:00:25 - Greenplum Load.0 - Executing: /usr/local/greenplum-loaders-4.3.8.1-build-1/bin/gpload -f /home/admin/gpextdata/my_flag.yml
2016/12/15 05:00:25 - Greenplum Load.0 - Exit Value of psql: 127
2016/12/15 05:00:25 - Greenplum Load.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Error in step, asking everyone to stop because of:
2016/12/15 05:00:25 - Greenplum Load.0 - Exit Value of psql: 127
2016/12/15 05:00:25 - Greenplum Load.0 - Finished processing (I=0, O=7, R=7, W=7, U=0, E=1)
2016/12/15 05:00:25 - Greenplum Load.0 - ERROR>/usr/local/greenplum-loaders-4.3.8.1-build-1/bin/gpload: line 14: exec: gpload.py: not found

可是这个命令直接在命令行可以执行

[root@kettle bin]# /usr/local/greenplum-loaders-4.3.8.1-build-1/bin/gpload
-f /home/admin/gpextdata/my_flag.yml2016-12-15 19:41:58|INFO|gpload session started 2016-12-15 19:41:58
2016-12-15 19:41:58|INFO|started gpfdist -p 8899 -P 8900 -f "/home/admin/gpe
xtdata/c.txt" -t 302016-12-15 19:41:58|INFO|running time: 0.15 seconds
2016-12-15 19:41:58|INFO|rows Inserted = 7
2016-12-15 19:41:58|INFO|rows Updated = 0
2016-12-15 19:41:58|INFO|data formatting errors = 0
2016-12-15 19:41:58|INFO|gpload succeeded
[root@kettle bin]#

环境变量:
[root@kettle bin]# cat ~/.bash_profile

.bash_profile

Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

User specific environment and startup programs

PATH=$PATH:$HOME/bin
source /usr/local/greenplum-loaders-4.3.8.1-build-1/greenplum_loaders_path.s
hexport PATH
export PGDATABASE=tutorial
export PGHOST=master
export PGPORT=5432
export PGUSER=gpadmin
export PGPASSWORD=gpadmin

export PYTHONPATH=/usr/local/lib
[root@kettle bin]#

[root@kettle greenplum-loaders-4.3.8.1-build-1]# cat greenplum_loaders_path.
sh if [ uname -s = "HP-UX" ]; then

set +o nounset

fi

GPHOME_LOADERS=/usr/local/greenplum-loaders-4.3.8.1-build-1
PATH=${GPHOME_LOADERS}/bin:${GPHOME_LOADERS}/ext/python/bin:${PATH}
PYTHONPATH=${GPHOME_LOADERS}/bin/ext:${PYTHONPATH}

export GPHOME_LOADERS
export PATH
export PYTHONPATH

Mac OSX uses a different library path variable

if [ xDarwin = xuname -s ]; then
DYLD_LIBRARY_PATH=${GPHOME_LOADERS}/lib:${GPHOME_LOADERS}/ext/python/lib:$
{DYLD_LIBRARY_PATH} export DYLD_LIBRARY_PATH
else
LD_LIBRARY_PATH=${GPHOME_LOADERS}/lib:${GPHOME_LOADERS}/ext/python/lib:${L
D_LIBRARY_PATH} export LD_LIBRARY_PATH
fi

AIX uses yet another library path variable

Also, Python on AIX requires special copies of some libraries. Hence, lib

/pware.if [ xAIX = xuname -s ]; then
LIBPATH=${GPHOME_LOADERS}/lib/pware:${GPHOME_LOADERS}/lib:${GPHOME_LOADERS
}/ext/python/lib:/usr/lib/threads:${LIBPATH} export LIBPATH
GP_LIBPATH_FOR_PYTHON=${GPHOME_LOADERS}/lib/pware
export GP_LIBPATH_FOR_PYTHON
fi

if [ "$1" != "-q" ]; then
type python >/dev/null 2>&1
if [ $? -ne 0 ]; then

echo "Warning: Python not found.  Python-2.5.1 or better is required to 

run gpload." fi
fi
[root@kettle greenplum-loaders-4.3.8.1-build-1]#

现在应该是环境变量,但是不知道该如何解决

取消 提交回答
全部回答(0)
相关问答

1

回答

Go 语言是怎样创立的?

2022-09-15 15:55:27 20浏览量 回答数 1

1

回答

Multiple results的代码是什么?

2022-08-17 07:39:33 46浏览量 回答数 1

1

回答

数据集的维度对Apriori 算法计算复杂度的影响是什么?

2022-08-02 10:36:07 101浏览量 回答数 1

1

回答

数据集的规模对Apriori 算法计算复杂度的影响是什么啊?

2022-08-02 10:36:46 104浏览量 回答数 1

1

回答

最为影响代码质量的两个表现?

2022-04-18 17:34:52 154浏览量 回答数 1

1

回答

MANGLE的概念是什么?

2021-12-01 15:05:51 277浏览量 回答数 1

1

回答

Python reload() 函数的语法是什么?

2021-11-17 18:51:50 179浏览量 回答数 1

1

回答

取决于Reactor的数量和Hanndler线程数量的不同,Reactor模型有几个变种?

2021-10-12 15:47:49 153浏览量 回答数 1

1

回答

ztree getNodeByTId 方法问题?报错

2020-06-22 14:44:06 349浏览量 回答数 1

1

回答

Pandownload是什么软件?

2020-04-29 16:21:18 686浏览量 回答数 1
+关注
0
文章
1
问答
问答排行榜
最热
最新
相关电子书
更多
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
冬季实战营第三期:MySQL数据库进阶实战
立即下载