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?

demandé il y a 6 mois83 vues
Aucune réponse

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions