Harish Butani created HIVE-4126: ----------------------------------- Summary: remove support for lead/lag UDFs outside of UDAF args Key: HIVE-4126 URL: https://issues.apache.org/jira/browse/HIVE-4126 Project: Hive Issue Type: Bug Components: PTF-Windowing Reporter: Harish Butani Assignee: Harish Butani
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....)... -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira