Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.