You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "XiDuo You (Jira)" <ji...@apache.org> on 2021/05/27 09:56:00 UTC
[jira] [Reopened] (SPARK-35442) Eliminate unnecessary join through
Aggregate
[ 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org