By default, if external table data contains an error, the command fails and no data loads into the target database table.
Define the external table with single row error handling to enable loading correctly formatted rows and to isolate data errors in external table data. See Handling Load Errors.
The gpfdist
file server uses the HTTP
protocol. External table queries that use LIMIT
end the connection after retrieving the rows, causing an HTTP socket error. If you use LIMIT
in queries of external tables that use the gpfdist://
or http:// protocols
, ignore these errors – data is returned to the database as expected.
Parent topic: Defining External Tables