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] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
Date Fri, 01 Feb 2013 23:42:13 GMT

    [ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13569257#comment-13569257
] 

Harish Butani commented on HIVE-896:
------------------------------------

Yes you got most of it correct. So if there are no arguments the form is:

functioname(source....) for e.g. ptf1(part distribute by mfgr sort by name)

If there are arguments the form is:

functionname(args on source ...) for e.g. ptf2(arg1, arg2 on part distribute by mfgr sort
by name)

If you have args the ON is required. Probably can make the ON optional here. I think there
was some ambiguity if ON is optional; didn't want to deal with it in the first pass... If
you want I can go back and check.
                
> Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
> ---------------------------------------------------------------
>
>                 Key: HIVE-896
>                 URL: https://issues.apache.org/jira/browse/HIVE-896
>             Project: Hive
>          Issue Type: New Feature
>          Components: OLAP, UDF
>            Reporter: Amr Awadallah
>            Priority: Minor
>         Attachments: DataStructs.pdf, HIVE-896.1.patch.txt, Hive-896.2.patch.txt
>
>
> Windowing functions are very useful for click stream processing and similar time-series/sliding-window
analytics.
> More details at:
> http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analysis.htm#i1006709
> http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analysis.htm#i1007059
> http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analysis.htm#i1007032
> -- amr

--
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