[
https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14529716#comment-14529716
]
Chaoyu Tang commented on HIVE-9534:
-----------------------------------
Oracle 11.2 treats avg(distinct tsint.csint) over () as analytic function
instead of aggregation function, so the query return 4 rows of returns 2.5.
Note, there is not order by clause or window clause inside the parenthesis of
"over". Could you try query like "select avg(distinct tsint.csint) over (order
by rnum rows between 1 preceding and 1 following) from tsint" to see if it
works in Oracle c12? It did not work in 11.2.
> 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
> Assignee: Chaoyu Tang
>
> Result set returned by Hive has one row instead of 5
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
