[HIVE-12881] Count() function over partitions doesn't work properly with ORDER BY

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 2.1.0
• Component/s: PTF-Windowing
• Assignee: Unassigned
• Reporter: Aihua Xu
• Created: 15/Jan/16 20:59
• Updated: 15/Jan/16 21:46
• Resolved: 15/Jan/16 21:46

Description

The following query doesn't seem to return the correct result.

create table test (empno string, deptno string, level string, manager string);
insert into test values ('1', '2', 'B', 'Else'); 
insert into test values ('1', '2', 'B', 'Else');
insert into test values ('2', '2', 'B', 'Other');

select  count( manager) over (partition by deptno, level order by manager) from test; 

It returns

2
2
3

Without ORDER BY, it returns correct result

3
3
3