[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: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 11/Apr/16 15:48
• Updated: 27/Feb/24 22:24
• Resolved: 15/Apr/16 12: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;