[ https://issues.apache.org/jira/browse/SPARK-34729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17302043#comment-17302043 ]
Apache Spark commented on SPARK-34729: -------------------------------------- User 'c21' has created a pull request for this issue: https://github.com/apache/spark/pull/31845 > Faster execution for broadcast nested loop join (left semi/anti with no > condition) > ---------------------------------------------------------------------------------- > > Key: SPARK-34729 > URL: https://issues.apache.org/jira/browse/SPARK-34729 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.2.0 > Reporter: Cheng Su > Assignee: Cheng Su > Priority: Minor > Fix For: 3.2.0 > > > For `BroadcastNestedLoopJoinExec` left semi and left anti join without > condition. If we broadcast left side. Currently we check whether every row > from broadcast side has a match or not by iterating broadcast side a lot of > time - > [https://github.com/apache/spark/blob/master/sql/core/src/main/scala/org/apache/spark/sql/execution/joins/BroadcastNestedLoopJoinExec.scala#L256-L275] > . This is unnecessary, as there's no condition, and we only need to check > whether stream side is empty or not. Create this Jira to add the > optimization. This can boost the affected query execution performance a lot. -- 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