I am getting error "Duplicate key values violates constraint 'public.table_name.C_UNIQUE' " while uploading the data to vertica table.
I need to use the ERROR TOLERANCE parameter in sql statement so that it treats each source during execution independently when loading dataThe invalid source is skipped and the load continues
I am using below query to upload the data to table,could you please suggest the correct syntax to use ERROR TOLERANCE parameter?
Code: Select all
vsql -c "copy table_name (inputfile as 'file_name', hostname,groups, owner, job_name, job_number, unix_timestamp FILLER VARCHAR(15),submission_time AS TO_TIMESTAMPTZ(unix_timestamp) ) from local '/work/file_name' DELIMITER '|' NULL ''DIRECT REJECTED DATA '/tmp/test' TRAILING NULLCOLS;"