[
https://issues.apache.org/jira/browse/DRILL-247?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13773844#comment-13773844
]
Yash Sharma commented on DRILL-247:
-----------------------------------
I have compiled the list from Apache Hive and Pig math functions. All the
function name are same as the functions present in Oracle and MySQL apart from
CBRT. The CBRT() function is a new addition to the list (from Pig).
> New Math Functions: log, sqrt, cbrt, rand, round, exp, e, pi, pow
> -----------------------------------------------------------------
>
> Key: DRILL-247
> URL: https://issues.apache.org/jira/browse/DRILL-247
> Project: Apache Drill
> Issue Type: Improvement
> Reporter: Yash Sharma
>
> Improving the math functions collection with more functions:
> log(a): the natural logarithm (base e) of an expression
> log10(a): base 10 logarithm
> sqrt(a): square root
> cbrt(a): cube root
> rand(): returns random number from 0-1.
> round(a)
> exp(a): exponential e^a
> e(): returns value of e
> pi(): returns value of pi
> pow(a, p): returns a^p
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
