Skip to main content

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

  • August 25, 2017
  • 0 replies
  • 2 views

drno-reg
Forum|alt.badge.img+1

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?