[DRILL-4321] Difference in results count distinct with min max query on JDK8

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.0
• Component/s: Query Planning & Optimization
• Labels: JDK8SUPPORT

Environment

4 node cluster

• Assignee: Abdel Hakim Deneche
• Reporter: Khurram Faraaz
• Created: 28/Jan/16 09:53
• Updated: 08/Feb/16 09:51

Description

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

select count(distinct c_float), max(c_float), min(c_float) from alltypes_with_nulls group by  c_date order by  c_date;