--- url: /v6.2/en-us/calculation-function-number.md --- # Numeric Functions ## abs | Syntax | abs(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Absolute value operation | | Example | abs(-1), returns: 1 | ## acos | Syntax | acos(N) | |--------------|---------------------------| | Parameter | Numeric parameter, optional type: number | | Return Type | Number | | Description | Returns the arccosine of N, expressed in radians. N must be a value between \[-1, 1] | | Example | acos(0.5), returns: 1.0471975511966 | ## asin | Syntax | asin(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the arcsine of N, expressed in radians. N must be a value between \[-1, 1] | | Example | asin(0.5), returns: 0.523598775598299 | ## atan | Syntax | atan(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the arctangent of N, expressed in radians | | Example | atan(1), returns: 0.785398163397448 | ## atan2 | Syntax | atan2(ARG1, ARG2) | |----------------|---------------------------| | Parameter Description | Numeric type parameters, optional type: number | | Return Value Type | Number | | Description | Returns the arctangent value of arg1/arg2, expressed in radians | | Example | atan2(2, 2), returns: 0.785398163397448 | | Unsupported Data Sources | hive | ## ceil | Syntax | ceil(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Gets the smallest integer value greater than or equal to the specified number | | Example | ceil(3.2), returns: 4 | ## cbrt | Syntax | cbrt(N) | |--------------|---------------------------| | Parameter Description | Numeric type parameter, optional type: number | | Return Value Type | Number | | Description | Cube root operation | | Example | cbrt(8), returns: 2 | | Unsupported Data Sources | mysql, oracle, sqlserver, db2, impala, tidb, mongodb | ## cos | Syntax | cos(N) | |--------------|---------------------------| | Parameter | Numeric parameter, optional type: number | | Return Type | Number | | Description | Returns the cosine value of N, where N represents radians | | Example | cos(pi()/3), returns: 0.5 | ## cosh | Syntax | cosh(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the hyperbolic cosine value of N | | Example | cosh(1), returns: 1.5430806348152437 | | Unsupported Data Sources | postgres, greenplum, mysql, sqlserver, hive, tidb, presto, mongodb, redshift | ## cot | Syntax | cot(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the cotangent value of N, where N represents radians, and N cannot be 0 | | Example | cot(pi()/4), returns: 1 | ## degrees | Syntax | degrees(N) | |----------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Converts radians to degrees, N represents radians | | Example | degrees(pi()/2), returns: 90 | | Unsupported Data Source | oracle | ## exp | Syntax | exp(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | e raised to the power of N, where e is the base of the natural logarithm | | Example | exp(1), returns: 2.171828182845904 | ## floor | Syntax | floor(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Gets the largest integer less than or equal to the specified value | | Example | floor(3.8), returns: 3 | ## greatest | Syntax | greatest(ARG1, ARG2) | |----------------|---------------------------| | Parameters | ARG1: Numeric type parameter, optional type: Number ARG2: Numeric type parameter, optional type: Number | | Return Type | Number | | Description | Returns the largest value in the list | | Example | greatest(5, 10), returns: 10 | ## growth_rate | Syntax | growth_rate(CURRENT, PREVIOUS) | |----------------|-------------------------------| | Parameter Description | 1. Current value, optional type: number;2. Previous value, optional type: number | | Return Type | Number | | Description | Growth rate | | Example | growth_rate(120, 100), returns: 0.2 | ## ln | Syntax | ln(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the natural logarithm of N, where the natural logarithm is based on the constant e (2.71828182845904). N must be greater than 0. | | Example | ln(1), returns: 0 | ## log | Syntax | log(BASE, N) | |----------------|---------------------------| | Parameter Description | BASE, optional type: number N, optional type: number | | Return Type | number | | Description | Returns the logarithm of N with BASE as the base. BASE must be greater than 0 and cannot be 1, N must be greater than 0. | | Example | log(3, 9), returns: 2 | | Unsupported Data Sources | db2, redshift | ## log10 | Syntax | log10(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the base-10 logarithm, N must be greater than 0 | | Example | log10(100), returns: 2 | ## log2 | Syntax | log2(N) | |----------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the base-2 logarithm, N must be greater than 0 | | Example | log2(4), returns: 2 | | Unsupported Data Sources | db2, redshift | ## least | Syntax | least(ARG1, ARG2) | |----------------|---------------------------| | Parameter Description | ARG1: Numeric parameter, optional type: number ARG2: Numeric parameter, optional type: number | | Return Type | Number | | Description | Returns the smallest value in the list | | Example | least(5, 10), returns: 5 | ## median | Syntax | median(N) | |--------------|---------------------------| | Parameter Description | Numeric type parameter, optional type: number | | Return Value Type | Number | | Description | Retrieves the median of the specified numeric column | | Example | median(\[1, 2, 3, 4, 5]), returns: 3 | | Unsupported Data Sources | impala, hive, spark, sqlserver, tidb, mysql | ## mod | Syntax | mod(DIVIDEND, DIVISOR) | |--------------|---------------------------| | Parameters | 1. Dividend, optional type: number; 2. Divisor, optional type: number | | Return Type | Number | | Description | Modulo operation, parameters can be decimals | | Example | mod(12.3, 5), returns: 2.3 | ## percentile | Syntax | percentile(N, PERCENT) | |----------------|---------------------------| | Parameter Description | 1. Numeric type parameter, optional type: number;2. Internal parameter, optional type: number | | Return Value Type | Number | | Description | Calculates the percentile | | Example | percentile(\[1, 2, 3, 4, 5], 0.5), returns: 3 | | Unsupported Data Sources | impala, hive, spark, sqlserver, tidb, mysql, mongodb, maxcompute | ## pi | Syntax | pi() | |--------------|---------------------------| | Parameters | None | | Return Type | Number | | Description | π constant, equal to 3.14159265358979 | | Example | pi(), returns: 3.14159265358979 | | Unsupported Data Sources | oracle, db2 | ## power | Syntax | power(BASE, EXPONENT) | |--------------|---------------------------| | Parameters | 1. Base, optional type: Number;2. Exponent, optional type: Number | | Return Type | Number | | Description | Exponentiation operation | | Example | power(2, 3), returns: 8 | ## radians | Syntax | radians(N) | |----------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Converts degrees to radians, where N represents degrees | | Example | radians(180), returns: 3.14159265358979 | | Unsupported Data Sources | oracle | ## rand | Syntax | rand() | |--------------|---------------------------| | Parameters | None | | Return Type | Number | | Description | A random value in the range 0.0 <= N < 1.0 | | Example | rand(), returns: 0.763452189 (example value) | ## round | Syntax | round(N, LITERAL_PRECISION) | |----------------|-----------------------------| | Parameter Description | 1. Numeric type parameter, optional type: number;2. Specified precision, optional type: number | | Return Type | Number | | Description | Rounds to the specified number of decimal places | | Example | round(3.14159, 2), returns: 3.14 | ## rounddown | Syntax | rounddown(N, LITERAL_PRECISION) | |----------------|---------------------------------| | Parameter Description | 1. Numeric type parameter, optional type: number;2. Specified precision, optional type: number | | Return Value Type | Number | | Description | Rounds down to the specified number of decimal places | | Example | rounddown(3.14159, 2), returns: 3.14 | ## roundup | Syntax | roundup(N, LITERAL_PRECISION) | |----------------|-------------------------------| | Parameter Description | 1. Numeric type parameter, optional type: number;2. Specified precision, optional type: number | | Return Value Type | Number | | Description | Rounds up to the specified number of decimal places | | Example | roundup(3.14159, 2), returns: 3.15 | ## sign | Syntax | sign(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Sign function. For example: sign(x), if x > 0, returns 1; if x = 0, returns 0; if x < 0, returns -1 | | Example | sign(-5), returns: -1 | ## sin | Syntax | sin(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the sine value of N, where N represents radians | | Example | sin(pi()/6), returns: 0.5 | ## sinh | Syntax | sinh(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the hyperbolic sine of N | | Example | sinh(1), returns: 0.8686709614860095 | | Unsupported Data Sources | postgres, greenplum, mysql, sqlserver, hive, tidb, presto, mongodb, redshift | ## sqrt | Syntax | sqrt(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Square root operation | | Example | sqrt(16), returns: 4 | ## tan | Syntax | tan(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the tangent of N, where N represents radians | | Example | tan(pi()/4), returns: 1 | ## tanh | Syntax | tanh(N) | |--------------|---------------------------| | Parameter | Numeric type parameter, optional type: number | | Return Type | Number | | Description | Returns the hyperbolic tangent of N | | Example | tanh(1), returns: 0.7615941559557649 | | Unsupported Data Sources | postgres, greenplum, mysql, sqlserver, hive, tidb, presto, mongodb, redshift |