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.
AWS OFFICIALAktualisiert vor 2 Jahren
Thanks for the help. If you have any particular documents to refer, please share if it is other than https://docs.aws.amazon.com/athena/latest/ug/using-athena-sql.html