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?
로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.
좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.