[DRILL-3268] queries with empty OVER() clause return empty result set

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Execution - Relational Operators
• Labels: window_function
• Assignee: Steven Phillips
• Reporter: Abdel Hakim Deneche
• Created: 09/Jun/15 23:32
• Updated: 02/Jul/15 18:27
• Resolved: 18/Jun/15 20:14

Description

The following query returns, incorrectly, an empty result set:

0: jdbc:drill:zk=local> SELECT employee_id, position_id, salary, SUM(salary) OVER() FROM cp.`employee.json` LIMIT 1000;
+--------------+--------------+---------+---------+
| employee_id  | position_id  | salary  | EXPR$3  |
+--------------+--------------+---------+---------+
+--------------+--------------+---------+---------+
No rows selected (0.287 seconds)

DRILL-1862 is required otherwise such queries won't plan at all.

The problem is caused by WindowFrameRecordBatch.buildSchema() which assumes the very first batch to be an empty batch that only contains the schema, which is not the case when using OVER()