[
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)
