[
https://issues.apache.org/jira/browse/DRILL-1487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14266476#comment-14266476
]
Deneche A. Hakim commented on DRILL-1487:
-----------------------------------------
Changing *StreamingWindowFrameBatchCreator.getBatch()* to the following:
{code}
public RecordBatch getBatch(FragmentContext context, WindowPOP config,
List<RecordBatch> children) throws ExecutionSetupException {
throw new ExecutionSetupException("Window functions have been disabled");
}
{code}
Do display *Window functions have been disabled* when a query contains an over
clause. But the following issues still arise and throw different exceptions:
DRILL-1863, DRILL-1862, DRILL-1852. Those issues seem to be caused by
optiq validation.
Is there another way to disable windowing functionality ?
> Drill window functions return wrong results
> -------------------------------------------
>
> Key: DRILL-1487
> URL: https://issues.apache.org/jira/browse/DRILL-1487
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 0.6.0
> Reporter: Neeraja
> Assignee: Deneche A. Hakim
> Priority: Critical
> Fix For: 0.8.0
>
>
> Executing the following window function with the requirement to see how a
> given employee salary would compare to the avg(salary) in his/her position.
> Query executes fine however returns wrong results(expect the avg(salary) to
> stay same for a given window (i.e position id)
> 0: jdbc:drill:zk=local> 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;
> +-------------+-------------+------------+------------+
> | employee_id | position_id | salary | EXPR$3 |
> +-------------+-------------+------------+------------+
> | 1 | 1 | 80000.0 | 80000.0 |
> | 2 | 2 | 40000.0 | 37500.0 |
> | 4 | 2 | 40000.0 | 38333.333333333336 |
> | 5 | 2 | 35000.0 | 35000.0 |
> | 6 | 3 | 25000.0 | 25000.0 |
> | 7 | 4 | 15000.0 | 15000.0 |
> | 8 | 11 | 10000.0 | 14333.333333333334 |
> | 9 | 11 | 17000.0 | 17000.0 |
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
