The error limit includes rows with format errors. The default value is 0. By default, the gpload utility stops a session when it encounters a row with format errors.

Use the following naming convention for the error table name:

<schema name>.<table name>

If you do not specify a schema name, the gpload utility creates the error table in the public schema. The error table format is predefined in the Greenplum database.

For more information about the error tables, see the Greenplum documentation.

You can view load statistics in the session log. The gpload utility writes the error messages to the gpload log. The Secure Agent reads the gpload log and writes the errors to the session log. The gpload utility writes the error messages to the gpload log at the following location:

$INFA_HOME/server/infa_shared/temp