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

 

Comments

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.