[jira] [Created] (FLINK-6891) Add LOG supported in SQL

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[jira] [Created] (FLINK-6891) Add LOG supported in SQL

JIRA jira@apache.org
sunjincheng created FLINK-6891:
----------------------------------

             Summary: Add LOG supported in SQL
                 Key: FLINK-6891
                 URL: https://issues.apache.org/jira/browse/FLINK-6891
             Project: Flink
          Issue Type: Sub-task
          Components: Table API & SQL
    Affects Versions: 1.4.0
            Reporter: sunjincheng


LONG (N) A single parameter version of the function returns the natural logarithm of N, and if two arguments are called, it returns any radix of the logarithm of N.
* Syntax:
LOG ( float_expression [, base ] )  

* Arguments
**float_expression:  Is an expression of type float or of a type that can be implicitly converted to float.
**base: Optional integer argument that sets the base for the logarithm.

* Return Types
  float

* Example:
  LOG(10) -> 2.30

*See more:
 **[MSQL|https://docs.microsoft.com/en-us/sql/t-sql/functions/log-transact-sql]
 **[MySQL| https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html#function_log]





--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
Loading...