Failure while parsing JSON. Found token of [VALUE_NULL]. Dremio currently only supports parsing json strings that contain either lists or maps. The root object cannot be a scalar

1

Hey guys,

I have many JSONs and transform them into a VDS, thats OK. Then, I get this VDS and make a merge - this is when I get this error: “Failure while parsing JSON. Found token of [VALUE_NULL]. Dremio currently only supports parsing json strings that contain either lists or maps. The root object cannot be a scalar.”
I have no idea what’s happening because when I transform the JSON into a VDS I get no error codes.

Can someone help me?

2

@naiaracerqueira Are you trying to do a CONVERT_FROMJSON? Are you able to send us the profile?