You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Zhiyong Liu (JIRA)" <ji...@apache.org> on 2014/05/23 01:47:02 UTC
[jira] [Created] (DRILL-821) verification failure for hash join
Zhiyong Liu created DRILL-821:
---------------------------------
Summary: verification failure for hash join
Key: DRILL-821
URL: https://issues.apache.org/jira/browse/DRILL-821
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Reporter: Zhiyong Liu
2014-05-22 16:04:18 INFO QuerySubmitter:93 - Submitting query:
alter session set `planner.enable_mergejoin` = false
2014-05-22 16:04:18 INFO QuerySubmitter:93 - Submitting query:
select o.O_TOTALPRICE
from customer c, orders o
where c.C_CUSTKEY = o.O_CUSTKEY
2014-05-22 16:04:18 INFO QuerySubmitter:93 - Submitting query:
alter session set `planner.enable_mergejoin` = true
2014-05-22 16:04:18 INFO DrillTestBase:212 - Query submit end time: 2014/05/22 16:04:18.0018
2014-05-22 16:04:18 INFO DrillTestBase:213 - The execution time for the query: 0 seconds.
2014-05-22 16:04:19 INFO TestVerifier:203 - These rows are not expected:
2014-05-22 16:04:19 INFO TestVerifier:206 - 93645.3 : 1 time(s).
2014-05-22 16:04:19 INFO TestVerifier:206 - 79836.5 : 1 time(s).
2014-05-22 16:04:19 INFO TestVerifier:206 - 161850.81 : 1 time(s).
2014-05-22 16:04:19 INFO TestVerifier:206 - 115961.79 : 1 time(s).
2014-05-22 16:04:19 INFO TestVerifier:206 - 15203.11 : 1 time(s).
2014-05-22 16:04:19 INFO TestVerifier:206 - 161112.03 : 1 time(s).
2014-05-22 16:04:19 INFO TestVerifier:206 - 4736.16 : 1 time(s).
2014-05-22 16:04:19 INFO TestVerifier:206 - 148993.75 : 1 time(s).
2014-05-22 16:04:19 INFO TestVerifier:206 - 138691.03 : 1 time(s).
2014-05-22 16:04:19 INFO TestVerifier:206 - 315724.81 : 1 time(s).
2014-05-22 16:04:19 INFO TestVerifier:213 - Total number of unexpected rows: 14996
--
This message was sent by Atlassian JIRA
(v6.2#6252)