[
https://issues.apache.org/jira/browse/HIVE-4523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xuefu Zhang updated HIVE-4523:
------------------------------
Attachment: HIVE-4523.4.patch
Patch #4 rebased with trunk right before mvn branch merging in. It's expected
to be good for the latest as well.
Metadata determination for round() output is improved, and corresponding test
cases are added.
> 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
> Attachments: HIVE-4523.1.patch, HIVE-4523.2.patch, HIVE-4523.3.patch,
> HIVE-4523.4.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.1#6144)
