[
https://issues.apache.org/jira/browse/HIVE-4112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13595236#comment-13595236
]
Alan Gates commented on HIVE-4112:
----------------------------------
I'm curious why you're proposing different keywords for use with RANGE than
ROWS. As far as I can tell both Oracle and the ANSI standard propose using
PRECEDING and FOLLOWING in both cases.
> 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
