hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <>
Subject [jira] [Created] (HIVE-4126) remove support for lead/lag UDFs outside of UDAF args
Date Tue, 05 Mar 2013 21:42:13 GMT
Harish Butani created HIVE-4126:

             Summary: remove support for lead/lag UDFs outside of UDAF args
                 Key: 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:

View raw message