[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF
[
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 digits2 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)
[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF
[
https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14695730#comment-14695730
]
Alexander Pivovarov commented on HIVE-11103:
Committed to master and branch-1. Thank you Jason for your review!
> 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 digits2 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)
[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF
[
https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14693119#comment-14693119
]
Jason Dere commented on HIVE-11103:
---
+1
> 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
> 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 digits2 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)
[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF
[
https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14680179#comment-14680179
]
Hive QA commented on HIVE-11103:
{color:green}Overall{color}: +1 all checks pass
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12749540/HIVE-11103.4.patch
{color:green}SUCCESS:{color} +1 9354 tests passed
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4902/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4902/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-4902/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12749540 - PreCommit-HIVE-TRUNK-Build
> 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
> 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 digits2 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)
[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF
[
https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14643001#comment-14643001
]
Alexander Pivovarov commented on HIVE-11103:
I do not think 2 tests failure relates to patch #2
> 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
> Attachments: HIVE-11103.1.patch, HIVE-11103.1.patch,
> HIVE-11103.2.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 digits2 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)
[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF
[
https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14642413#comment-14642413
]
Hive QA commented on HIVE-11103:
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12747288/HIVE-11103.2.patch
{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 9265 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_index_bitmap3
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_stats_counter_partitioned
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4717/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4717/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-4717/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 2 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12747288 - PreCommit-HIVE-TRUNK-Build
> 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
> Attachments: HIVE-11103.1.patch, HIVE-11103.1.patch,
> HIVE-11103.2.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 digits2 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)
[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF
[
https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14606634#comment-14606634
]
Jason Dere commented on HIVE-11103:
---
I'll try to take a look this week
> 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
> Attachments: HIVE-11103.1.patch, HIVE-11103.1.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 digits2 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)
[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF
[
https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14605162#comment-14605162
]
Alexander Pivovarov commented on HIVE-11103:
2 errors are unrelated to the patch.
[~jdere] could you look at this new UDF?
This UDF is useful for financial/accounting SQL projects.
People keep asking about it, e.g.
http://www.databasejournal.com/features/mysql/rounding-down-bankers-rounding-and-random-rounding-in-mysql.html
http://www.sqlservercentral.com/Forums/Topic246556-8-1.aspx
> 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
> Attachments: HIVE-11103.1.patch, HIVE-11103.1.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 digits2 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)
[jira] [Commented] (HIVE-11103) Add banker's rounding BROUND UDF
[
https://issues.apache.org/jira/browse/HIVE-11103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14604567#comment-14604567
]
Hive QA commented on HIVE-11103:
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12742349/HIVE-11103.1.patch
{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 9038 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testSaslWithHiveMetaStore
org.apache.hive.jdbc.TestSSL.testSSLFetchHttp
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4421/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4421/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-4421/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 2 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12742349 - PreCommit-HIVE-TRUNK-Build
> 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
> Attachments: HIVE-11103.1.patch, HIVE-11103.1.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 digits2 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)
