hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
Date Mon, 21 Jan 2013 21:06:13 GMT

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

Alan Gates commented on HIVE-896:
---------------------------------

Harish,

Thanks for you replies.  I want to think on your explanation in 2 above some more, but at
least I think I understand your rationale now.  

One other question.  I tried playing around with this but kept getting an error.  I'm not
sure what I'm doing wrong.  I have a table that I created with the following statement:

{code}
create table studenttab10k (name string, age int, gpa float);
{code}

When I run 
{code}
select avg(gpa) over (cluster by age) from studenttab10k;
{code}

I get 

{code}
FAILED: SemanticException 1:43 No partition specification associated with start of PTF chain
. Error encountered near token 'age'
{code}

I looked through the syntax file and I think I'm doing the right thing, but obviously I'm
not. 

                
> 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: 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

Mime
View raw message