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 19:53:01 UTC
[jira] [Resolved] (DRILL-821) verification failure for hash join
[ https://issues.apache.org/jira/browse/DRILL-821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhiyong Liu resolved DRILL-821.
-------------------------------
Resolution: Invalid
> 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)