- Newest
- Most votes
- Most comments
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.
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.
Relevant content
- asked 3 months ago
- Accepted Answer
- asked a year ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago