[GitHub] [spark] viirya commented on a change in pull request #32303: [SPARK-34382][SQL] Support LATERAL subqueries

[GitBox <gi...@apache.org>]

viirya commented on a change in pull request #32303:
URL: https://github.com/apache/spark/pull/32303#discussion_r619569665



##########
File path: sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4
##########
@@ -588,7 +588,7 @@ hintStatement
     ;
 
 fromClause
-    : FROM relation (',' relation)* lateralView* pivotClause?
+    : FROM relation (',' lateralClause)* (',' relation)* lateralView* pivotClause?

Review comment:
       I think it was mentioned in the [manual](https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-LATERAL):
   
   > A LATERAL item can appear at top level in the FROM list, or within a JOIN tree. In the latter case it can also refer to any items that are on the left-hand side of a JOIN that it is on the right-hand side of. 




-- 
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org