HIVE CURSOR ERROR Row is not a valid JSON Object - JSONException

Question

I am creating a JSON file:

["name":"Jino","age":22,"subject":"AWS"]

HIVE_CURSOR_ERROR: Row is not a valid JSON Object - JSONException: Expected a ',' or ']' at 8 [character 9 line 1]

This query ran against the "sampledatabase" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 36f8b31e-185c-40dc-b880-8ca5f776b370.

Answer 1

This is not the correct form of writing JSON files.

The right format is as follows:

String 

{"name":"name"}

Integer

{"number":123344}

Multiple entry as in your case:

{"name":"Jino","age":22,"subject":"AWS"}

Creating database:

{"employees":[
    { "firstName":"John", "lastName":"Doe" },
    { "firstName":"Anna", "lastName":"Smith" }]

}