Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2B1C218ADC for ; Fri, 5 Feb 2016 04:50:40 +0000 (UTC) Received: (qmail 41324 invoked by uid 500); 5 Feb 2016 04:50:40 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 41296 invoked by uid 500); 5 Feb 2016 04:50:40 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 41281 invoked by uid 99); 5 Feb 2016 04:50:40 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Feb 2016 04:50:40 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id DA8B72C14F0 for ; Fri, 5 Feb 2016 04:50:39 +0000 (UTC) Date: Fri, 5 Feb 2016 04:50:39 +0000 (UTC) From: "Khurram Faraaz (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Issue Comment Deleted] (DRILL-4321) Difference in results count distinct with min max query on JDK8 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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)