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

["Aman Sinha (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aman Sinha reassigned DRILL-485:
--------------------------------

    Assignee: Aman Sinha

> 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)