[
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
