[HIVE-10702] COUNT(*) over windowing 'x preceding and y preceding' doesn't work properly

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: PTF-Windowing
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 13/May/15 21:23
• Updated: 16/Feb/16 23:50
• Resolved: 26/May/15 06:25

Description

Given the following query:

select ts, f, count(*) over (partition by ts order by f rows between 2 preceding and 1 preceding) from over10k limit 100;

It returns the result

2013-03-01 09:11:58.70307       3.17    0
2013-03-01 09:11:58.70307       10.89   0
2013-03-01 09:11:58.70307       14.54   1
2013-03-01 09:11:58.70307       14.78   1
2013-03-01 09:11:58.70307       17.85   1
2013-03-01 09:11:58.70307       20.61   1
2013-03-01 09:11:58.70307       28.69   1
2013-03-01 09:11:58.70307       29.22   1
2013-03-01 09:11:58.70307       31.17   1
2013-03-01 09:11:58.70307       38.35   1
2013-03-01 09:11:58.70307       38.61   1

Mostly it should return count 2 rather than 1.

Issue Links

• links to: Code review