[
https://issues.apache.org/jira/browse/HIVE-4112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13592284#comment-13592284
]
Harish Butani commented on HIVE-4112:
-------------------------------------
Would these rules be sufficient:
Range based window:
- between... -> works as today, fully specified window
- rows unbounded preceding -> window is (unbounded, current)
- row unbounded following -> window is (current, unbounded)
- number preceding -> window is ((number preceding) current)
- number following -> window is (current (number following))
Value based window:
- between ... -> works as today, fully specified window
- range unbounded preceding -> window is (unbounded, current)
- range unbounded following -> window is (current, unbounded)
- expression number LESS -> window is ((LESS expression num) current)
- expression number MORE -> window is (current (MORE expression num))
> Window range specification should be more flexible
> --------------------------------------------------
>
> Key: HIVE-4112
> URL: https://issues.apache.org/jira/browse/HIVE-4112
> Project: Hive
> Issue Type: Bug
> Components: PTF-Windowing
> Reporter: Ashutosh Chauhan
>
> select s, avg(f) over (partition by dec order by d rows 5 preceding) from
> over100k;
> is a legal query which is currently rejected by Parser.
--
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
