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)
