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)

Reply via email to