[
https://issues.apache.org/jira/browse/PHOENIX-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maryann Xue updated PHOENIX-1399:
---------------------------------
Attachment: 1399.patch
1. Parse a,b,c as: a join b join c
2. Push conditions in where clause as join conditions
3. If any equi-join condition gets pushed down for a join b, a join b is
essentially an inner join.
4. If no equi-join condition is available for a join b, then a join b actually
becomes a cross join, each row in a will join with each row in b, and non-equi
conditions between a and b will serve as server-side post-filters after the
cross join.
> Support cross joins and comma-separated table list
> --------------------------------------------------
>
> Key: PHOENIX-1399
> URL: https://issues.apache.org/jira/browse/PHOENIX-1399
> Project: Phoenix
> Issue Type: New Feature
> Affects Versions: 3.0.0, 4.0.0, 5.0.0
> Reporter: Maryann Xue
> Assignee: Maryann Xue
> Attachments: 1399.patch
>
> Original Estimate: 72h
> Remaining Estimate: 72h
>
> Support grammar like:
> select * from a, b, c where a.col1 = b.col1 and b.col2 = c.col2;
> or
> select * from a, b where a.col1 > b.col1;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
