search

forcedotcom / phoenix

BSD 3-Clause "New" or "Revised" License
558 stars 227 forks source link

Join Query Filter #721

Open abhishek1015 opened 10 years ago

abhishek1015 commented 10 years ago

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 commented 10 years ago

@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 commented 10 years ago

thanks for prompt reply.

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

waiting for work around :)