Greenplum windows service for import data -


i have installed windows service on local machine , setup looks good. when read external table, http response code 500.

create external temporary table (     smallint,     b integer,     c text   ) location ('gpfdist://hostname:8081/filename.txt') format 'text' (delimiter '   ' null '' escape 'off') ; 

error message -

error:  http response code 500 gpfdist (gpfdist://hostname8081/filename.txt): http/1.0 500 session error (url.c:326)  (seg538 slice1 sdw135:40002 pid=6237) (cdbdisp.c:1476) 

i not sure how resolve error

possible chance of permission / access issues. check stream provisioning setup.

user creating external table should have permission write , access directories on etl nodes you've started stream provisioning.


Comments

Popular posts from this blog

c++ - Creating new partition disk winapi -

Android Prevent Bluetooth Pairing Dialog -

VBA function to include CDATA -