drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zhiyong Liu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1063) verification fails with merge join
Date Tue, 24 Jun 2014 21:28:24 GMT
Zhiyong Liu created DRILL-1063:
----------------------------------

             Summary: verification fails with merge join
                 Key: DRILL-1063
                 URL: https://issues.apache.org/jira/browse/DRILL-1063
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Zhiyong Liu


git.commit.id.abbrev=79c1502
git.commit.id=79c1502c1e96596d4db302c2dd1c9f78d0f4d43d

/root/open-source-drill-test/testing/framework/resources/drill-smoke/tpch-smoke-passing/testcases/join06-merge.q
:
alter session set `planner.enable_hashjoin` = false

/root/open-source-drill-test/testing/framework/resources/drill-smoke/tpch-smoke-passing/testcases/join06-merge.q
:

select count(*)
  from supplier s
        join lineitem l on s.s_suppkey = l.l_suppkey
    join orders o on o.o_orderkey = l.l_orderkey
   where l.l_shipdate between date '1995-01-01' and date '1995-12-31'

/root/open-source-drill-test/testing/framework/resources/drill-smoke/tpch-smoke-passing/testcases/join06-merge.q
:

alter session set `planner.enable_hashjoin` = true

         Expected number of rows: 1
Actual number of rows from Drill: 1
         Number of matching rows: 0
          Number of rows missing: 1
       Number of rows unexpected: 1

These rows are not expected (first 10):
        8769

These rows are missing (first 10):
        8773 (1 time(s))


Likewise for /root/open-source-drill-test/testing/framework/resources/drill-smoke/tpch-smoke-passing/testcases/join02-merge.q
:

select count(*)
  from (select c.c_custkey
        from customer c, orders o
        where c.c_custkey = o.o_custkey) as foo

These rows are not expected (first 10):
        14990

These rows are missing (first 10):
        15000 (1 time(s))


Note that it makes no difference whether planner.enable_broadcast_join is turned on or off.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message