Athena engine version 3 fail create table query, but on version 2 works good.
Error : "pyathena.error.OperationalError: 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."
Create table not so simple include many sub queries and so one. Is it possible some think is create table query?
Can you post your create table DDL too after removing potential sensitive information.
The issue was fixed by moved couple base views to tables. Looks like query are to heavy for engine3