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)