You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/06/14 09:31:00 UTC

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

    [ https://issues.apache.org/jira/browse/FLINK-6891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16048933#comment-16048933 ] 

ASF GitHub Bot commented on FLINK-6891:
---------------------------------------

GitHub user sunjincheng121 opened a pull request:

    https://github.com/apache/flink/pull/4122

    [FLINK-6891][table]Add LOG supported in SQL

    In this PR. I have Add LOG supported in SQL.
    - [x] General
      - The pull request references the related JIRA issue ("[FLINK-6891][table]Add LOG supported in SQL")
      - The pull request addresses only one issue
      - Each commit in the PR has a meaningful commit message (including the JIRA id)
    
    - [ ] Documentation
      - Documentation has been added for new functionality
      - Old documentation affected by the pull request has been updated
      - JavaDoc for public methods has been added
    
    - [x] Tests & Build
      - Functionality added by the pull request is covered by tests
      - `mvn clean verify` has been executed successfully locally or a Travis build has passed


You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/sunjincheng121/flink FLINK-6891-PR

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/flink/pull/4122.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #4122
    
----
commit dc5abc607f321381ae8ddf72b04697d66b9d2189
Author: sunjincheng121 <su...@gmail.com>
Date:   2017-06-14T09:13:55Z

    [FLINK-6891][table]Add LOG supported in SQL

----


> 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
>            Assignee: 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)