By using AWS re:Post, you agree to the Terms of Use
/Row is not a valid JSON Object - JSONException: Expected a ',' or '}'/

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

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

EXPERT
answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions