[HIVE-9858] Create cbrt (cube root) UDF

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Component/s: UDF
• Assignee: Alexander Pivovarov
• Reporter: Alexander Pivovarov
• Created: 04/Mar/15 19:39
• Updated: 18/May/15 19:51
• Resolved: 16/Mar/15 17:36

Description

returns the cube root of a double value
cbrt(double a) : double

For example:

select cbrt(87860583272930481.0);
OK
444561.0

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

Issue Links

• links to: https://reviews.apache.org/r/31792/