[ https://issues.apache.org/jira/browse/SPARK-35442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
XiDuo You updated SPARK-35442: ------------------------------ Description: If Aggregate and Join have the same output partitioning, the plan will look like: {code:java} SortMergeJoin Sort HashAggregate Shuffle Sort xxx{code} Currently `EliminateUnnecessaryJoin` doesn't support optimize this case. Logically, if the Aggregate grouping expression is not empty, we can eliminate it safely. was: If Aggregate and Join have the same output partitioning, the plan will look like: {code:java} SortMergeJoin Sort HashAggregate Shuffle Sort xxx{code} Currently `EliminateUnnecessaryJoin` doesn't support optimize this case. Logically, if the Aggregate grouping expression is not empty, we can safe eliminate it. > Eliminate unnecessary join through Aggregate > -------------------------------------------- > > Key: SPARK-35442 > URL: https://issues.apache.org/jira/browse/SPARK-35442 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.2.0 > Reporter: XiDuo You > Priority: Minor > > If Aggregate and Join have the same output partitioning, the plan will look > like: > {code:java} > SortMergeJoin > Sort > HashAggregate > Shuffle > Sort > xxx{code} > > Currently `EliminateUnnecessaryJoin` doesn't support optimize this case. > Logically, if the Aggregate grouping expression is not empty, we can > eliminate it safely. > -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org