drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Issue Comment Deleted] (DRILL-4321) Difference in results count distinct with min max query on JDK8
Date Fri, 05 Feb 2016 04:50:39 GMT

     [ https://issues.apache.org/jira/browse/DRILL-4321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Khurram Faraaz updated DRILL-4321:
----------------------------------
    Comment: was deleted

(was: Here is a diff from one of the expected results file and actual result file

{noformat}
[root@centos-01 drill-output]# diff aggregation_count_distinct_with_min_max_c_float_group_by_1_cols.output_Wed_Feb_03_09\:35\:59_UTC_2016
../resources/Functional/aggregates/aggregation/count_distinct/with_min_max_c_float_group_by_1_cols.res
1,40c1,40
< 1	3.36566451E9	3.36566451E9
< 1	9.256617E9	9.256617E9
< 2	4.04348237E9	2.12573875E9
< 4	4.9559644E9	1.05473766E9
< 1	3.81062374E9	3.81062374E9
< 1	9.6313928E9	9.6313928E9
< 1	8.7592694E9	8.7592694E9
< 2	6.0153508E9	2.65311632E8
< 3	7.6130918E9	4.2491031E9
< 1	9.0065581E8	9.0065581E8
< 1	8.3431869E9	8.3431869E9
< 2	6.4945516E9	4.8821535E9
< 1	4.8821535E9	4.8821535E9
< 1	8.5622006E9	8.5622006E9
< 1	9.2245773E8	9.2245773E8
< 1	9.7465047E9	9.7465047E9
< 1	9.7358019E9	9.7358019E9
< 1	7.3684045E9	7.3684045E9
< 1	4.6957604E9	4.6957604E9
< 1	8.6464809E9	8.6464809E9
< 2	4.8821535E9	4.6272799E9
< 1	6.0612782E9	6.0612782E9
< 3	8.4614692E9	1.61986854E9
< 1	7.847274E9	7.847274E9
< 1	5.1320079E9	5.1320079E9
< 1	2.058368E9	2.058368E9
< 1	3.74600294E9	3.74600294E9
< 1	8.0027725E9	8.0027725E9
< 2	5.14784E9	1.0746761E9
< 1	1.64344474E9	1.64344474E9
< 1	2.65839642E9	2.65839642E9
< 3	7.9820442E9	1.13833536E9
< 1	7.3506591E9	7.3506591E9
< 1	3.06849459E9	3.06849459E9
< 4	8.3426207E9	4.7834511E9
< 2	8.4342758E9	5.3641876E9
< 1	6.7724529E9	6.7724529E9
< 1	9.8121043E8	9.8121043E8
< 1	5.9523226E9	5.9523226E9
< 1	9.6309586E9	9.6309586E9
---
> 1	3.3656644402072E9	3.3656644402072E9
> 1	9.2566169193014E9	9.2566169193014E9
> 2	4.0434823185206E9	2.1257387986407E9
> 4	4.9559641676024E9	1.0547376889736E9
> 1	3.8106236467138E9	3.8106236467138E9
> 1	9.6313928300514E9	9.6313928300514E9
> 1	8.7592688947916E9	8.7592688947916E9
> 2	6.0153509723022E9	2.653116267175E8
> 3	7.6130917528644E9	4.249103073962E9
> 1	9.00655835867E8	9.00655835867E8
> 1	8.3431868813932E9	8.3431868813932E9
> 2	6.4945515245199E9	4.8821532446891E9
> 1	4.8821532446891E9	4.8821532446891E9
> 1	8.5622004792094E9	8.5622004792094E9
> 1	9.224577294663E8	9.224577294663E8
> 1	9.7465045982971E9	9.7465045982971E9
> 1	9.735801955685E9	9.735801955685E9
> 1	7.36840441823E9	7.36840441823E9
> 1	4.6957604074851E9	4.6957604074851E9
> 1	8.6464804643765E9	8.6464804643765E9
> 2	4.8821532446891E9	4.6272797835991E9
> 1	6.0612780321389E9	6.0612780321389E9
> 3	8.4614690393209E9	1.6198685113341E9
> 1	7.847273889929E9	7.847273889929E9
> 1	5.1320076920092E9	5.1320076920092E9
> 1	2.0583680365235E9	2.0583680365235E9
> 1	3.7460028240457E9	3.7460028240457E9
> 1	8.0027724104002E9	8.0027724104002E9
> 2	5.1478397473693E9	1.0746760945768E9
> 1	1.6434447094798E9	1.6434447094798E9
> 1	2.6583965402097E9	2.6583965402097E9
> 3	7.9820440383628E9	1.1383354151622E9
> 1	7.3506593005731E9	7.3506593005731E9
> 1	3.0684946943075E9	3.0684946943075E9
> 4	8.3426206884905E9	4.7834511473775E9
> 2	8.4342756215483E9	5.3641876811162E9
> 1	6.7724530631676E9	6.7724530631676E9
> 1	9.812104469166E8	9.812104469166E8
> 1	5.9523228136822E9	5.9523228136822E9
> 1	9.6309590851888E9	9.6309590851888E9
42,55c42,55
< 1	3.20343066E9	3.20343066E9
< 1	5.7848493E8	5.7848493E8
< 1	4.5705989E9	4.5705989E9
< 1	7.8424591E9	7.8424591E9
< 1	2.03053683E9	2.03053683E9
< 1	2.81221376E9	2.81221376E9
< 2	7.3630541E9	1.17997952E9
< 2	6.7484339E9	6.2992031E9
< 1	-4.6873795E9	-4.6873795E9
< 2	9.9837839E9	3.24936192E9
< 2	5.8013286E9	7.1175571E8
< 1	8.7697132E9	8.7697132E9
< 2	6.429462E9	3.38545613E9
< 1	6.6793114E8	6.6793114E8
---
> 1	3.2034306228161E9	3.2034306228161E9
> 1	5.784849030897E8	5.784849030897E8
> 1	4.5705990446731E9	4.5705990446731E9
> 1	7.8424593154341E9	7.8424593154341E9
> 1	2.030536797829E9	2.030536797829E9
> 1	2.8122137486935E9	2.8122137486935E9
> 2	7.363054077141E9	1.1799795739353E9
> 2	6.7484340816736E9	6.2992029916495E9
> 1	-4.6873793937266E9	-4.6873793937266E9
> 2	9.9837842257693E9	3.2493619015441E9
> 2	5.8013284485787E9	7.117557059974E8
> 1	8.769712797366E9	8.769712797366E9
> 2	6.42946225591E9	3.3854562183842E9
> 1	6.679311441258E8	6.679311441258E8
57,59c57,59
< 1	2.19904128E9	2.19904128E9
< 1	8.1855632E7	8.1855632E7
< 1	4.8821535E9	4.8821535E9
---
> 1	2.1990411588922E9	2.1990411588922E9
> 1	8.18556314335E7	8.18556314335E7
> 1	4.8821532446891E9	4.8821532446891E9
61,70c61,70
< 2	9.8815437E9	5.2160108E9
< 1	5.7889203E9	5.7889203E9
< 1	8.6286244E9	8.6286244E9
< 1	1.29877683E9	1.29877683E9
< 2	5.9053696E9	4.50677952E8
< 1	6.7856778E9	6.7856778E9
< 1	6.7784945E9	6.7784945E9
< 1	5.8806436E9	5.8806436E9
< 1	7.6739825E9	7.6739825E9
< 3	9.9341025E9	4.6864464E8
---
> 2	9.881544127129E9	5.2160109719262E9
> 1	5.788920391351E9	5.788920391351E9
> 1	8.6286244587972E9	8.6286244587972E9
> 1	1.2987767811865E9	1.2987767811865E9
> 2	5.9053697111085E9	4.5067794621E8
> 1	6.7856778157875E9	6.7856778157875E9
> 1	6.778494338505E9	6.778494338505E9
> 1	5.8806436462328E9	5.8806436462328E9
> 1	7.6739824656397E9	7.6739824656397E9
> 3	9.9341020546853E9	4.686446394772E8
{noformat})

> Difference in results count distinct with min max query on JDK8
> ---------------------------------------------------------------
>
>                 Key: DRILL-4321
>                 URL: https://issues.apache.org/jira/browse/DRILL-4321
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 1.4.0
>         Environment: 4 node cluster
>            Reporter: Khurram Faraaz
>              Labels: JDK8SUPPORT
>         Attachments: expected_results.res
>
>
> count distinct query with min max and group by and order by returns incorrect results
on MapR Drill 1.4.0, MapR FS 5.0.0 GA and JDK8
> The difference is in the way we round off values after the decimal when using JDK8.
> Expected results file can be found here
> https://github.com/mapr/drill-test-framework/blob/master/framework/resources/Functional/aggregates/aggregation/count_distinct/with_min_max_c_float_group_by_1_cols.res
> Failing query is Functional/aggregates/aggregation/count_distinct/
> with_min_max_c_float_group_by_1_cols.sql
> {noformat}
> select count(distinct c_float), max(c_float), min(c_float) from alltypes_with_nulls group
by  c_date order by  c_date;
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message