GitHub user gatorsmile opened a pull request:
https://github.com/apache/spark/pull/10551
[SPARK-12602] [SQL] Join Reordering: Pushing Inner Join Through Left/Right
Outer Join
This PR is to push `Inner Join` through `Left/Right Outer Join`. This can
reduce the number of processed rows since the `Inner Join` always can generate
less rows than `Left/Right Outer Join`.
This PR can improve the query performance, if applicable.
For example,
TODO: added test cases into optimizer buckets.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gatorsmile/spark outerInnerReordering
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/10551.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 #10551
----
commit 41703c2c3570137d67d8ead873fda25ce11075e1
Author: gatorsmile <[email protected]>
Date: 2016-01-02T04:04:27Z
Merge remote-tracking branch 'upstream/master' into outerInnerReordering
commit 7237f618b8f0728a1f1585e1f4db155e6d38519b
Author: gatorsmile <[email protected]>
Date: 2016-01-02T04:04:38Z
reorder outer and inner joins
commit d9b54115f6dbd3e815963cec702a4a8aae28c154
Author: gatorsmile <[email protected]>
Date: 2016-01-02T04:18:32Z
renaming.
----
---
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]
