You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Maryann Xue (JIRA)" <ji...@apache.org> on 2014/02/21 03:51:20 UTC
[jira] [Created] (PHOENIX-68) Add Option "FAVOR_STAR_JOIN" to
indicate if star join optimization is preferred for multi inner join
queries
Maryann Xue created PHOENIX-68:
----------------------------------
Summary: 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
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)