N Campbell created HIVE-9534:
--------------------------------
Summary: incorrect result set for query that projects a windowed
aggregate
Key: HIVE-9534
URL: https://issues.apache.org/jira/browse/HIVE-9534
Project: Hive
Issue Type: Bug
Components: SQL
Reporter: N Campbell
Result set returned by Hive has one row instead of 5
select avg( distinct tsint.csint ) over () from tsint
create table if not exists TSINT ( RNUM int , CSINT smallint )
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
STORED AS TEXTFILE ;
0|\N
1|-1
2|0
3|1
4|10
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
