[DRILL-5263] Prevent left NLJoin with non scalar subqueries

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.10.0
• Assignee: Serhii Harnyk
• Reporter: Serhii Harnyk
• Reviewer: Abhishek Girish
• Created: 14/Feb/17 11:40
• Updated: 27/Mar/17 21:33
• Resolved: 21/Feb/17 15:35

Description

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:

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;

Result:

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

Issue Links

• links to: GitHub Pull Request #748