According to https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-evolving-table-schema.html
Drop – Removes an existing column from a table or nested struct.
However in https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-evolving-table-schema.html#querying-iceberg-alter-table-drop-column there is no example listed. According to https://iceberg.apache.org/docs/latest/spark-ddl/#alter-table--drop-column
ALTER TABLE db.foo_table DROP COLUMN col.struct_name;
should work, but results in:
Cannot delete missing column: col.struct_name
Is this not possible?
ログインしていません。 ログイン 回答を投稿する。
優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。