[ https://issues.apache.org/jira/browse/SPARK-33429?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17238615#comment-17238615 ]
jiaan.geng commented on SPARK-33429: ------------------------------------ It seems Spark has supported {code:java} | ALTER TABLE multipartIdentifier DROP (COLUMN | COLUMNS) '(' columns=multipartIdentifierList ')' #dropTableColumns | ALTER TABLE multipartIdentifier DROP (COLUMN | COLUMNS) columns=multipartIdentifierList #dropTableColumns {code} > Support drop column in spark also like in postgresql > ---------------------------------------------------- > > Key: SPARK-33429 > URL: https://issues.apache.org/jira/browse/SPARK-33429 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 2.4.5 > Reporter: jobit mathew > Priority: Minor > > Support alter table with drop column in spark also like in postgresql. > > [https://www.postgresql.org/docs/12/sql-altertable.html] > alter table tablename DROP COLUMN/columns [ IF EXISTS ] > columnname > > {code:java} > spark-sql> drop database if exists hivemetastoretest cascade; > Time taken: 1.067 seconds > spark-sql> create database hivemetastoretest; > Time taken: 0.326 seconds > spark-sql> use hivemetastoretest; > Time taken: 0.053 seconds > spark-sql> create table jobit4 using parquet as select 2.5; > Time taken: 5.058 seconds > spark-sql> alter table jobit4 add columns(name string); > Time taken: 1.194 seconds > spark-sql> alter table jobit4 drop columns(name); > Error in query: > mismatched input 'columns' expecting \{'PARTITION', 'IF'}(line 1, pos 25) > == SQL == > alter table jobit4 drop columns(name) > -------------------------^^^ > spark-sql> alter table jobit4 drop columns name; > Error in query: > mismatched input 'columns' expecting \{'PARTITION', 'IF'}(line 1, pos 25) > == SQL == > alter table jobit4 drop columns name > -------------------------^^^ > spark-sql> [ > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org