1 Answer
- Newest
- Most votes
- Most comments
0
To start troubleshooting, you could check out the instructions in this link - https://aws.amazon.com/premiumsupport/knowledge-center/athena-hive-cursor-error/
Typically the HIVE_CURSOR_ERROR has to do with the fact that the underlying data does not match the table definition, was a malformed JSON, etc. One thing that would help is to use "S3 Select" to view the files to ensure the data is in the format you expect it to be in. I expect the root cause to be possibly one of the following:
- Corrupted CSV files or malformed JSON
- Parquet or ORC files with incompatible data types
- Corrupted Compression
- Empty Files
- Athena is unable to decrypt the data (probably key used for encryption being deleted)
Given that your Error message is:
HIVE_CURSOR_ERROR: Unable to communicate with downstream services
It may be related to not able to reach the data in S3, so check if encryption/decryption works and Athena has the right access to read the data.
answered 2 years ago
Relevant content
- asked a year ago
- asked 2 years ago
- asked 2 years ago
- Accepted Answerasked 3 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 3 months ago
Hi.
Please share information about the data you are trying to query and the query you used.