Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Drill >> mail # dev >> RE:  [jira] [Commented] (DRILL-247) New Math Functions: log, sqrt, cbrt, rand, round, exp, e, pi, pow

Copy link to this message
RE:  [jira] [Commented] (DRILL-247) New Math Functions: log, sqrt, cbrt, rand, round, exp, e, pi, pow
Am picking from Hive and Pig function list.

Sent from my Sony Xperia™ smartphone

"Ted Dunning (JIRA)" <[EMAIL PROTECTED]> wrote:
    [ https://issues.apache.org/jira/browse/DRILL-247?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13773839#comment-13773839 ]

Ted Dunning commented on DRILL-247:


What reference are you using for picking functions and names?

It might be nice to find names common to, say, Oracle, Postgres and Sequel Server.

> 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

NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.