Mathematical Functions

This page covers mathematical operators and functions available in Rockset.

All functions accept arguments of types int and float. The return type is float, unless otherwise specified.

Note: A null argument to any mathematical function will result in a null return value

List of functions defined in this section:

Function	Description
`ABS(x)`	Returns absolute value of `x`. Return type is the same as input.
`ACOS(x)`	Computes the arc cosine of `x`.
`ACOSH(x)`	Computes the inverse hyperbolic cosine of `x`.
`ASIN(x)`	Computes the arc sine of `x`.
`ASINH(x)`	Computes the inverse hyperbolic sine of `x`.
`ATAN(x)`	Computes the arc tangent of `x`.
`ATAN2(y, x)`	Computes the arc tangent of `y / x`, but with proper sign for quadrant correction. That is, correctly computes the angle `θ` when converting from the Cartesian coordinates `(x, y)` to the polar coordinates `(r, θ)`.
`ATANH(x)`	Computes the inverse hyperbolic tangent of `x`.
`BITWISE_AND(x, y)`	Returns the bitwise AND of `x` and `y` in 2’s complement representation.
`BITWISE_NOT(x)`	Returns the bitwise NOT of `x` in 2’s complement representation.
`BITWISE_OR(x, y)`	Returns the bitwise OR of `x` and `y` in 2’s complement representation.
`BITWISE_XOR(x, y)`	Returns the bitwise XOR of `x` and `y` in 2’s complement representation.
`BIT_COUNT(x, bits)`	Count the number of bits set in `x` (treated as `bits`-bit signed integer) in 2’s complement representation.
`CEIL(x)`	Returns the smallest integral value that is not less than `x`.
`CEILING(x)`	Alias of `CEIL`.
`ACOS(x)`	Computes the arc cosine of `x`.
`ACOSH(x)`	Computes the inverse hyperbolic cosine of `x`.
`EXP(x)`	Computes `e` to the power of `x`.
`FLOOR(x)`	Returns the largest integral value that is not greater than `x`.
`FROM_BASE(string, base)`	Returns the value of `string` interpreted as a number in `base`.
`GREATEST(a, b, c, ...)`	Returns the argument that is greater than or equal to all other arguments.
`HYPOT(x, y)`	Computes `SQRT(xx + yy)`, that is, the length of the hypothenuse of a right-angled triangle with sides of lengths `x` and `y`. This is also the distance between the point at coordinates `(x, y)` and origin.
`IS_NAN(x)`	Returns true if the input is a floating point Not-A-Number, for instance, due to dividing zero by zero or taking the square root of a negative number. Non-numeric inputs yield null.
`LEAST(a, b, c, ...)`	Returns the argument that is less than or equal to all other arguments.
`LN(x)`	Computes the natural logarithm of `x`.
`LOG(x)`	Alias of `LN`.
`LOG10(x)`	Computes the base-10 logarithm of `x`.
`LOG2(x)`	Computes the base-2 logarithm of `x`.
`POW(x, y)`	Computes `x` to the power of `y`.
`POWER(x, y)`	Alias of `POW`.
`RAND()`	Returns a pseudo-random value in the range `[0.0, 1.0)`.
`ROUND(x)`	Returns the integral value that is nearest to `x`, with halfway cases rounded away from zero.
`SIGN(x)`	Returns sign of `x` as an integer: `-1` if `x` is negative, `0` if `x` is zero, `1` if `x` is positive.
`ASIN(x)`	Computes the arc sine of `x`.
`ASINH(x)`	Computes the inverse hyperbolic sine of `x`.
`SQRT(x)`	Computes the square root of `x`.
`ATAN(x)`	Computes the arc tangent of `x`.
`ATANH(x)`	Computes the inverse hyperbolic tangent of `x`.
`TRUNC(x)`	Alias of `TRUNCATE`.
`TRUNCATE(x)`	Rounds `x` toward zero, returning the nearest integral value that is not larger in magnitude than `x`.