rdblue commented on a change in pull request #24723: [SPARK-27857][SQL] Move
ALTER TABLE parsing into Catalyst
URL: https://github.com/apache/spark/pull/24723#discussion_r289471531
##########
File path:
sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4
##########
@@ -113,14 +113,29 @@ statement
LIKE source=tableIdentifier locationSpec?
#createTableLike
| ANALYZE TABLE tableIdentifier partitionSpec? COMPUTE STATISTICS
(identifier | FOR COLUMNS identifierSeq | FOR ALL COLUMNS)? #analyze
- | ALTER TABLE tableIdentifier
- ADD COLUMNS '(' columns=colTypeList ')'
#addTableColumns
Review comment:
Yes. PostgreSQL, MySQL, and Oracle support this for a single column.
PosgreSQL doesn't allow multiple columns. MySQL allows multiple columns without
parens. And Oracle requires parens to add multiple columns. These don't assist
parsing, which is why I think it is better to optionally support them.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
