Row is not a valid JSON Object - JSONException: Expected a ',' or '}'
0
Simba(100071) An error has been thrown from the AWS Athena client. Row is not a valid JSON Object - JSONException: Expected a ',' or '}' at 149 character 150 line 1
asked a month ago15 views
1 Answers
0
Hi ,
the error seems to indicate that the JSON data set you are trying to read might be not be formatted correctly for Athena.
Athena expect the file to be in the format:
{ "id" : 50, "name":"John" }
{ "id" : 51, "name":"Jane" }
{ "id" : 53, "name":"Jill" }
the format below will not work:
{
"id" : 50,
"name":"John"
},
{
"id" : 51,
"name":"Jane"
}
{
"id" : 53,
"name":"Jill"
}
for more information please look this knowledge base article.
hope this helps
Relevant questions
S3: Can't change storage class
asked 3 months agoHandling S3 events. Race condition?
asked a month agoRow is not a valid JSON Object - JSONException: Expected a ',' or '}'
asked a month agoAWS config with Athena - Issue
asked 2 months agoInvalid AWSPhone on AppSync
asked 2 months agoWhat is S3 object etag in fips enabled AWS S3 endpoints, Are they MD5SUM?
asked 22 days agoClarification on S3 Select with Parquet - indexing, range offsets, and pricing
asked 2 months agoHow to pass float numbers to Lambda event object
Accepted Answerasked 2 months agoMalformedPolicyDocumentException null being thrown putting policy on CMK
asked 2 years agoError retrieving a secret value from secrets manager
asked 17 days ago