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 27, 2018 in AWS by Jino
• 5,820 points
6,531 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 27, 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 2, 2018 in AWS by Cloud gunner
• 4,670 points
1,714 views
0 votes
1 answer
+7 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
• 58,100 points
12,402 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
11,251 views
0 votes
1 answer

AWS S3 uploading hidden files by default

versioning is enabled in your bucket. docs.aws.amazon.com/AmazonS3/latest/user-guide/….... the ...READ MORE

answered Oct 4, 2018 in AWS by Priyaj
• 58,100 points
5,832 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP