hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <j...@apache.org>
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
                 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

Mime
View raw message