[
https://issues.apache.org/jira/browse/HIVE-4112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13595356#comment-13595356
]
Harish Butani commented on HIVE-4112:
-------------------------------------
It was done to highlight that the range based window is based on column values
and not on the number of rows. Can easily change the syntax to use preceding
and following.
The semantics are: form a window by going backwards(or forwards) until it
reaches a row whose difference in value with the 'current' row is more than the
value specified in the query. Only works for numeric types + timestamp. So
'less' and 'more' seemed a more natural way to express this.
Haven't looked at supporting the interval syntax in Oracle.
> 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
