You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Dongjoon Hyun (JIRA)" <ji...@apache.org> on 2017/08/23 18:24:00 UTC
[jira] [Commented] (SPARK-20754) Add Function Alias For
MOD/TRUNCT/POSITION
[ https://issues.apache.org/jira/browse/SPARK-20754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16138829#comment-16138829 ]
Dongjoon Hyun commented on SPARK-20754:
---------------------------------------
Hi, [~smilegator].
Could you set [~q79969786] as `Assignee` of this issue? Thanks!
> 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
> Fix For: 2.3.0
>
>
> 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.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org