Copy JSON file into flex table using fjsonparser

Tal

 

Hi,

I am working on vertica 7.1 and using fjsonparser to copy data into flex table.

I copied a corrupted Jason file that was missing: ” and   } in the end of the file.

The copy command went well and loaded only the good records except the last one.

I wanted to know if there is a parameter to control it and to throw error message or at least a warning:

The file look like this in the end of it:

 

"type": 0,
"directory": false,
},
"type": 11
}

{
"by": {
"command": "\"C:\\Windows\\system32\\mspaint.exe\" \"C:\\Users\\ic21074

 

SruthiA

Hi,

 

     Please go through the section "capturing load exceptions and rejections" in the below URL

 

https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkLoadCOPY/CapturingLoadExceptionsAndRejections.htm%3FTocPath%3DAdministrator's%2520Guide%7CBulk%2520Loading%2520Data%7CCapturing%2520Load%2520Rejections%2520and%2520Exceptions%7C_____0

 

 

 

Tal

Although i added to the copy command :

 

REJECTED DATA '/home/dbadmin/UserStorage/us/err.txt' ON v_apddb_node0001
EXCEPTIONS '/home/dbadmin/UserStorage/us_e/err.txt' ON v_apddb_node0001

 

and loaded a corrupted file , nothing was created ,no error absolutly nothing

what i am missing?