Skip to content

Amazon Athena experienced an internal error while executing this query----when executed on partitioned table

0
select * from abdc a where a.employee_id in (select employee_id from abc)

The table abdc is partition projected on employee_id.

** I got this error while executing this query **

Amazon Athena experienced an internal error while executing this query. Please try submitting the query again and if the issue reoccurs, contact AWS support for further assistance. We apologize for the inconvenience.

The same query got executed when I executed --

select * from abdc a where a.employee_id in ('123456789')
AWS
asked 3 years ago415 views
1 Answer
0

Hi, I'm having the same issue. Did you manage to find the cause of the problem and fix it? Thanks

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.