[
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: [email protected]
For additional commands, e-mail: [email protected]
