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

jhall
asked a year ago195 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions