You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@beam.apache.org by "Xu Mingmin (JIRA)" <ji...@apache.org> on 2017/07/19 01:20:00 UTC

[jira] [Closed] (BEAM-2160) add support Math functions

     [ https://issues.apache.org/jira/browse/BEAM-2160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xu Mingmin closed BEAM-2160.
----------------------------
       Resolution: Fixed
    Fix Version/s:     (was: 2.2.0)
                   Not applicable

> add support Math functions 
> ---------------------------
>
>                 Key: BEAM-2160
>                 URL: https://issues.apache.org/jira/browse/BEAM-2160
>             Project: Beam
>          Issue Type: Task
>          Components: dsl-sql
>            Reporter: Xu Mingmin
>            Assignee: Tarush Grover
>              Labels: bundle, dsl_sql_merge, split
>             Fix For: Not applicable
>
>
> All Math functions listed as below:
> {code}
> POWER(numeric1, numeric2) 
> ABS(numeric) 
> MOD(numeric, numeric) 
> SQRT(numeric) 	
> LN(numeric) 	
> LOG10(numeric) 
> EXP(numeric) 	
> CEIL(numeric) 
> FLOOR(numeric) 	
> RAND([seed]) 	
> RAND_INTEGER([seed, ] numeric) 	
> ACOS(numeric)
> ASIN(numeric) 	
> ATAN(numeric) 	
> ATAN2(numeric, numeric) 	
> COS(numeric) 	
> COT(numeric) 	
> DEGREES(numeric) 	
> PI() 	
> RADIANS(numeric) 	
> ROUND(numeric1, numeric2) 	
> SIGN(numeric) 	
> SIN(numeric) 	
> TAN(numeric) 	
> TRUNCATE(numeric1, numeric2) 	
> {code}
> See  https://calcite.apache.org/docs/reference.html#arithmetic-operators-and-functions for more details.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)