spark-reviews mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From davies <>
Subject [GitHub] spark pull request: [SPARK-12700] [SQL] embed condition into SMJ a...
Date Thu, 07 Jan 2016 23:16:05 GMT
GitHub user davies opened a pull request:

    [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 filter_join

Alternatively you can review and apply these changes as the patch at:

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 <>
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 or file a JIRA ticket
with INFRA.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message