[Athena] Error creating Iceberg table

Question

I am trying to create iceberg table with CTAS using CLI but getting internal error.
Using athena engine version 3
Here is my query
CREATE TABLE test_db_2.test_table_2
    WITH (table_type = 'ICEBERG',
        format = 'PARQUET',
        location = 's3://bucket_namexxx/test_db_2/test_table_2/',
        is_external = false
        )
AS SELECT col1, col2, col3 from test_db_1.test_table_1;

FAILED  [ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal error while executing this query. Please contact AWS support for further assistance. You will not be charged for this query. We apologize for the inconvenience. You may need to manually clean the data at location 's3://xxxxxx/tables/3xxxxxxxxxxx' before retrying. Athena will not delete data in your account.

Any idea what is the issue? Where can I see the detailed error?

manny · Answer

Found a typo in the bucket name.. I wish the internal logs are available to us for these kind of error.

secondabhi_aws · Answer

Did you try adding **From** keyword in second part of your query as below:

CREATE TABLE test_db_2.test_table_2 WITH (table_type = 'ICEBERG', format = 'PARQUET', location = 's3://bucket_namexxx/test_db_2/test_table_2/', is_external = false ) AS SELECT col1, col2, col3 from test_db_1.test_table_1;

Also, did you try running the same query in different engine version.

Most probable cause of this type of error use to be, when we mistakenly use Athena reserved keyword listed [here](https://docs.aws.amazon.com/athena/latest/ug/reserved-words.html), but it doesn't seem to be the case here.

Comment here how it goes, happy to help.

Abhishek

[Athena] Error creating Iceberg table

Relevant content