[HIVE-4034] Should be able to specify windowing spec without needing Between

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: PTF-Windowing
• Assignee: Ashutosh Chauhan
• Reporter: Ashutosh Chauhan
• Created: 18/Feb/13 03:33
• Updated: 16/May/13 21:09
• Resolved: 01/Mar/13 00:46

Description

Currently user need to do following:

select s, sum(b) over (distribute by i sort by si rows between unbounded preceding and current row) from over100k;

but sql spec allows following as well:

select s, sum(b) over (distribute by i sort by si rows unbounded preceding) from over100k;

In such cases current row should be assumed implicitly.

Issue Links

• is required by: HIVE-896 Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.