[DRILL-3343] Seemingly incorrect result with SUM window functions and float data type

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Invalid
• Affects Version/s: 1.0.0
• Fix Version/s: 1.1.0
• Component/s: Execution - Data Types
• Labels: window_function
• Assignee: Abdel Hakim Deneche
• Reporter: Victoria Markman
• Created: 23/Jun/15 17:37
• Updated: 24/Jun/15 20:43
• Resolved: 24/Jun/15 20:43

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)