[jira] [Created] (HIVE-8569) error result when hive meet window function

[Yi Tian (JIRA)]

Yi Tian created HIVE-8569:
-----------------------------

             Summary: error result when hive meet window function
                 Key: HIVE-8569
                 URL: https://issues.apache.org/jira/browse/HIVE-8569
             Project: Hive
          Issue Type: Bug
          Components: SQL
    Affects Versions: 0.13.0, 0.12.0
            Reporter: Yi Tian


how to reproduce:
{quote}
drop table over10k;

create table over10k(
           t tinyint,
           si smallint,
           i int,
           b bigint,
           f float,
           d double,
           bo boolean,
           s string,
           ts timestamp, 
           dec decimal,  
           bin binary)
       row format delimited
       fields terminated by '|';

load data local inpath '../data/files/over10k' into table over10k;

select ts,s,i, sum(i) over(partition by ts order by s) from over10k where 
s='ethan van buren' and ts='2013-03-01 09:11:58.703325';
{quote}
the result is :
{quote}
2013-03-01 09:11:58.703325      ethan van buren 65644   131222
2013-03-01 09:11:58.703325      ethan van buren 65578   131222
{quote}
but the fourth field of the first line should be 65644.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)