[
https://issues.apache.org/jira/browse/SPARK-35442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
XiDuo You reopened SPARK-35442:
-------------------------------
> 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
