How can I do ALTER TABLE ... DROP COLUMN on an iceberg table struct field in athena?

0

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?

preguntada hace 5 meses83 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas