You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Arina Ielchiieva (JIRA)" <ji...@apache.org> on 2017/04/03 09:20:41 UTC
[jira] [Created] (DRILL-5407) Show NxM rows processed in the nested
loop join
Arina Ielchiieva created DRILL-5407:
---------------------------------------
Summary: Show NxM rows processed in the nested loop join
Key: DRILL-5407
URL: https://issues.apache.org/jira/browse/DRILL-5407
Project: Apache Drill
Issue Type: Improvement
Affects Versions: 1.9.0
Reporter: Arina Ielchiieva
Priority: Minor
{noformat}
alter session set `planner.enable_nljoin_for_scalar_only` = false;
create temporary table t1 as select i1, i2 from (
select 0 as i1, 5 as i2 from (values(1))
union all
select 5 as i1, 10 as i2 from (values(1)));
create temporary table t2 as select i1, i2 from (
select 0 as i1, 1 as i2 from (values(1))
union all
select 7 as i1, 2 as i2 from (values(1))
union all
select -1 as i1, 3 as i2 from (values(1)));
select * from t2 tt2 inner join t1 tt1 on tt2.i1 between tt1.i1 and tt1.i2;
{noformat}
In Query Profile Operators tab, Rows info for Nested loop join shows 5 rows but should show NxM (=6).
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)