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

While using Custom SQL in Quicksight, you have to mention the catalog name as well in addition to the database and table name. If you only mention the database and table name, it will throw the above-mentioned error. For example,

SELECT * FROM "database-occupancy"."table-chanel_occupancy_sample" limit 10; does not have the catalog mentioned in the SQL Query and this has a format of SELECT * FROM "database"."table" limit 10;

Correct way to avoid this error [ "HIVE_UNKNOWN_ERROR: java.net.URISyntaxException: Relative path in absolute URI: arn:aws:dynamodb" ] is to follow below format: SELECT * FROM "Catalog"."database"."table" limit 10; . So you can write in QuickSight,

SELECT * FROM "Catalog-Occupancy"."database-occupancy"."table-chanel_occupancy_sample" limit 10;

Because we are creating a dedicated data source in Athena, it is mandatory to write that in the QuickSight SQL Query .

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