You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Harish Butani (Commented) (JIRA)" <ji...@apache.org> on 2012/04/17 03:56:17 UTC
[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical
windowing functions to Hive.
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13255251#comment-13255251 ]
Harish Butani commented on HIVE-896:
------------------------------------
Hi,
Yes, I have been developing SQL Windowing on top of Hive(https://github.com/hbutani/SQLWindowing/wiki). Users can intersperse Hive Queries with Windowing Clauses and Table functions. Users can use this from a CLI (hive --service windowingCLI) or via a Query API.
The hope is to provide Users:
- Windowing Clauses and Table functions as a simple extension to HQL
- overtime to fold the implementation into the Hive code base with hopefully minimal impact to the User experience.
Here are some thoughts on how to fold this functionality into Hive: https://github.com/hbutani/SQLWindowing/wiki/MoveToHive
Any thoughts/comments/suggestions greatly welcomed.
regards,
Harish Butani.
> 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
>
> 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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira