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

asked 2 months ago45 views
1 Answer
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 picture
SUPPORT ENGINEER
Yash_C
answered 2 months 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