Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3343

Seemingly incorrect result with SUM window functions and float data type

    Details

      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)

        Attachments

        1. voter_hive
          30 kB
          Victoria Markman
        2. queries.tar
          38 kB
          Victoria Markman
        3. create_table.tar
          67 kB
          Victoria Markman

          Activity

            People

            • Assignee:
              adeneche Deneche A. Hakim
              Reporter:
              vicky Victoria Markman
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: