drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arina Ielchiieva (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5407) Show NxM rows processed in the nested loop join
Date Mon, 03 Apr 2017 09:20:41 GMT
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)

Mime
View raw message