hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Pivovarov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF
Date Thu, 13 Aug 2015 18:53:45 GMT

    [ 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)

Mime
View raw message