Mathematical Functions¶
- abs(x) [same as x] ¶
Returns the absolute value of
x
.
- add(x, y) [same as x] ¶
Returns the result of adding x to y. The types of x and y must be the same. For integral types, overflow results in an error. Corresponds to sparks’s operator
+
.
- ceil(x) [same as x] ¶
Returns
x
rounded up to the nearest integer. Supported types are: BIGINT and DOUBLE.
- divide(x, y) double ¶
Returns the results of dividing x by y. Performs floating point division. Corresponds to Spark’s operator
/
.SELECT 3 / 2; -- 1.5 SELECT 2L / 2L; -- 1.0 SELECT 3 / 0; -- NULL
- exp(x) double ¶
Returns Euler’s number raised to the power of
x
.
- floor(x) [same as x] ¶
Returns
x
rounded down to the nearest integer. Supported types are: BIGINT and DOUBLE.
- multiply(x, y) [same as x] ¶
Returns the result of multiplying x by y. The types of x and y must be the same. For integral types, overflow results in an error. Corresponds to Spark’s operator
*
.
- not(x) boolean ¶
Logical not.
SELECT not true; -- false SELECT not false; -- true SELECT not NULL; -- NULL
- pmod(n, m) [same as n] ¶
Returns the positive remainder of n divided by m.
- power(x, p) double ¶
Returns
x
raised to the power ofp
.
- rand() double ¶
Returns a random value with independent and identically distributed uniformly distributed values in [0, 1).
SELECT rand(); -- 0.9629742951434543 SELECT rand(0); -- 0.7604953758285915 SELECT rand(null); -- 0.7604953758285915
- remainder(n, m) [same as n] ¶
Returns the modulus (remainder) of
n
divided bym
. Corresponds to Spark’s operator%
.
- round(x, d) [same as x] ¶
Returns
x
rounded tod
decimal places using HALF_UP rounding mode. In HALF_UP rounding, the digit 5 is rounded up.
- subtract(x, y) [same as x] ¶
Returns the result of subtracting y from x. The types of x and y must be the same. For integral types, overflow results in an error. Corresponds to Spark’s operator
-
.
- unaryminus(x) [same as x] ¶
Returns the negative of x. Corresponds to Spark’s operator
-
.