hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Pivovarov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-11103) Add banker's rounding BROUND UDF
Date Wed, 24 Jun 2015 23:20:05 GMT
Alexander Pivovarov created HIVE-11103:
------------------------------------------

             Summary: 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


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