Aman Sinha created DRILL-485:
--------------------------------
Summary: Support non-equijoins as long as there is at least 1
equijoin condition between the same 2 tables
Key: DRILL-485
URL: https://issues.apache.org/jira/browse/DRILL-485
Project: Apache Drill
Issue Type: Bug
Reporter: Aman Sinha
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);
--
This message was sent by Atlassian JIRA
(v6.2#6252)
