[ https://issues.apache.org/jira/browse/HIVE-4190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13612832#comment-13612832 ]
Ashutosh Chauhan commented on HIVE-4190: ---------------------------------------- https://reviews.facebook.net/D9693 > 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