Victoria Markman created DRILL-3343:
---------------------------------------
Summary: Seemingly incorrect result with SUM window functions and
float data type
Key: DRILL-3343
URL: https://issues.apache.org/jira/browse/DRILL-3343
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.0.0
Reporter: Victoria Markman
While running query below against voter_hive (drill table), where contributions
field is defined as "float" (4 byte floating point number in drill) I get a
value of SUM that is different from result generated by postgres.
{code}
select
registration,
age,
name,
sum(contributions) over w
from voter_hive
window w AS (partition by registration order by age rows unbounded preceding)
order by
registration,
age,
name;
{code}
Find attached:
1. Query + result generated by Postgres (queries.tar)
2. voter_hive parquet file
3. create_table.tar - contains CTAS statement + csv file (if you want to create
table yourself)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
