[
https://issues.apache.org/jira/browse/DRILL-1487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14170533#comment-14170533
]
Jinfeng Ni commented on DRILL-1487:
-----------------------------------
According to postgre's doc, that seems to be the case:
"The default framing option is RANGE UNBOUNDED PRECEDING, which is the same as
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW. With ORDER BY, this sets the
frame to be all rows from the partition start up through the current row's last
peer. Without ORDER BY, all rows of the partition are included in the window
frame, since all rows become peers of the current row.
"
> 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: Timothy Chen
>
> 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)
