[DRILL-3281] window functions that involve TIME columns generate wrong results

• Type: Sub-task
• Status: Closed
• Priority: Critical
• Resolution: Invalid
• Fix Version/s: 1.1.0
• Component/s: Execution - Relational Operators
• Labels: window_function
• Assignee: Abdel Hakim Deneche
• Reporter: Abdel Hakim Deneche
• Created: 11/Jun/15 22:15
• Updated: 24/Jun/15 23:52
• Resolved: 24/Jun/15 23:52

Description

Computing a MAX or MIN of a TIME column using the OVER clause seem to generate wrong results compared to Postgres. Example of such queries:

SELECT MIN(CAST(columns[1] AS TIME)) OVER(PARTITION BY columns[0]) FROM `3281.csv`;

SELECT MAX(CAST(columns[1] AS TIME)) OVER(PARTITION BY columns[0]) FROM `3281.csv`;