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

Seemingly incorrect result with SUM window functions and float data type

    XMLWordPrintableJSON

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

            adeneche Abdel Hakim Deneche
            vicky Victoria Markman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: