[
https://issues.apache.org/jira/browse/HIVE-4193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13609156#comment-13609156
]
Ashutosh Chauhan commented on HIVE-4193:
----------------------------------------
One way this query is different from others is it has desc. Alan, can you run
this query without desc and see if it still produces wrong results. If not,
likely we have a bug in order by desc.
> 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
