[jira] [Created] (DRILL-5263) Prevent left NLJoin with non scalar subqueries

["Serhii Harnyk (JIRA)" <ji...@apache.org>]

Serhii Harnyk created DRILL-5263:
------------------------------------

             Summary: Prevent left NLJoin with non scalar subqueries
                 Key: DRILL-5263
                 URL: https://issues.apache.org/jira/browse/DRILL-5263
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Serhii Harnyk
            Assignee: Serhii Harnyk


Nested loop join operator in Drill supports only inner join and returns incorrect result for queries with left join and non scalar sub-queries. Drill should throw error in this case.
Example:
{code:sql}
alter session set planner.enable_nljoin_for_scalar_only=false;
select t2.dt, t1.fyq, t2.who, t2.event
from t2
left join t1 on t2.dt between t1.dts and t1.dte
order by t2.dt;
{code}
Result:
{noformat}
+-------------+----------+----------+--------------------+
|     dt      |   fyq    |   who    |       event        |
+-------------+----------+----------+--------------------+
| 2016-12-26  | 2016-Q2  | aperson  | had chrsitmas      |
| 2017-01-06  | 2016-Q3  | aperson  | did somthing       |
| 2017-01-12  | 2016-Q3  | aperson  | did somthing else  |
+-------------+----------+----------+--------------------+
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)