Row is not a valid JSON Object - JSONException: Expected a ',' or '}'

0

[Simba]AthenaJDBC 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] [Execution ID: fd5f862a-7558-4329-93df-08ba753e7ee1]

asked 2 years ago5620 views
1 Answer
1

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

AWS
EXPERT
answered 2 years 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