hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10650) Improve sum() function over windowing to support additional range formats
Date Wed, 13 May 2015 14:04:00 GMT

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

Aihua Xu commented on HIVE-10650:
---------------------------------

+[~ashutoshc] Could you please help review the code? 

In this patch, we handle 'x preceding and y preceding' and 'x following and y following' windowing.
Based on different windowing, we generate intermediate results and final results. Before the
first row and after the last row, we could insert 'NULL' for different windowing.

Unit tests are added to test various cases. 

> Improve sum() function over windowing to support additional range formats
> -------------------------------------------------------------------------
>
>                 Key: HIVE-10650
>                 URL: https://issues.apache.org/jira/browse/HIVE-10650
>             Project: Hive
>          Issue Type: Sub-task
>          Components: PTF-Windowing
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>         Attachments: HIVE-10650.patch
>
>
> Support the following windowing function {{x preceding and y preceding}} and {{x following
and y following}}.
> e.g.
> {noformat} 
> select sum(value) over (partition by key order by value rows between 2 preceding and
1 preceding) from tbl1;
> select sum(value) over (partition by key order by value rows between unbounded preceding
and 1 preceding) from tbl1;
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message