HIVE_CURSOR_ERROR: Row is not a valid JSON Object - JSONException

0 votes

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.

Nov 26, 2018 in AWS by Jino
• 5,560 points
1,002 views

1 answer to this question.

0 votes

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" }]

}
answered Nov 26, 2018 by Shuvodip Ghosh

Related Questions In AWS

0 votes
1 answer

if instance is a part of some AutoScaling Group in AWS or not ?

You can run this command below on ...READ MORE

answered Jun 1, 2018 in AWS by Cloud gunner
• 4,280 points
66 views
0 votes
1 answer
+6 votes
2 answers

Why S3 is called a Object storage?

Amazon S3 stores data as objects within resources called "buckets".  Object storage, also ...READ MORE

answered Sep 24, 2018 in AWS by Priyaj
• 56,900 points
679 views
0 votes
1 answer
0 votes
2 answers
0 votes
1 answer
0 votes
1 answer

Error: upload failed:Parameter validation failed

You have not mentioned the file you ...READ MORE

answered Nov 27, 2018 in AWS by Shuvodip Ghosh
1,178 views
0 votes
1 answer