drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3343) Seemingly incorrect result with SUM window functions and float data type
Date Tue, 23 Jun 2015 17:38:00 GMT
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)

Mime
View raw message