[
https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13560860#comment-13560860
]
Harish Butani commented on HIVE-896:
------------------------------------
Alan,
I have attached a document describing the PTF & Windowing Specification
classes. This is a formal description of the changes I was describing above.
The output of Phase 1 will be Windowing & PTFInvocation objects attached to the
QB.
The thought process is:
- Phase 1 generates Specification that doesn't tie PTFs and Windowing
- We alter the PTFTranslator to handle both Windowing & PTFInvocations; for now
we keep the PTFDef classes mostly intact.
- in the future we:
- build a separate Operator for Windowing, based on the Spec classes.
- tbd: we refactor the PTFTranslator and Definition classes to share more
translation code with the Windowing Operator.
> 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.html, HIVE-896.1.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