[HIVE-4214] OVER accepts general expression instead of just function

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.0
• Fix Version/s: 0.12.0
• Component/s: PTF-Windowing
• Assignee: Ashutosh Chauhan
• Reporter: Alan Gates
• Created: 21/Mar/13 18:56
• Updated: 15/Oct/13 23:30
• Resolved: 21/Aug/13 14:57

Description

The query:

select s, i, avg(d) / 10.0 over (partition by s order by i) from over100k;

runs (and produces meaningless output).

Over should not allow the arithmetic expression. Only a UDAF or PTF function should be valid there. The correct way to write this query should be

select s, i, avg(d) over (partition by s order by i) / 10. 0 from over100k;