cloud-fan commented on code in PR #36177:
URL: https://github.com/apache/spark/pull/36177#discussion_r851956373


##########
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/optimizer/joins.scala:
##########
@@ -127,10 +128,19 @@ object ReorderJoin extends Rule[LogicalPlan] with 
PredicateHelper {
  * - full outer -> right outer if only the right side has such predicates
  *
  * 2. Removes outer join if it only has distinct on streamed side
+ *
  * {{{
  *   SELECT DISTINCT f1 FROM t1 LEFT JOIN t2 ON t1.id = t2.id  ==>  SELECT 
DISTINCT f1 FROM t1
  * }}}
  *
+ * 3. Remove outer join if aggregate references are coming from streamed side 
and

Review Comment:
   Can we combine the doc of points 2 and 3? Let's define "Duplicate Agnostic" 
in the classdoc.



-- 
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.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to