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]

已提問 2 年前檢視次數 5784 次
1 個回答
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
專家
已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南