Ramana Inukonda Nagaraj created DRILL-629:
---------------------------------------------
Summary: 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)
