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

Difference in expected results - query that uses window functions

    Details

      Description

      The following queries return wrong results, there is a difference in actual vs expected results. Expected results were generated on Postgres 9.3
      These queries were run on 4 node cluster on CentOS, window functions were set.

      SELECT MIN(cast( columns[8] as TIME )) OVER(PARTITION BY cast( columns[2] as CHAR(2)) ORDER BY cast( columns[0] as INT )) FROM `allData.csv`;
      
      SELECT SUM(cast( columns[0] as INT )) OVER(PARTITION BY cast( columns[2] as CHAR(2)) ORDER BY cast( columns[0] as INT )) FROM `allData.csv`;
      
      SELECT MAX(cast( columns[8] as TIME )) OVER(PARTITION BY cast( columns[2] as CHAR(2)) ORDER BY cast( columns[0] as INT )) FROM `allData.csv`;
      
      SELECT SUM(cast( columns[1] as BIGINT )) OVER(PARTITION BY cast( columns[2] as CHAR(2)) ORDER BY cast( columns[0] as INT )) FROM `allData.csv`;
      

        Attachments

        There are no Sub-Tasks for this issue.

          Activity

            People

            • Assignee:
              adeneche Deneche A. Hakim
              Reporter:
              khfaraaz Khurram Faraaz
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: