Athena - HIVE_UNKNOWN_ERROR: java.net.URISyntaxException: Relative path in absolute URI: arn:aws:dynamodb

0

Using Glue Crawler created Catalog Table for a DynamoDB data source, and that was successful. I could see the column names correctly in the schema section of Catalog Table. With Athena trying to run a SELECT query, and it is throwing the following error:

HIVE_UNKNOWN_ERROR: java.net.URISyntaxException: Relative path in absolute URI: arn:aws:dynamodb:us-east-2:XXXXXXXXXXXXX:table/dydb_sales_data This query ran against the "catlog_dydb_sales_data" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 61011e40-b3d2-41df-af0e-bbcb70e171aa

Also, noticed that in Athena, it shows Tables (0). It is suppose to show one table, with column details. For the Catalog table for S3 data source, this issue is not there. It is only for the DynamoDB as data source. Please let me know how to resolve it.

asked 10 months ago790 views
1 Answer
0

That kind of table (DynamoDB) is not supported by Athena (it's only supported in Glue jobs).
Athena has it's own way of querying DynamoDB using federated queries

profile pictureAWS
EXPERT
answered 10 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