[
https://issues.apache.org/jira/browse/HIVE-8569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Navis reassigned HIVE-8569:
---------------------------
Assignee: Navis
> 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.12.0, 0.13.0
> Reporter: Yi Tian
> Assignee: Navis
>
> 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)
