COPY FROM
statement, allows you to specify the imported file format and currently three types are supported.
COPY FROM
statement you can use the following syntax:
HEADER
if your ORC file includes column headerson_error
action to ignore
enforce further processing after skipping invalid rows.
HEADER
, DELIMITER
, NULL
, ON_ERROR
options are ignored not affecting the execution of the queries for formats different than CSVNOT NULL
, the column in the ORC file cannot contain a null value, otherwise the request will be terminated.ON_ERROR
option for CSV files, null constraint violation causes row skipping