[
https://issues.apache.org/jira/browse/HIVE-4523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14106478#comment-14106478
]
Lefty Leverenz commented on HIVE-4523:
--------------------------------------
This change of behavior for round() should be documented in the wiki here (with
version information, of course, and a link back to HIVE-4523):
* [Hive Operators and UDFs -- Mathematical Functions |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-MathematicalFunctions]
> round() function with specified decimal places not consistent with mysql
> -------------------------------------------------------------------------
>
> Key: HIVE-4523
> URL: https://issues.apache.org/jira/browse/HIVE-4523
> Project: Hive
> Issue Type: Improvement
> Components: UDF
> Affects Versions: 0.7.1
> Reporter: Fred Desing
> Assignee: Xuefu Zhang
> Priority: Minor
> Labels: TODOC13
> Fix For: 0.13.0
>
> Attachments: HIVE-4523.1.patch, HIVE-4523.2.patch, HIVE-4523.3.patch,
> HIVE-4523.4.patch, HIVE-4523.5.patch, HIVE-4523.6.patch, HIVE-4523.7.patch,
> HIVE-4523.8.patch, HIVE-4523.patch
>
>
> // hive
> hive> select round(150.000, 2) from temp limit 1;
> 150.0
> hive> select round(150, 2) from temp limit 1;
> 150.0
> // mysql
> mysql> select round(150.000, 2) from DUAL limit 1;
> round(150.000, 2)
> 150.00
> mysql> select round(150, 2) from DUAL limit 1;
> round(150, 2)
> 150
> http://dev.mysql.com/doc/refman/5.1/en/mathematical-functions.html#function_round
--
This message was sent by Atlassian JIRA
(v6.2#6252)
