[
https://issues.apache.org/jira/browse/PHOENIX-68?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13908926#comment-13908926
]
ASF GitHub Bot commented on PHOENIX-68:
---------------------------------------
GitHub user maryannxue reopened a pull request:
https://github.com/apache/incubator-phoenix/pull/9
PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join
optimization is preferred for multi inner join queries
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/maryannxue/incubator-phoenix master
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-phoenix/pull/9.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 #9
----
commit 05b584181fe36102feca765886fcda75b770b2b2
Author: maryannxue <[email protected]>
Date: 2014-02-12T21:41:53Z
Fix PHOENIX-44 Cannot create index on tables with case-sensitive schema
names
commit 02af57c96476c9d205d07ba96974c49188a282fa
Author: maryannxue <[email protected]>
Date: 2014-02-21T02:54:17Z
Merge remote-tracking branch 'asf/master'
commit bd20346da5336d3d240493fdbfbcd5cc03280810
Author: maryannxue <[email protected]>
Date: 2014-02-21T03:08:23Z
PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join
optimization is preferred for multi inner join queries
commit 9a2ced8936d6cedbc44a4ed2de2c6f72f4f4307f
Author: maryannxue <[email protected]>
Date: 2014-02-21T04:59:29Z
PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join
optimization is preferred for multi inner join queries
commit 20a97904e48829f8b412bcfb0ac2084259133126
Author: maryannxue <[email protected]>
Date: 2014-02-21T05:53:21Z
PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join
optimization is preferred for multi inner join queries
commit 7568516fabfb416f5dcbfa89468b839963802a87
Author: maryannxue <[email protected]>
Date: 2014-02-21T22:14:14Z
Revert "PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join
optimization is preferred for multi inner join queries"
This reverts commit 20a97904e48829f8b412bcfb0ac2084259133126.
commit 3fb95819959d22deb2c03e895d976e7d933007f2
Author: maryannxue <[email protected]>
Date: 2014-02-21T22:14:56Z
Revert "PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join
optimization is preferred for multi inner join queries"
This reverts commit 9a2ced8936d6cedbc44a4ed2de2c6f72f4f4307f.
commit ca0b55d048a6c547a5d6b081dd84dea01011e5c1
Author: maryannxue <[email protected]>
Date: 2014-02-21T22:16:13Z
Revert "PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join
optimization is preferred for multi inner join queries"
This reverts commit bd20346da5336d3d240493fdbfbcd5cc03280810.
commit c4df65791a163070362662aad7ce5916faa3c3d7
Author: maryannxue <[email protected]>
Date: 2014-02-21T22:18:13Z
Merge remote-tracking branch 'asf/master'
commit 9b5df132480b6bd25c0c33dd818278a5fc1b3f55
Author: maryannxue <[email protected]>
Date: 2014-02-21T22:22:38Z
PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join
optimization is preferred for multi inner join queries
----
> Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization is
> preferred for multi inner join queries
> ------------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-68
> URL: https://issues.apache.org/jira/browse/PHOENIX-68
> Project: Phoenix
> Issue Type: Improvement
> Affects Versions: 3.0.0
> Reporter: Maryann Xue
> Assignee: Maryann Xue
> Priority: Minor
> Fix For: 3.0.0
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> We enable an option called "FAVOR_STAR_JOIN" to allow for choosing different
> execution plans for multi inner join queries.
> For example:
> select * from A inner join B on A.ab_id = B.ab_id inner join C on A.ac_id =
> C.ac_id and B.bc_id = C.bc_id;
> When using star-join optimization, the execution steps will be like:
> hash B, hash C --> join A
> If star-join is turned off, the execution steps will be like:
> hash A --> join B --> hash temp result AB --> join C
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
