[ https://issues.apache.org/jira/browse/HIVE-4523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14166944#comment-14166944 ]
Xuefu Zhang commented on HIVE-4523: ----------------------------------- [~wzc1989] I don't quite understand your use case, but Hive 0.13 is already released. Did you mean to change the behavior for next release (0.15)? Then 0.15 would also have a different behavior from 0.14 and 0.13. Could you explain why returning float isn't enough? > 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.3.4#6332)