[HIVE-10650] Improve sum() function over windowing to support additional range formats

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Pending Closed
• Fix Version/s: 1.3.0
• Component/s: PTF-Windowing
• Labels: TODOC1.3
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 07/May/15 22:00
• Updated: 01/Jun/15 01:49
• Resolved: 15/May/15 02:32

Description

Support the following windowing function x preceding and y preceding and x following and y following.
e.g.

 
select sum(value) over (partition by key order by value rows between 2 preceding and 1 preceding) from tbl1;
select sum(value) over (partition by key order by value rows between unbounded preceding and 1 preceding) from tbl1;

Issue Links

• links to: code review