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?
Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.
Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.