Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # dev - Re: [jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.


Copy link to this message
-
Re: [jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
Venky Iyer 2013-01-31, 19:10
unsubscribe

On 1/31/13 11:01 AM, "Ashutosh Chauhan (JIRA)" <[EMAIL PROTECTED]> wrote:
    [
https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plug
in.system.issuetabpanels:comment-tabpanel&focusedCommentId=13567950#comment
-13567950 ]

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

Thanks Prajakta for explanation. Make sense, But to your last point which
Harish also noted in previous comment:
bq. So currently, we are filtering the VCs and setting up a new
RowResolver for ExtractOperator during translation so that the columns at
runtime match with those during translation.
I think we cannot always filter out VC's for RR of ExtractOp. That will
depend on whether user has selected VCs or not in the query. No?
                
> 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/analys
>is.htm#i1006709
>
>http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analys
>is.htm#i1007059
>
>http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analys
>is.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