[DRILL-485] Support non-equijoins as long as there is at least 1 equijoin condition between the same 2 tables

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Query Planning & Optimization
• Assignee: DrillCommitter
• Reporter: Aman Sinha
• Created: 04/Apr/14 01:43
• Updated: 12/Jun/14 18:44
• Resolved: 12/Jun/14 18:44

Description

Currently, if the query has a non-equijoin between tables t1, t2 we throw an error that it is unsupported. However, if there is at least one equijoin between the tables t1, t2 in addition to the non-equijoin, then we should perform the join and then do a filter on top using the non-equijoin condition.
example queries where this could be applicable:
SELECT a1 FROM t1, t2 WHERE b1 = b2 AND c1 < c2;
SELECT a1 FROM t1, t2 WHERE b1 = b2 AND (c1 = c2 OR d1 = d2);