You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Kevin Liew (JIRA)" <ji...@apache.org> on 2016/07/06 20:10:11 UTC

[jira] [Created] (PHOENIX-3053) Allow literal comparison in JOIN...ON

Kevin Liew created PHOENIX-3053:
-----------------------------------

             Summary: Allow literal comparison in JOIN...ON
                 Key: PHOENIX-3053
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3053
             Project: Phoenix
          Issue Type: Improvement
    Affects Versions: 4.7.0
            Reporter: Kevin Liew
            Priority: Minor


bq. select * FROM emp INNER JOIN addr ON emp.last_name = addr.last_name *AND* emp.first_name = 'Chuck'

should return the same results as 

bq. select * FROM emp INNER JOIN addr ON emp.last_name = addr.last_name *WHERE* emp.first_name = 'Chuck'

but the first query is more performant because it filters before joining. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)