Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Thu, 21 Mar 2013 17:41:16 +0000 (UTC)
From: "Alan Gates (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12637305.1363393390062.28279.1363887676121@arcas>
In-Reply-To: <JIRA.12637305.1363393390062@arcas>
References: <JIRA.12637305.1363393390062@arcas>
Subject: [jira] [Resolved] (HIVE-4193) OVER clauses with BETWEEN in the
 window definition produce wrong results
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ 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