When BL_REJECT_TYPE=PERCENT,
the percentage of rows per segment is calculated based on the Greenplum
database configuration parameter (gp_reject_percent_threshold). The
default value for this parameter is 300.
Input rows with format
errors are discarded if the reject limit count is not reached on any
Greenplum segment instance during the load operation.
Constraint errors result
when violations occur to such constraints as NOT NULL, CHECK, or UNIQUE.
A single constraint error causes the entire external table operation
to fail. If the reject limit is not reached, rows without errors are
processed and rows with errors are discarded.