beam-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xu Mingmin (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (BEAM-2160) add support Math functions
Date Wed, 03 May 2017 23:31:04 GMT

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

Xu Mingmin updated BEAM-2160:
-----------------------------
    Description: 
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.

  was:
All Math functions listed as below:
{code}
POWER(numeric1, numeric2) 	Returns numeric1 raised to the power of numeric2
ABS(numeric) 	Returns the absolute value of numeric
MOD(numeric, numeric) 	Returns the remainder (modulus) of numeric1 divided by numeric2. The
result is negative only if numeric1 is negative
SQRT(numeric) 	Returns the square root of numeric
LN(numeric) 	Returns the natural logarithm (base e) of numeric
LOG10(numeric) 	Returns the base 10 logarithm of numeric
EXP(numeric) 	Returns e raised to the power of numeric
CEIL(numeric) 	Rounds numeric up, returning the smallest integer that is greater than or equal
to numeric
FLOOR(numeric) 	Rounds numeric down, returning the largest integer that is less than or equal
to numeric
RAND([seed]) 	Generates a random double between 0 and 1 inclusive, optionally initializing
the random number generator with seed
RAND_INTEGER([seed, ] numeric) 	Generates a random integer between 0 and numeric - 1 inclusive,
optionally initializing the random number generator with seed
ACOS(numeric) 	Returns the arc cosine of numeric
ASIN(numeric) 	Returns the arc sine of numeric
ATAN(numeric) 	Returns the arc tangent of numeric
ATAN2(numeric, numeric) 	Returns the arc tangent of the numeric coordinates
COS(numeric) 	Returns the cosine of numeric
COT(numeric) 	Returns the cotangent of numeric
DEGREES(numeric) 	Converts numeric from radians to degrees
PI() 	Returns a value that is closer than any other value to pi
RADIANS(numeric) 	Converts numeric from degrees to radians
ROUND(numeric1, numeric2) 	Rounds numeric1 to numeric2 places right to the decimal point
SIGN(numeric) 	Returns the signum of numeric
SIN(numeric) 	Returns the sine of numeric
TAN(numeric) 	Returns the tangent of numeric
TRUNCATE(numeric1, numeric2) 	Truncates numeric1 to numeric2 places right to the decimal point
{code}


> 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
>              Labels: bundle, split
>
> 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.3.15#6346)

Mime
View raw message