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

["Xu Mingmin (JIRA)" <ji...@apache.org>]

Xu Mingmin created BEAM-2160:
--------------------------------

             Summary: 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


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}



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