[ 
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

Reply via email to