You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/04/29 22:36:09 UTC
[jira] [Closed] (DRILL-1063) verification fails with merge join
[ https://issues.apache.org/jira/browse/DRILL-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli closed DRILL-1063.
------------------------------------
Verifed. Below is the testcase
Functional/Passing/tpch-smoke/join02-merge.q
> 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
> Assignee: DrillCommitter
> Priority: Critical
> Fix For: 0.5.0
>
> Attachments: DRILL-1063.patch
>
>
> 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.3.4#6332)