Copy JSON file into flex table using fjsonparser

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

+1

Hi,

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

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?

Sign up