Query returns `HIVE_UNKNOWN_ERROR: Can not create a Path from an empty string`

Question

Directed from Andes table to Athena and query errors with
```
HIVE_UNKNOWN_ERROR: Can not create a Path from an empty string
This query ran against the "andes" database, unless qualified by the query.
```

Accepted Answer

The issue was not resolved when I re-created all my resources to have "_" rather "-" however I encountered the same issue again. 
Finally after checking with support team again, I was suggested to load the table with data and it worked.

So, you might encounter the same error if there is no data in your table. In my case, I had an empty Andes table, from which this glue table depend on, so when I try to query via Athena this error pops up.

Edit: After loading the Andes table via Cradle, I was able to query in Athena. So, the culprit here could be empty table or db, table naming convention or both.

Answer

Contacted the customer support and they directed me to https://docs.aws.amazon.com/athena/latest/ug/glue-best-practices.html. Which says that you can't have "-" in glue table name. So for someone encountering this issue, try checking the glue table name.

Query returns `HIVE_UNKNOWN_ERROR: Can not create a Path from an empty string`

Contenus pertinents