[HIVE-8569] error result when hive meet window function

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Component/s: SQL
• Assignee: Unassigned Assign to me
• Reporter: Tianyi Wang
• Created: 23/Oct/14 06:15
• Updated: 25/Jan/15 22:09
• Resolved: 25/Jan/15 22:09

Description

how to reproduce:

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 over(partition by ts order by s) from over10k where s='ethan van buren' and ts='2013-03-01 09:11:58.703325';

the result is :

2013-03-01 09:11:58.703325 ethan van buren 65644 131222
2013-03-01 09:11:58.703325 ethan van buren 65578 131222

but the fourth field of the first line should be 65644.