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
Post a Comment