[HIVE-4126] remove support for lead/lag UDFs outside of UDAF args

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: PTF-Windowing
• Assignee: Harish Butani
• Reporter: Harish Butani
• Created: 05/Mar/13 21:41
• Updated: 16/May/13 21:10
• Resolved: 08/Mar/13 19:29

Description

Select Expressions such as
p_size - lead(p_size,1)
are currently handled as non aggregation expressions done after all over clauses are evaluated.
Once we allow different partitions in a single select list(Jira 4041), these become ambiguous.

• the equivalent way to do such things is either to use lead/lag UDAFs with expressions ( support added with Jira 4081)
• stack windowing clauses with inline queries. select lead(r,1).. from (select rank() as r....)...