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

.