[
https://issues.apache.org/jira/browse/DRILL-485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14029588#comment-14029588
]
Jacques Nadeau commented on DRILL-485:
--------------------------------------
fixed in recent build
> 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
> Components: Query Planning & Optimization
> Reporter: Aman Sinha
> Assignee: DrillCommitter
> Fix For: 1.0.0-BETA1
>
>
> 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)
