[HIVE-4193] OVER clauses with BETWEEN in the window definition produce wrong results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 0.11.0
• Component/s: PTF-Windowing
• Assignee: Unassigned
• Reporter: Alan Gates
• Created: 16/Mar/13 00:23
• Updated: 01/Oct/19 22:06
• Resolved: 21/Mar/13 17:40

Description

Window queries that define a windowing clause that has a termination row often (though not all) return incorrect results. For example, from our test queries all of the following return incorrect results:

select s, sum(f) over (partition by t order by b 
       rows between current row and unbounded following) 
from over100k;

select s, avg(f) over (partition by b order by d 
       rows between 5 preceding and current row) 
from over100k;

select s, avg(f) over (partition by bin order by s 
       rows between current row and 5 following) 
from over100k;

select s, avg(d) over (partition by i order by f desc 
       rows between 5 preceding and 5 following) 
from over100k;