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

naiaracerqueira · May 4, 2022, 12:34pm

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?

balaji.ramaswamy · May 5, 2022, 5:33pm

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

Topic		Replies	Views
Root Object Cannot be Scalar Parsing Error	7	1809	May 19, 2021
ERROR to transform in JSON	8	3568	November 6, 2020
Null values are not supported in lists by default. Please set `store.json.all_text_mode` to true to read lists containing nulls. Be advised that this will treat JSON null values as a string containing the word 'null'	19	4546	June 20, 2018
Most probably valid REST call '.../v3/sql' failed with error 400	3	1584	March 11, 2019
Unable to Upload valid JSON	7	949	January 22, 2023

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

Related Topics