[jira] [Updated] (PHOENIX-68) Add hint "NO_STAR_JOIN" to indicate if star join optimization should be avoided for multi inner join queries

["Maryann Xue (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-68?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maryann Xue updated PHOENIX-68:
-------------------------------

    Summary: Add hint "NO_STAR_JOIN" to indicate if star join optimization should be avoided for multi inner join queries  (was: Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization is preferred for multi inner join queries)

> 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 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)