Join Query Filter

[abhishek1015]

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.

[jtaylor-sfdc]

@abhishek1015 - nice find. Our github project has been moved to Apache now. Would you mind filing this issue as a JIRA over there (https://issues.apache.org/jira/browse/PHOENIX)? As an incentive, I may have a work around for you. :-)

[abhishek1015]

thanks for prompt reply.

Jira: https://issues.apache.org/jira/browse/PHOENIX-16

waiting for work around :)