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')