[HIVE-4523] round() function with specified decimal places not consistent with mysql

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.7.1
• Fix Version/s: 0.13.0
• Component/s: UDF
• Labels: TODOC13
• Assignee: Xuefu Zhang Assign to me
• Reporter: Fred Desing
• Created: 08/May/13 16:21
• Updated: 10/Oct/14 17:39
• Resolved: 04/Nov/13 21:33

Description

// 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

Issue Links

• depends upon: HIVE-3976 Support specifying scale and precision with Hive decimal type
• is part of: HIVE-5356 Move arithmatic UDFs to generic UDF implementations
• is related to: HIVE-194 Support specifying decimal places for ROUND function
• links to: https://reviews.apache.org/r/15103/