Repository: spark
Updated Branches:
  refs/heads/master b7b5e1787 -> 1b5c9e52a


[SPARK-16530][SQL][TRIVIAL] Wrong Parser Keyword in ALTER TABLE CHANGE COLUMN

#### What changes were proposed in this pull request?
Based on the [Hive SQL 
syntax](https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ChangeColumnName/Type/Position/Comment),
 the command to change column name/type/position/comment is `ALTER TABLE CHANGE 
COLUMN`. However, in our .g4 file, it is `ALTER TABLE CHANGE COLUMNS`. Because 
it is the last optional keyword, it does not take any effect. Thus, I put the 
issue as a Trivial level.

cc hvanhovell

#### How was this patch tested?
Existing test cases

Author: gatorsmile <gatorsm...@gmail.com>

Closes #14186 from gatorsmile/changeColumns.


Project: http://git-wip-us.apache.org/repos/asf/spark/repo
Commit: http://git-wip-us.apache.org/repos/asf/spark/commit/1b5c9e52
Tree: http://git-wip-us.apache.org/repos/asf/spark/tree/1b5c9e52
Diff: http://git-wip-us.apache.org/repos/asf/spark/diff/1b5c9e52

Branch: refs/heads/master
Commit: 1b5c9e52a7d5cdd3b4da1334ddff0518a8e14505
Parents: b7b5e17
Author: gatorsmile <gatorsm...@gmail.com>
Authored: Thu Jul 14 17:15:51 2016 +0200
Committer: Herman van Hovell <hvanhov...@databricks.com>
Committed: Thu Jul 14 17:15:51 2016 +0200

----------------------------------------------------------------------
 .../main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4    | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/spark/blob/1b5c9e52/sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4
----------------------------------------------------------------------
diff --git 
a/sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4 
b/sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4
index 7ccbb2d..5e10462 100644
--- 
a/sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4
+++ 
b/sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4
@@ -170,7 +170,7 @@ unsupportedHiveNativeCommands
     | kw1=ALTER kw2=TABLE tableIdentifier partitionSpec? kw3=CONCATENATE
     | kw1=ALTER kw2=TABLE tableIdentifier partitionSpec? kw3=SET kw4=FILEFORMAT
     | kw1=ALTER kw2=TABLE tableIdentifier partitionSpec? kw3=ADD kw4=COLUMNS
-    | kw1=ALTER kw2=TABLE tableIdentifier partitionSpec? kw3=CHANGE 
kw4=COLUMNS?
+    | kw1=ALTER kw2=TABLE tableIdentifier partitionSpec? kw3=CHANGE kw4=COLUMN?
     | kw1=ALTER kw2=TABLE tableIdentifier partitionSpec? kw3=REPLACE 
kw4=COLUMNS
     | kw1=START kw2=TRANSACTION
     | kw1=COMMIT


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org
For additional commands, e-mail: commits-h...@spark.apache.org

Reply via email to