hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chaoyu Tang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate
Date Wed, 06 May 2015 01:23:00 GMT

    [ 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)

Mime
View raw message