[HIVE-4028] Bring paranthesis handling in windowing specification in compliance with sql standard

• 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: 16/Feb/13 03:04
• Updated: 16/May/13 21:11
• Resolved: 16/Feb/13 05:39

Description

 select max(i) over w from over100k window w as (partition by f);

is sql compliant but doesn't work, but following does work:

 select max(i) over w from over100k window (w) as partition by f;

We should make sure standard compliant sql works.

Issue Links

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