Xiao Li created SPARK-20754:
-------------------------------

             Summary: Add Function Alias For 
                 Key: SPARK-20754
                 URL: https://issues.apache.org/jira/browse/SPARK-20754
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.2.0
            Reporter: Xiao Li


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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to