You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2016/01/28 10:53:39 UTC
[jira] [Created] (DRILL-4321) Difference in results count distinct
with min max query on JDK8
Khurram Faraaz created DRILL-4321:
-------------------------------------
Summary: 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
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)