COPY: Input record 18 has been rejected (Rejected by user-defined parser).
Hello,
I maked JSON from Oracle scheme and tried to load in Vertica
copy ALL_EVENTS from '/home/dbadmin/temp/data_ALL_EVENTS.json' parser fjsonparser() REJECTED DATA '/home/dbadmin/temp/rejected_data_ALL_EVENTS.txt' EXCEPTIONS '/home/dbadmin/temp/exceptions_ALL_EVENTS.txt'
after finished returned
COPY: Input record 18 has been rejected (Rejected by user-defined parser). Please see /home/dbadmin/temp/rejected_data_ALL_EVENTS.txt, record 1 for the rejected record.
COPY: Loaded 710120 rows, rejected 1 rows.
I checked
rejected_data_ALL_EVENTS.txt
file is empty.
How I must understand this exception for my case?
0