hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-4193) OVER clauses with BETWEEN in the window definition produce wrong results
Date Thu, 21 Mar 2013 17:41:16 GMT

     [ 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

Mime
View raw message