xianyinxin commented on a change in pull request #26167: [SPARK-28893][SQL]
Support MERGE INTO in the parser and add the corresponding logical plan
URL: https://github.com/apache/spark/pull/26167#discussion_r344123806
##########
File path:
sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4
##########
@@ -477,10 +483,32 @@ selectClause
;
setClause
- : SET assign (',' assign)*
+ : SET assignmentList
;
-assign
+matchedClause
+ : WHEN MATCHED (AND matchedCond=booleanExpression)? THEN matchedAction
+ ;
+notMatchedClause
+ : WHEN NOT MATCHED (AND notMatchedCond=booleanExpression)? THEN
notMatchedAction
+ ;
+
+matchedAction
+ : DELETE
+ | UPDATE SET ASTERISK
+ | UPDATE SET assignmentList
+ ;
+
+notMatchedAction
+ : INSERT ASTERISK
+ | INSERT '(' columns=multipartIdentifierList ')' VALUES values=valueList
Review comment:
Discussed offline. We can support INSERT, but that needs some extra efforts.
Maybe later we can open a topic to handle the nested columns processing in
UPDATE/MERGE.
----------------------------------------------------------------
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]
