[HIVE-9534] incorrect result set for query that projects a windowed aggregate

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Component/s: PTF-Windowing
• Assignee: Aihua Xu
• Reporter: N Campbell
• Created: 31/Jan/15 14:04
• Updated: 21/Jun/16 15:53
• Resolved: 12/Feb/16 20:24

Description

Result set returned by Hive has one row instead of 5

select avg(distinct tsint.csint) over () from tsint 

create table  if not exists TSINT (RNUM int , CSINT smallint)
 ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' 
 STORED AS TEXTFILE;

0|\N
1|-1
2|0
3|1
4|10

Issue Links

• links to: Code review