[
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
