hive-dev mailing list archives

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


Alan Gates commented on HIVE-896:


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:

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

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

I get 

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

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

> Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
> ---------------------------------------------------------------
>                 Key: HIVE-896
>                 URL:
>             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
> More details at:
> -- 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:

View raw message