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/03 00:24:09 UTC

[jira] [Resolved] (PHOENIX-16) Where clause optimization in join queries

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

Maryann Xue resolved PHOENIX-16.
--------------------------------

       Resolution: Fixed
    Fix Version/s: 3.0.0

> Where clause optimization in join queries
> -----------------------------------------
>
>                 Key: PHOENIX-16
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-16
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 3.0.0
>            Reporter: abhishek
>            Assignee: Maryann Xue
>             Fix For: 3.0.0
>
>
> select * from t1 inner join t2 on t1.col1 = t2.col2 where t1.id < 1000 and t2.id < 1000
> For above query, phoenix first join the tables t1 and t2, and then apply the filter t1.id < 1000 and t2.id < 1000. This is very inefficient. This can be easily fixed by pushing the filter operation before the join query.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)