[DRILL-1844] window function throws an exception

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0, 0.8.0
• Fix Version/s: 0.8.0
• Component/s: Execution - Relational Operators
• Assignee: Abdel Hakim Deneche
• Reporter: Abdel Hakim Deneche
• Created: 11/Dec/14 20:18
• Updated: 21/Apr/15 15:34
• Resolved: 29/Dec/14 18:16

Description

Starting from Drill 0.7.0 (specifically after DRILL-1781 was committed), The following query:

SELECT employee_id,position_id, salary, avg(salary) OVER (PARTITION BY position_id order by position_id) FROM cp.`employee.json` order by employee_id;

Throws an IllegalStateException:

Attempted to close accountor with 6 buffer(s) still allocatedfor QueryId: 2b7606b9-eddf-05db-2b8d-d72c5aa54e95, MajorFragmentId: 0, MinorFragmentId: 0.