Copy JSON file into flex table using fjsonparser



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



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file