You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "sunjincheng (JIRA)" <ji...@apache.org> on 2017/06/12 08:42:00 UTC

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

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)