[jira] [Resolved] (DRILL-629) SUM() group by results in wrong values

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-629?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau resolved DRILL-629.
----------------------------------

    Resolution: Invalid

It looks like this was similar issue to DRILL-637.  Marking as invalid.

> SUM() group by results in wrong values
> --------------------------------------
>
>                 Key: DRILL-629
>                 URL: https://issues.apache.org/jira/browse/DRILL-629
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Ramana Inukonda Nagaraj
>
> Parquet file was created from pig, pig datatypes for the interested columns are long and double
> A select of the columns from the parquet file results in :
> 0: jdbc:drill:schema=dfs.drillTestDirTpch> select O_CUSTKEY,O_TOTALPRICE from orders where  O_CUSTKEY=1499;
> +------------+--------------+
> | O_CUSTKEY  | O_TOTALPRICE |
> +------------+--------------+
> | 1499       | 135540.7     |
> | 1499       | 72730.13     |
> +------------+--------------+
> 2 rows selected (1.275 seconds)
> However in a sum agg function grouped by the O_CUSTKEY results in
> select O_CUSTKEY,SUM(O_TOTALPRICE) from orders group by O_CUSTKEY;
> 1499	208270.83000000002
> as opposed to 
> 1499	208270.83 which is the correct result.



--
This message was sent by Atlassian JIRA
(v6.2#6252)