postgresql - gpload utility in greenplum -
can me gpload utility in greenplum? doing first time, have created control file per command, getting gpfdist connection error. there reference material on gpload utility or examples can refer to?
i getting below error while using gpload:
2013-05-21 09:34:20|info|started gpfdist -p 9096 -p 9097 -f "gpload.test.txt" -t 30 "2013-05-21 09:34:23|error|error: connection gpfdist failed gpfdist://<host-ip>:9096/gpload.test.txt. effective url: http://<host-ip>:9096/gpload.test.txt. (seg43 slice1 sdw8:40001 pid=19336)"
i tried doing few changes still problem persist. in advance, sunny
the key recognize gpload following:
- starts gpfdist on listening on port running gpload.
- creates external table location specified gpfdist://:/filename
- executes following or similar sql insert select * ;
this causes segments connect server gpload running. requires localhost specified in gpload config file can contacted segments.
try ping server gpload running 1 of segments.
please send copy of .yml file if need additional assistance.
you can email me at: lwalstad@gopivotal.com
Comments
Post a Comment