[DRILL-1862] over clause with only order by clause throws an exception

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Query Planning & Optimization
• Labels: window_function
• Assignee: Aman Sinha
• Reporter: Abdel Hakim Deneche
• Created: 13/Dec/14 00:02
• Updated: 26/Jun/15 15:15
• Resolved: 12/Jun/15 05:14

Description

When using over clause without a "partition by" clause but with an "order by" clause, an ForemanException is thrown (complete error message attached).

For example the following query throws and exception:

SELECT employee_id, position_id, salary, SUM(salary) OVER(ORDER BY salary) FROM cp.`employee.json` LIMIT 20;

Issue Links

• duplicates: DRILL-3175 Missing partition by key in OVER clause causes RelOptPlanner$CannotPlanException