[
https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14695754#comment-14695754
]
Alexander Pivovarov commented on HIVE-11103:
--------------------------------------------
Added the function description to the wiki
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-MathematicalFunctions
> Add banker's rounding BROUND UDF
> --------------------------------
>
> Key: HIVE-11103
> URL: https://issues.apache.org/jira/browse/HIVE-11103
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Alexander Pivovarov
> Assignee: Alexander Pivovarov
> Fix For: 1.3.0, 2.0.0
>
> Attachments: HIVE-11103.1.patch, HIVE-11103.1.patch,
> HIVE-11103.2.patch, HIVE-11103.4.patch
>
>
> Banker's rounding: the value is rounded to the nearest even number. Also
> known as "Gaussian rounding", and, in German, "mathematische Rundung".
> Example
> {code}
> 2 digits 2 digits
> Unrounded "Standard" rounding "Gaussian" rounding
> 54.1754 54.18 54.18
> 343.2050 343.21 343.20
> +106.2038 +106.20 +106.20
> ========= ======= =======
> 503.5842 503.59 503.58
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
