| expr1 % expr2 |
Returns the remainder after `expr1`/`expr2`. |
| expr1 * expr2 |
Returns `expr1`*`expr2`. |
| expr1 + expr2 |
Returns `expr1`+`expr2`. |
| expr1 - expr2 |
Returns `expr1`-`expr2`. |
| expr1 / expr2 |
Returns `expr1`/`expr2`. It always performs floating point division. |
| abs(expr) |
Returns the absolute value of the numeric or interval value. |
| acos(expr) |
Returns the inverse cosine (a.k.a. arc cosine) of `expr`, as if computed by
`java.lang.Math.acos`. |
| acosh(expr) |
Returns inverse hyperbolic cosine of `expr`. |
| asin(expr) |
Returns the inverse sine (a.k.a. arc sine) the arc sin of `expr`,
as if computed by `java.lang.Math.asin`. |
| asinh(expr) |
Returns inverse hyperbolic sine of `expr`. |
| atan(expr) |
Returns the inverse tangent (a.k.a. arc tangent) of `expr`, as if computed by
`java.lang.Math.atan` |
| atan2(exprY, exprX) |
Returns the angle in radians between the positive x-axis of a plane
and the point given by the coordinates (`exprX`, `exprY`), as if computed by
`java.lang.Math.atan2`. |
| atanh(expr) |
Returns inverse hyperbolic tangent of `expr`. |
| bin(expr) |
Returns the string representation of the long value `expr` represented in binary. |
| bround(expr, d) |
Returns `expr` rounded to `d` decimal places using HALF_EVEN rounding mode. |
| cbrt(expr) |
Returns the cube root of `expr`. |
| ceil(expr[, scale]) |
Returns the smallest number after rounding up that is not smaller than `expr`. An optional `scale` parameter can be specified to control the rounding behavior. |
| ceiling(expr[, scale]) |
Returns the smallest number after rounding up that is not smaller than `expr`. An optional `scale` parameter can be specified to control the rounding behavior. |
| conv(num, from_base, to_base) |
Convert `num` from `from_base` to `to_base`. |
| cos(expr) |
Returns the cosine of `expr`, as if computed by
`java.lang.Math.cos`. |
| cosh(expr) |
Returns the hyperbolic cosine of `expr`, as if computed by
`java.lang.Math.cosh`. |
| cot(expr) |
Returns the cotangent of `expr`, as if computed by `1/java.lang.Math.tan`. |
| csc(expr) |
Returns the cosecant of `expr`, as if computed by `1/java.lang.Math.sin`. |
| degrees(expr) |
Converts radians to degrees. |
| expr1 div expr2 |
Divide `expr1` by `expr2`. It returns NULL if an operand is NULL or `expr2` is 0. The result is casted to long. |
| e() |
Returns Euler's number, e. |
| exp(expr) |
Returns e to the power of `expr`. |
| expm1(expr) - Returns exp(`expr`) |
1. |
| factorial(expr) |
Returns the factorial of `expr`. `expr` is [0..20]. Otherwise, null. |
| floor(expr[, scale]) |
Returns the largest number after rounding down that is not greater than `expr`. An optional `scale` parameter can be specified to control the rounding behavior. |
| greatest(expr, ...) |
Returns the greatest value of all parameters, skipping null values. |
| hex(expr) |
Converts `expr` to hexadecimal. |
| hypot(expr1, expr2) |
Returns sqrt(`expr1`**2 + `expr2`**2). |
| least(expr, ...) |
Returns the least value of all parameters, skipping null values. |
| ln(expr) |
Returns the natural logarithm (base e) of `expr`. |
| log(base, expr) |
Returns the logarithm of `expr` with `base`. |
| log10(expr) |
Returns the logarithm of `expr` with base 10. |
| log1p(expr) |
Returns log(1 + `expr`). |
| log2(expr) |
Returns the logarithm of `expr` with base 2. |
| expr1 mod expr2 |
Returns the remainder after `expr1`/`expr2`. |
| negative(expr) |
Returns the negated value of `expr`. |
| pi() |
Returns pi. |
| pmod(expr1, expr2) |
Returns the positive value of `expr1` mod `expr2`. |
| positive(expr) |
Returns the value of `expr`. |
| pow(expr1, expr2) |
Raises `expr1` to the power of `expr2`. |
| power(expr1, expr2) |
Raises `expr1` to the power of `expr2`. |
| radians(expr) |
Converts degrees to radians. |
| rand([seed]) |
Returns a random value with independent and identically distributed (i.i.d.) uniformly distributed values in [0, 1). |
| randn([seed]) |
Returns a random value with independent and identically distributed (i.i.d.) values drawn from the standard normal distribution. |
| random([seed]) |
Returns a random value with independent and identically distributed (i.i.d.) uniformly distributed values in [0, 1). |
| rint(expr) |
Returns the double value that is closest in value to the argument and is equal to a mathematical integer. |
| round(expr, d) |
Returns `expr` rounded to `d` decimal places using HALF_UP rounding mode. |
| sec(expr) |
Returns the secant of `expr`, as if computed by `1/java.lang.Math.cos`. |
| shiftleft(base, expr) |
Bitwise left shift. |
| sign(expr) |
Returns -1.0, 0.0 or 1.0 as `expr` is negative, 0 or positive. |
| signum(expr) |
Returns -1.0, 0.0 or 1.0 as `expr` is negative, 0 or positive. |
| sin(expr) |
Returns the sine of `expr`, as if computed by `java.lang.Math.sin`. |
| sinh(expr) |
Returns hyperbolic sine of `expr`, as if computed by `java.lang.Math.sinh`. |
| sqrt(expr) |
Returns the square root of `expr`. |
| tan(expr) |
Returns the tangent of `expr`, as if computed by `java.lang.Math.tan`. |
| tanh(expr) |
Returns the hyperbolic tangent of `expr`, as if computed by
`java.lang.Math.tanh`. |
| try_add(expr1, expr2) |
Returns the sum of `expr1`and `expr2` and the result is null on overflow. The acceptable input types are the same with the `+` operator. |
| try_divide(dividend, divisor) |
Returns `dividend`/`divisor`. It always performs floating point division. Its result is always null if `expr2` is 0. `dividend` must be a numeric or an interval. `divisor` must be a numeric. |
| try_multiply(expr1, expr2) |
Returns `expr1`*`expr2` and the result is null on overflow. The acceptable input types are the same with the `*` operator. |
| try_subtract(expr1, expr2) |
Returns `expr1`-`expr2` and the result is null on overflow. The acceptable input types are the same with the `-` operator. |
| unhex(expr) |
Converts hexadecimal `expr` to binary. |
| width_bucket(value, min_value, max_value, num_bucket) |
Returns the bucket number to which
`value` would be assigned in an equiwidth histogram with `num_bucket` buckets,
in the range `min_value` to `max_value`." |