hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
Date Sat, 02 Feb 2013 00:50:13 GMT

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

Alan Gates commented on HIVE-896:
---------------------------------

I was wondering if there's a "standard" way to do selections from partition table functions
in SQL.  (I know it isn't actually part of the standard yet.)  If there's a way others have
done it, it makes sense to align Hive's syntax with those, as long as theirs is rational.


The only other one I'm aware of is Aster.  There syntax is:

functionname ( ON source [PARTITION BY expression [ORDER BY expression]] [key_value_list]
)

where a key_value_list is:  key(value)[, key(value)...] where key is the name of the argument
in the function and value is the value to be passed.

We've already agreed to add PARTITION BY and ORDER BY as synonyms for DISTRIBUTE/CLUSTER BY
and SORT BY.  It seems to me it would make sense to do the function argument passing in the
same way to avoid confusion for users.
                
> 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