You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2014/03/06 01:57:11 UTC
[jira] [Commented] (PHOENIX-68) Add hint "NO_STAR_JOIN" to indicate
if star join optimization should be avoided for multi inner join queries
[ https://issues.apache.org/jira/browse/PHOENIX-68?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13921783#comment-13921783 ]
Hudson commented on PHOENIX-68:
-------------------------------
FAILURE: Integrated in Apache Phoenix - Branch:4.0 #35 (See [https://builds.apache.org/job/Phoenix-4.0/35/])
PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization is preferred for multi inner join queries (maryannxue: rev 8fe0dd9a04e5acdccdba8a412b35899bd50bbcf6)
* phoenix-core/src/main/java/org/apache/phoenix/parse/HintNode.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/JoinCompiler.java
* phoenix-core/src/test/java/org/apache/phoenix/end2end/HashJoinTest.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/QueryCompiler.java
PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization is preferred for multi inner join queries (maryannxue: rev 67c9615161420e14ee92ce1acf570a0f92d2d70b)
* phoenix-core/src/main/java/org/apache/phoenix/compile/JoinCompiler.java
> Add hint "NO_STAR_JOIN" to indicate if star join optimization should be avoided 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 a SQL hint called "NO_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.2#6252)