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] [Resolved] (DRILL-821) verification failure for hash join
Date Fri, 23 May 2014 17:53:01 GMT

     [ 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)

Mime
View raw message