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?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file