[ https://issues.apache.org/jira/browse/HIVE-10650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14542639#comment-14542639 ]
Aihua Xu commented on HIVE-10650: --------------------------------- [~ashutoshc] Thanks for reviewing. You are right. I added such test case in HIVE-10140, then I noticed that such windowing actually doesn't work. I mentioned there the result was incorrect and this is the patch to fix such issue. > 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)