[DRILL-3275] Difference in expected results - query that uses window functions

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.1.0
• Component/s: Execution - Relational Operators
• Labels: window_function
• Assignee: Abdel Hakim Deneche
• Reporter: Khurram Faraaz
• Created: 10/Jun/15 22:35
• Updated: 24/Jun/15 23:52
• Resolved: 24/Jun/15 23:52

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`;

Sub-Tasks

• SUM(CAST(columns[0] AS INT)) OVER(...) gives wrong results: Closed
• SUM(CAST(columns[0] AS BIGINT)) OVER(...) gives wrong results: Closed
• window functions that involve TIME columns generate wrong results: Closed