...
Return Type | Name (Signature) | Description | Source code | ||||||
---|---|---|---|---|---|---|---|---|---|
double | round(double a) | Returns the rounded | |||||||
double | round(double a,int d) | Returns | |||||||
double | bround(double a) | Returns the rounded bigint value of a using HALF_EVEN rounding mode. Also known as Gaussian rounding or bankers' rounding. Example: bround(2.5) = 2, bround(3.5) = 4. | GenericUDFBRound | ||||||
double | bround(double a,int d) | Returns a rounded to d decimal places using HALF_EVEN rounding mode. Example: bround(8.25, 1) = 8.2, bround(8.35, 1) = 8.4. | |||||||
bigint | floor(double a) | Returns the maximum | |||||||
bigint | ceil(double a), ceiling(double a) | Returns the minimum bigint value that is equal to or greater than | |||||||
double | rand(), rand(INT seed) | Returns a random number (that changes from row to row) that is distributed uniformly from 0 to 1. Specifying the seed will make sure the generated random number sequence is deterministic. | |||||||
double | exp(double a), exp(decimal a) | Returns | |||||||
double | ln(double a), ln(decimal a) | Returns the natural logarithm of the argument | |||||||
double | log10(double a), log10(decimal a) | Returns the base-10 logarithm of the argument | |||||||
double | log2(double a), log2(decimal a) | Returns the base-2 logarithm of the argument | |||||||
double | log(double base, double a) log(decimal base, decimal a) | Returns the base- | |||||||
double | pow(double a, double p), power(double a, double p) | Returns | |||||||
double | sqrt(double a), sqrt(decimal a) | Returns the square root of | |||||||
string | bin(bigint a) | Returns the number in binary format. | |||||||
string | hex(bigint a) hex(string a) hex(binary a) | If the argument is an int or | |||||||
binary | unhex(STRING a) | Inverse of hex.interprets each pair of characters as a hexadecimal number and converts to the byte representation of the number. | |||||||
string | conv(bigint num,int from_base,int to_base), conv(STRING num,int from_base,int to_base) | Converts a number from a given base to another. | |||||||
double | abs(double a) | Returns the absolute value. | |||||||
int or double | pmod(INT a,int b), pmod(double a, double b) | Returns the positive value of | |||||||
double | sin(double a), sin(decimal a) | Returns the sine of | |||||||
double | asin(double a), asin(decimal a) | Returns the arc sin of | |||||||
double | cos(double a), cos(decimal a) | Returns the cosine of | |||||||
double | acos(double a), acos(decimal a) | Returns the arccosine of | |||||||
double | tan(double a), tan(decimal a) | Returns the tangent of | |||||||
double | atan(double a), atan(decimal a) | Returns the arctangent of | |||||||
double | degrees(double a), degrees(decimal a) | Converts value of | |||||||
double | radians(double a), radians(double a) | Converts value of | |||||||
int or double | positive(INT a), positive(double a) | Returns | |||||||
int or double | negative(INT a), negative(double a) | Returns | |||||||
double or int | sign(double a), sign(decimal a) | Returns the sign of | |||||||
double | e() | Returns the value of | |||||||
double | pi() | Returns the value of | |||||||
bigint | factorial(INT a) | Returns the factorial of a Valid a is [0..20]. | GenericUDFFactorial | ||||||
double | cbrt(double a) | Returns the cube root of a double value. | GenericUDFCbrt | ||||||
int bigint | shiftleft(TINYINT|SMALLINT|INT a,int b) shiftleft(bigint a,int b) | Bitwise left shift. Shifts Returns int for tinyint, smallint andint | |||||||
int bigint | shiftright(TINYINT|SMALLINT|INT a,int b) shiftright(bigint a,int b) | Bitwise right shift. Shifts Returns int for tinyint, smallint andint | |||||||
int bigint | shiftrightunsigned(TINYINT|SMALLINT|INT a,int b), shiftrightunsigned(bigint a,int b) | Bitwise unsigned right shift. Shifts Returns int for tinyint, smallint andint | |||||||
T | greatest(T v1, T v2, ...) | Returns the greatest value of the list of values. Fixed to return NULL when one or more arguments are NULL, and strict type restriction relaxed, consistent with ">" operator. | GenericUDFGreatest | ||||||
T | least(T v1, T v2, ...) | Returns the least value of the list of values. Fixed to return NULL when one or more arguments are NULL, and strict type restriction relaxed, consistent with "<" operator. | GenericUDFLeast | ||||||
int | width_bucket(NUMERIC expr, NUMERIC min_value, NUMERIC max_value,int num_buckets) | Returns an integer between 0 and num_buckets+1 by mapping expr into the ith equally sized bucket. Buckets are made by dividing [min_value, max_value]into equally sized regions. If expr < min_value, return 1, if expr > max_value return num_buckets+1. See https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions214.htm | |||||||
double | cosh(double x) |
| |||||||
double | tanh(double x) |
|
Collection Functions
...