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

Trevor_Newman

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.

[Deleted User]

Trevor,

 

Can you file a support case at http://my.vertica.com/ on this problem?

 

Thanks,

 

Sarah

Trevor_Newman

Hi Sarah,

 

I have opened ticket - ID SD00118347

 

Thanks,