spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yuming Wang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SPARK-20754) Add Function Alias For MOD/TRUNCT/POSITION
Date Sun, 21 May 2017 08:34:04 GMT

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

Yuming Wang commented on SPARK-20754:
-------------------------------------

I am working on this.

> Add Function Alias For MOD/TRUNCT/POSITION
> ------------------------------------------
>
>                 Key: SPARK-20754
>                 URL: https://issues.apache.org/jira/browse/SPARK-20754
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 2.2.0
>            Reporter: Xiao Li
>              Labels: starter
>
> We already have the impl of the following functions. We can add the function alias to
be consistent with ANSI. 
> {noformat} 
> MOD(<m>,<n>)
> {noformat} 
> Returns the remainder of m divided by n. Returns m if n is 0.
> {noformat} 
> TRUNC
> {noformat} 
> Returns the number x, truncated to D decimals. If D is 0, the result will have no decimal
point or fractional part. If D is negative, the number is zeroed out.
> {noformat} 
> POSITION
> {noformat} 
> Returns the position of the char IN <string>) in the source string.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message