hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-5992) Hive inconsistently converts timestamp in AVG and SUM UDAF's
Date Mon, 16 Dec 2013 21:32:09 GMT

     [ https://issues.apache.org/jira/browse/HIVE-5992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Xuefu Zhang updated HIVE-5992:
------------------------------

    Status: Patch Available  (was: Open)

> Hive inconsistently converts timestamp in AVG and SUM UDAF's
> ------------------------------------------------------------
>
>                 Key: HIVE-5992
>                 URL: https://issues.apache.org/jira/browse/HIVE-5992
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>    Affects Versions: 0.12.0
>            Reporter: Xuefu Zhang
>            Assignee: Xuefu Zhang
>         Attachments: HIVE-5992.patch
>
>
> {code}
> hive> select t, sum(t), count(*), sum(t)/count(*), avg(t) from ts group by t;
> ...
> OK
> 1977-03-15 12:34:22.345678	 227306062  1  227306062	2.27306062345678E8
> {code}
> As it can be seen, timestamp value (1977-03-15 12:34:22.345678) is converted with fractional
part ignored in sum, while preserved in avg. As a further result, sum()/count() is not equivalent
to avg.



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)

Mime
View raw message