[ https://issues.apache.org/jira/browse/SPARK-38939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jackie Zhang updated SPARK-38939: --------------------------------- Description: Currently `ALTER TABLE ... DROP COLUMN(s) ...` syntax will always throw error if the column doesn't exist. We would like to provide an (IF EXISTS) syntax to provide better user experience for downstream handlers (such as Delta) that support it, and make consistent with some other DMLs such as `DROP TABLE (IF EXISTS)` (was: Currently `ALTER TABLE ... DROP COLUMN(s) ...` syntax will always throw error if the column doesn't exist. We would like to provide an (IF EXISTS) syntax to provide better user experience, and make consistent with some other DMLs such as `DROP TABLE (IF EXISTS)` etc.) > Support ALTER TABLE ... DROP COLUMN [IF EXISTS] .. syntax > --------------------------------------------------------- > > Key: SPARK-38939 > URL: https://issues.apache.org/jira/browse/SPARK-38939 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.2.0, 3.2.1, 3.3.0 > Reporter: Jackie Zhang > Priority: Major > > Currently `ALTER TABLE ... DROP COLUMN(s) ...` syntax will always throw error > if the column doesn't exist. We would like to provide an (IF EXISTS) syntax > to provide better user experience for downstream handlers (such as Delta) > that support it, and make consistent with some other DMLs such as `DROP TABLE > (IF EXISTS)` -- This message was sent by Atlassian Jira (v8.20.1#820001) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org