1.33 COPY REJECTMAX,ENFORELENGTH,ABORT ON ERROR

COPY : How to Specify Maximum number of rejections allowed (REJECTMAX)

The REJECTMAX parameter specifies the maximum number of logical records that can be rejected before a load fails. 

When the number of rejected records will be greater than the REJECTMAX value (REJECTMAX+1), the load fails.

If you do not specify a value for REJECTMAX, or if the value is 0, COPY allows an unlimited number of exceptions to occur.

COPY : How to reject rows when length of input strings is greater than the target table length(ENFORCELENGTH).

When parsing data of type CHAR, VARCHAR, BINARY, or VARBINARY, rows may exceed the target table length. By default, COPY truncates such rows without rejecting them.

Use the ENFORCELENGTH parameter to reject rows that exceed the target table.

COPY : How to abort data loads for any error(ABORT ON ERROR).

Using the ABORT ON ERROR argument is the most restrictive way to load data, because no exceptions or rejections are allowed. A COPY operation stops if any row is rejected. No data is loaded and HP Vertica rolls back the command.