Glue to Athena Error

Question

HIVE_UNKNOWN_ERROR: java.net.URISyntaxException: Relative path in absolute URI: arn:aws:dynamodb:{Account}:table/{Table}
This query ran against the "{Created Athena Database}" database, unless qualified by the query

i am trying to connect a dynamodb dataset to be used in athena, I have created crawlers that post the tables to a glue dataset so we do not lose any columns, when I connect the glue dataset to athena, all of the tables and their columns show in the query editor but when I try to preview in the query editor  the following error shows

Answer

Just because a table is in the catalog it doesn't mean that any client is able to interpret it and use it.  
In this case that DDB table is usable by Glue jobs but not Athena (which is trying to read it as a regular tale).  
To use DDB for Athena, they have their own way: https://docs.aws.amazon.com/athena/latest/ug/connectors-dynamodb.html

Glue to Athena Error

Relevant content