[
https://issues.apache.org/jira/browse/SPARK-36823?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17418443#comment-17418443
]
Apache Spark commented on SPARK-36823:
--------------------------------------
User 'ulysses-you' has created a pull request for this issue:
https://github.com/apache/spark/pull/34069
> Support broadcast nested loop join hint for equi-join
> -----------------------------------------------------
>
> Key: SPARK-36823
> URL: https://issues.apache.org/jira/browse/SPARK-36823
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.3.0
> Reporter: XiDuo You
> Priority: Major
>
> For the join if one side is small and other side is large, the shuffle
> overhead is also very big. Due to the
> bhj limitation, we can only broadcast right side for left join and left side
> for right join. So for the other case, we can try to use
> `BroadcastNestedLoopJoin` as the join strategy.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
