[ https://issues.apache.org/jira/browse/DRILL-1862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Deneche A. Hakim updated DRILL-1862: ------------------------------------ Assignee: Aman Sinha (was: Jinfeng Ni) > over clause with only order by clause throws an exception > --------------------------------------------------------- > > Key: DRILL-1862 > URL: https://issues.apache.org/jira/browse/DRILL-1862 > Project: Apache Drill > Issue Type: Improvement > Components: SQL Parser > Reporter: Deneche A. Hakim > Assignee: Aman Sinha > Fix For: 1.1.0 > > Attachments: DRILL-1862 error.txt > > > 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: > {code} > SELECT employee_id, position_id, salary, SUM(salary) OVER(ORDER BY salary) > FROM cp.`employee.json` LIMIT 20; > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)