hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
Date Sat, 26 Jan 2013 19:39:14 GMT

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

Ashutosh Chauhan commented on HIVE-896:
---------------------------------------

Hey Harish,
Thanks for updating the patch. While I was playing with previous patch, though unit tests
ran fine. I found ptf queries failed when I ran them on cluster. I found out that antlr-runtime
jar is required at tasktracker, so I need to 'add jar' to send it across. This increases our
runtime dependency. Though, thats not my biggest concern. On investigating a bit, I found
this is due to we are serializing antlr structures from client to backend. I think we should
get rid of this. We should populate all the information we need in hive's data structure in
front end  ( probably in *desc objects) and than use these structures to pull out the information.
Having pieces of antlr structures at backend is not ideal. Does the latest patch improves
this situation?
                
> 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