[
https://issues.apache.org/jira/browse/HIVE-4112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13595024#comment-13595024
]
Alan Gates commented on HIVE-4112:
----------------------------------
Harish, by LESS and MORE do you mean keywords? So is the idea that you could
say:
select a, SUM(b) OVER (PARTITION BY c ORDER BY d RANGE LESS c - 5)
?
If so, why use LESS/MORE here rather than PRECEDING/FOLLOWING as Oracle does?
> 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
