Details
-
New Feature
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Certain tools still generate `old style' Join queries where the join
condition is in the Where clause. A related set of issues that can
be addressed is that of pushing forward joining conditions;
in a manner similar to the Predicate Pushdown feature of Hive.
For e.g. these queries can have join conditions pushed down:
- query 1, push join predicate from 2nd join to 1st explain select * from part p1 join part p2 join part p3 on p1.p_name = p2.p_name and p2.p_name = p3.p_name; - query 2 explain select * from part p1 join part p2 join part p3 where p1.p_name = p2.p_name and p2.p_name = p3.p_name;
Attachments
Attachments
Issue Links
1.
|
Pushdown join conditions | Resolved | Harish Butani | |
2.
|
Push down qualifying Where clause predicates as join conditions | Resolved | Harish Butani | |
3.
|
Support alternate join syntax | Resolved | Harish Butani | |
4.
|
Remove predicates that are pushed forward as join conditions from where clause | Open | Unassigned |