Error When Running VACUUM

Question

I have created an Iceberg table on Athena with table property **vacuum_min_snapshots_to_keep**. I am running command `VACUUM hamza_iceberg_table;` , upon running this command I am getting below mentioned error:

```
[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.
This query ran against the "db-name" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: a12te0e1a84-4028-87d3-a6e2
```

Answer

Hello, 
Thank you for reporting this issue.

Shared error message "I**NTERNAL_ERROR_QUERY_ENGINE**" is generic error that can be occurred by various reason such as insufficient Lake Formation, incorrect DDL  provided, s3 bucket is encrypted and so on.. To troubleshoot this issue,  I would like to suggest you to create support case and provide the details such as  Region and Execution Query Id  and complete error message..

Thank you for using Amazon Athena.

Error When Running VACUUM

Relevant content