Flex table error - Tried to retrieve Flex Table data from a cell not containing an Flex Table map

Hi,

 

I am using the FJSON parser for the bulk loader into a flex table

 

I am getting the error :-

 

 Error Code: 5861, SQL State: VP001]  [Vertica][VJDBC](5861 ......Tried to retrieve Flex Table data from a cell not containing an Flex Table map

 

when trying to retrieve values from the flex table using maplookup/mapitems for array data.

 

Is this error caused by bad JSON data ?

 

Is there an easy way to find the offending record(s)?

 

Thanks.

Comments

Leave a Comment

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