[ 
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

Reply via email to