The following example logs errors internally in Greenplum Database and sets an error threshold of 10 errors.
Use the built-in SQL function gp_read_error_log('external_table')
to read the error log data. This example command displays the log errors for ext_expenses:
For information about the format of the error log, see Viewing Bad Rows in the Error Log.
The built-in SQL function gp_truncate_error_log('external_table')
deletes the error data. This example deletes the error log data created from the previous external table example :
Parent topic: Handling Load Errors
Content feedback and comments