[HIVE-13475] Allow aggregate functions in over clause

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.1.0
• Component/s: Parser
• Assignee: Jesus Camacho Rodriguez Assign to me
• Reporter: Jesus Camacho Rodriguez
• Created: 11/Apr/16 18:48
• Updated: 25/Jul/16 11:25
• Resolved: 15/Apr/16 15:25

Description

Support to reference aggregate functions within the over clause needs to be added. For instance, currently the following query will fail:

select rank() over (order by sum(ws.c_int)) as return_rank
from cbo_t3 ws
group by ws.key;