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