[
https://issues.apache.org/jira/browse/HIVE-4190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13604752#comment-13604752
]
Harish Butani commented on HIVE-4190:
-------------------------------------
Yes, this is one of the many differences in behavior in our implementation from
the Standard.
Is documented in 4197. Should be covered by it.
> OVER clauses with ORDER BY not getting windowing set properly
> -------------------------------------------------------------
>
> Key: HIVE-4190
> URL: https://issues.apache.org/jira/browse/HIVE-4190
> Project: Hive
> Issue Type: Bug
> Components: PTF-Windowing
> Affects Versions: 0.11.0
> Reporter: Alan Gates
>
> Given a query like:
> select s, avg(f) over (partition by si order by d) from over100k;
> Hive is not setting the window frame properly. The order by creates an
> implicit window frame of 'unbounded preceding' but Hive is treating the above
> query as if it has no window.
--
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
