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)