[
https://issues.apache.org/jira/browse/HIVE-4193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alan Gates resolved HIVE-4193.
------------------------------
Resolution: Invalid
The desc definitely causes an issue when you forget to put it into the
verification query. Once you do that all is good. I'm closing this as invalid
because the rest of the queries work now (the result of other patches checked
in I assume) and this last one was a test error.
> 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
