hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15431) Round(1234567891.1234567891,50) returns null, result is not consistent with Mysql.
Date Fri, 13 Jan 2017 19:31:26 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15822220#comment-15822220
] 

Xuefu Zhang commented on HIVE-15431:
------------------------------------

We cannot be completely be consistent with mysql. For example, mysql has a max precision of
68, while we only have 38. Thus, some valid decimal numbers in mysql would become NULL in
Hive.

> Round(1234567891.1234567891,50) returns null, result is not consistent with Mysql.
> ----------------------------------------------------------------------------------
>
>                 Key: HIVE-15431
>                 URL: https://issues.apache.org/jira/browse/HIVE-15431
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-15431.patch
>
>
> round(1234567891.1234567891,50) returns null. Result is not consistent with Mysql.
> Mysql output:
> {quote}
>   select round(1234567891.1234567891,50);
>   '1234567891.123456789100000000000000000000'
> {quote}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message