Athena DocumentDB with GeoJSON data not working

0

We have connected Athena to a DocumentDB cluster with GeoJSON data stored inside. When trying to query these data we're getting following error: GENERIC_USER_ERROR: Encountered an exception[java.lang.RuntimeException] from your LambdaFunction[arn:aws:lambda:eu-west-1:<>:<>] executed in context[S3SpillLocation{bucket='<>', key='<>', directory=true}] with message[Error while processing field geoPoint] Is there any way to query GeoJSON data in DocumentDB from Athena? Query id: 138f4f39-a8d0-4cff-b0a3-357d2d310196

質問済み 2年前307ビュー
1回答
0

Hello,

The error - [Error while processing field geoPoint]seems to hint at syntax issue in processing the field geoPoint.

However, to be able to troubleshoot this further, our team would require information on the version of the connector, CloudWatch Logs of the Lambda Function, and metadata definition to be able to troubleshoot this issue.

Hence, could you please create a support case with our Athena team instead so that we may discuss details on your resource configurations?

Please do not post any sensitive information over re:Post since this is a public platform.

Additionally I would also recommend checking the following AWS Docs and Github space to reach out to the developers directly for Amazon Athena DocumentDB Connector issues -

https://github.com/awslabs/aws-athena-query-federation/tree/master/athena-docdb

https://aws.amazon.com/blogs/big-data/query-any-data-source-with-amazon-athenas-new-federated-query/

https://docs.aws.amazon.com/athena/latest/ug/connectors-docdb.html

https://aws.amazon.com/premiumsupport/knowledge-center/athena-generic-internal-error/

As always, feel free to reach back with any further questions or concerns in the meantime!

profile pictureAWS
サポートエンジニア
Yash_C
回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ