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] [Commented] (DRILL-4321) Difference in results count distinct with min max query on JDK8
Date Fri, 05 Feb 2016 04:51:39 GMT

    [ https://issues.apache.org/jira/browse/DRILL-4321?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15133654#comment-15133654
] 

Khurram Faraaz commented on DRILL-4321:
---------------------------------------

these three rows are actual results from JDK8 + Drill 1.5.0

< 1	2.19904128E9	2.19904128E9
< 1	8.1855632E7	8.1855632E7
< 1	4.8821535E9	4.8821535E9

and these three rows are from expected results file

> 1	2.1990411588922E9	2.1990411588922E9
> 1	8.18556314335E7	8.18556314335E7
> 1	4.8821532446891E9	4.8821532446891E9

> 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