[DRILL-1487] Drill window functions return wrong results

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 0.6.0
• Fix Version/s: 0.8.0
• Component/s: Execution - Relational Operators
• Assignee: Abdel Hakim Deneche
• Reporter: Neeraja
• Created: 03/Oct/14 05:15
• Updated: 24/Feb/15 22:18
• Resolved: 24/Feb/15 22:18

Description

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

Issue Links

• duplicates: DRILL-1908 new window function implementation
• is duplicated by: DRILL-1908 new window function implementation