[
https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13569211#comment-13569211
]
Alan Gates commented on HIVE-896:
---------------------------------
[~rhbutani] I've been looking at the syntax for invoking a PTF in your patch.
If I read it correctly it looks something like:
functionname ( expr_list ON source ... )
where expr_list is a comma separated list of expressions, source is a table,
subquery or another PTF, and ... is the DISTRIBUTE BY etc.
Is that right? If so, what is that list of expressions? Are those arguments
to be passed to the PTF? Also, if I read it correctly the ON keyword is
optional. Does ON not being there have some meaning or do you just see it as a
noise word so you're allowing it to be optional?
> 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
