GitHub user davies opened a pull request:
https://github.com/apache/spark/pull/10653
[SPARK-12700] [SQL] embed condition into SMJ and BroadcastHashJoin
Currently SortMergeJoin and BroadcastHashJoin do not support condition, the
need a followed Filter for that, the result projection to generate UnsafeRow
could be very expensive if they generate lots of rows and could be filtered
mostly by condition.
This PR brings the support of condition for SortMergeJoin and
BroadcastHashJoin, just like other outer joins do.
This could improve the performance of Q72 by 7x (from 120s to 16.5s).
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/davies/spark filter_join
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/10653.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #10653
----
commit a38d623d7d57709f2f26b1189ff699c02bd0ca57
Author: Davies Liu <[email protected]>
Date: 2016-01-07T23:05:50Z
embed condition into SMJ and BroadcastHashJoin
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
