| expr1 % expr2, or mod(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 % expr2, or mod(expr1, 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`. |
| 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_mod(dividend, divisor) |
Returns the remainder after `expr1`/`expr2`. `dividend` must be a numeric. `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. |
| uniform(min, max[, seed]) |
Returns a random value with independent and identically
distributed (i.i.d.) values with the specified range of numbers. The random seed is optional.
The provided numbers specifying the minimum and maximum values of the range must be constant.
If both of these numbers are integers, then the result will also be an integer. Otherwise if
one or both of these are floating-point numbers, then the result will also be a floating-point
number. |
| 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`." |