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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인