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:

  1. starts gpfdist on listening on port running gpload.
  2. creates external table location specified gpfdist://:/filename
  3. 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

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -