Iceberg table drop column leaves the column in the Athena Glue catalog
1
When I execute the following:
alter table <db_name>.<table_name> drop column <column_name>
The column name remains in the Glue catalog. We're using Athena v3 engine. I also used the following to create the table:
create table <db_name>.<table_name> with (
table_type = 'ICEBERG',
format = 'Parquet',
write_compression = 'SNAPPY',
is_external = false,
location = 's3://<bucket_and_folder_path>/'
) as
select statement