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