Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Invalid
-
1.0.0
Description
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.
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;
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)