[
https://issues.apache.org/jira/browse/HIVE-4174?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13621069#comment-13621069
]
Mark Grover commented on HIVE-4174:
-----------------------------------
Indeed, thanks Chen Chun. And, congratulations on your first Hive commit!
> Round UDF converts BigInts to double
> ------------------------------------
>
> Key: HIVE-4174
> URL: https://issues.apache.org/jira/browse/HIVE-4174
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Affects Versions: 0.10.0
> Reporter: Mark Grover
> Assignee: Mark Grover
> Fix For: 0.11.0
>
> Attachments: hive.4174.1.patch-nohcat, HIVE-4174.1.patch.txt,
> HIVE-4174.D9687.1.patch
>
>
> Chen Chun pointed out on the hive-user mailing list that round() in Hive 0.10
> returns
> {code}
> select round(cast(1234560 as BIGINT)), round(cast(12345670 as BIGINT)) from
> test limit 1;
> //hive 0.10
> 1234560.0 1.234567E7
> {code}
> This is not consistent with
> MySQL(http://dev.mysql.com/doc/refman/5.1/en/mathematical-functions.html#function_round)
> which quotes
> {code}
> The return type is the same type as that of the first argument (assuming that
> it is integer, double, or decimal). This means that for an integer argument,
> the result is an integer (no decimal places)
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
