[ https://issues.apache.org/jira/browse/HIVE-9858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14354453#comment-14354453 ]
Hive QA commented on HIVE-9858: ------------------------------- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12703570/HIVE-9858.2.patch {color:green}SUCCESS:{color} +1 7615 tests passed Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2986/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2986/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2986/ 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: 12703570 - PreCommit-HIVE-TRUNK-Build > Create cbrt (cube root) UDF > --------------------------- > > Key: HIVE-9858 > URL: https://issues.apache.org/jira/browse/HIVE-9858 > Project: Hive > Issue Type: Improvement > Components: UDF > Reporter: Alexander Pivovarov > Assignee: Alexander Pivovarov > Attachments: HIVE-9858.1.patch, HIVE-9858.1.patch, HIVE-9858.2.patch > > > returns the cube root of a double value > cbrt(double a) : double > For example: > {code} > select cbrt(87860583272930481.0); > OK > 444561.0 > {code} > I noticed that Math.pow(a, 1.0/3.0) and hive power UDF return > 444560.99999999965 for the example above. > However Math.cbrt returns 444561.0 > This is why we should have hive cbrt function in hive -- This message was sent by Atlassian JIRA (v6.3.4#6332)