Define an External Table with Single Row Error Isolation

The following example logs errors internally in HAWQ and sets an error threshold of 10 errors.

  1. =# CREATE EXTERNAL TABLE ext_expenses ( name text, date date, amount float4, category text, desc1 text )
  2.    LOCATION ('gpfdist://etlhost-1:8081/*', 'gpfdist://etlhost-2:8082/*')
  3.    FORMAT 'TEXT' (DELIMITER '|')
  4.    LOG ERRORS INTO errortable SEGMENT REJECT LIMIT 10 ROWS;

The following example creates an external table, ext_expenses, sets an error threshold of 10 errors, and writes error rows to the table err_expenses.

  1. =# CREATE EXTERNAL TABLE ext_expenses
  2.      ( name text, date date, amount float4, category text, desc1 text )
  3.    LOCATION ('gpfdist://etlhost-1:8081/*', 'gpfdist://etlhost-2:8082/*')
  4.    FORMAT 'TEXT' (DELIMITER '|')
  5.    LOG ERRORS INTO err_expenses SEGMENT REJECT LIMIT 10 ROWS;