[ https://issues.apache.org/jira/browse/HIVE-4193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13609148#comment-13609148 ]
Alan Gates commented on HIVE-4193: ---------------------------------- Note, other than the query listed in the above comments all of the other queries using ROWS BETWEEN now produce correct results. > OVER clauses with BETWEEN in the window definition produce wrong results > ------------------------------------------------------------------------ > > Key: HIVE-4193 > URL: https://issues.apache.org/jira/browse/HIVE-4193 > Project: Hive > Issue Type: Bug > Components: PTF-Windowing > Affects Versions: 0.11.0 > Reporter: Alan Gates > Attachments: Range_5_diff > > > Window queries that define a windowing clause that has a termination row > often (though not all) return incorrect results. For example, from our test > queries all of the following return incorrect results: > {code} > select s, sum(f) over (partition by t order by b > rows between current row and unbounded following) > from over100k; > select s, avg(f) over (partition by b order by d > rows between 5 preceding and current row) > from over100k; > select s, avg(f) over (partition by bin order by s > rows between current row and 5 following) > from over100k; > select s, avg(d) over (partition by i order by f desc > rows between 5 preceding and 5 following) > from over100k; > {code} -- 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