Options

COPY: Input record 18 has been rejected (Rejected by user-defined parser).

drno-regdrno-reg
in General Discussion

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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...