COPY into Flex table skip errors

Moderator: NorbertKrupa

Post Reply
BearFan
Newbie
Newbie
Posts: 4
Joined: Thu Sep 26, 2013 1:08 am

COPY into Flex table skip errors

Post by BearFan » Fri Apr 25, 2014 8:19 pm

I am loading a large JSON file into a flex table ... it looks like a very small percentage of rows have some formatting errors .... is there a way to skip those records and just load everything else?

I am getting an error like this

Error calling process() in User Function UDParser at [src/JSONParse
r.cpp:376], error code: 0, message: Unrecoverable parse exception while processi
ng partition: [Unrecoverable YAJL Error on record # [1834472] with status: [pars
e error] and [34757] Bytes consumed: [lexical error: invalid character inside st
ring.
Currently Not Available Online {"id":"89996f3f-b5ef-4e6b-9d
(right here) ------^
]] while parsing JSON data for row [34757] with [1834472] Bytes consumed.

Post Reply

Return to “Vertica Data Load”