You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Deneche A. Hakim (JIRA)" <ji...@apache.org> on 2016/01/28 17:57:40 UTC
[jira] [Commented] (DRILL-4321) Difference in results count
distinct with min max query on JDK8
[ https://issues.apache.org/jira/browse/DRILL-4321?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15121879#comment-15121879 ]
Deneche A. Hakim commented on DRILL-4321:
-----------------------------------------
Do you have the query profile for the query when the results are different ? I was not able to reproduce it on my laptop, I got the same results in JDK7 and 8
> 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
> 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)