[
https://issues.apache.org/jira/browse/DRILL-485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13968792#comment-13968792
]
Aman Sinha commented on DRILL-485:
----------------------------------
I had checked in a fix for this in the TPCH branch, commit level 2f0da33. It
should get merged into master branch sometime soon.
> 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
> Assignee: 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)
