Math Functions

`abs`

Returns the absolute value of x. Examples:

examples.sql

select abs(-1) as value; -- value '1.0'

Supported Signatures

function abs(tinyint) returns tinyint
function abs(smallint) returns smallint
function abs(bigint) returns bigint
function abs(double) returns double
function abs(decimal(p, s)) returns decimal(p, s)
function abs(real) returns real

🔗 Official Documentation

`acos`

Returns the arc cosine of x. Examples:

examples.sql

select acos(0.5) as value; -- value '1.0471975511965976'

Supported Signatures

function acos(double) returns double

🔗 Official Documentation

`asin`

Returns the arc sine of x. Examples:

examples.sql

select asin(1) as value; -- value '1.5707963267948966'

Supported Signatures

function asin(double) returns double

🔗 Official Documentation

`atan`

Returns the arc tangent of x. Examples:

examples.sql

select atan(0) as value; -- value '0.0'

Supported Signatures

function atan(double) returns double

🔗 Official Documentation

`atan2`

Returns the arc tangent of y / x. Examples:

examples.sql

select atan2(1, 0.5) as value; -- value '1.1071487177940904'

Supported Signatures

function atan2(double, double) returns double

🔗 Official Documentation

`beta_cdf`

Compute the Beta cdf with given a, b parameters. P(N < v; a, b). The a, b parameters must be positive real numbers and value v must be a real value. The value v must lie on the interval [0, 1]. Supported Signatures

function beta_cdf(double, double, double) returns double

🔗 Official Documentation

`cbrt`

Returns the cube root of x. Examples:

examples.sql

SELECT cbrt(328509) as value; -- value '69.0'

Supported Signatures

function cbrt(double) returns double

🔗 Official Documentation

`ceil`

This is an alias for ceiling(). Examples:

examples.sql

SELECT ceil(1.3) AS value; -- value '2.0'

Supported Signatures

function ceil(bigint) returns bigint
function ceil(decimal(p, s)) returns decimal(rp, 0)
function ceil(double) returns double
function ceil(integer) returns integer
function ceil(real) returns real
function ceil(smallint) returns smallint
function ceil(tinyint) returns tinyint

🔗 Official Documentation

`ceiling`

Returns x rounded up to the nearest integer. Supported Signatures

function ceiling(bigint) returns bigint
function ceiling(decimal(p, s)) returns decimal(rp, 0)
function ceiling(double) returns double
function ceiling(integer) returns integer
function ceiling(real) returns real
function ceiling(smallint) returns smallint
function ceiling(tinyint) returns tinyint

🔗 Official Documentation

`cos`

Returns the cosine of x. Examples:

examples.sql

select cos(1.0) as value; -- value '0.5403023058681398'

Supported Signatures

function cos(double) returns double

🔗 Official Documentation

`cosh`

Returns the hyperbolic cosine of the given value. Examples:

examples.sql

SELECT cosh(0) AS value; -- value '1.0'

Supported Signatures

function cosh(double) returns double

🔗 Official Documentation

`cosine_similarity`

Returns the cosine similarity between the sparse vectors x and y. Supported Signatures

function cosine_similarity(map<varchar, double>, map<varchar, double>) returns double

🔗 Official Documentation

`degrees`

Converts angle x in radians to degrees. Examples:

examples.sql

SELECT degrees(3.14159) AS value; -- value '179.9998547447946'

Supported Signatures

function degrees(double) returns double

🔗 Official Documentation

`e`

Returns the constant Euler’s number. Supported Signatures

function e() returns double

🔗 Official Documentation

`exp`

Returns Euler’s number raised to the power of x. Examples:

examples.sql

select exp(1.0) as value; -- value '2.718281828459045'

Supported Signatures

function exp(double) returns double

🔗 Official Documentation

`floor`

Returns x rounded down to the nearest integer. Supported Signatures

function floor(bigint) returns bigint
function floor(decimal(p, s)) returns decimal(rp, 0)
function floor(double) returns double
function floor(integer) returns integer
function floor(real) returns real
function floor(smallint) returns smallint
function floor(tinyint) returns tinyint

🔗 Official Documentation

`from_base`

Returns the value of string interpreted as a base-radix number. Supported Signatures

function from_base(varchar, bigint) returns bigint

🔗 Official Documentation

`infinity`

Returns the constant representing positive infinity. Supported Signatures

function infinity() returns double

🔗 Official Documentation

`inverse_beta_cdf`

Compute the inverse of the Beta cdf with given a, b parameters for the cumulative probability (p). P(N < n). The a, b parameters must be positive real values. The probability p must lie on the interval [0, 1]. Supported Signatures

function inverse_beta_cdf(double, double, double) returns double

🔗 Official Documentation

`inverse_normal_cdf`

Compute the inverse of the Normal cdf with given mean and standard deviation (sd) for the cumulative probability (p). P(N < n). The mean must be a real value and the standard deviation must be a real and positive value. The probability p must lie on the interval (0, 1). Supported Signatures

function inverse_normal_cdf(double, double, double) returns double

🔗 Official Documentation

`is_finite`

Determine if x is finite. Supported Signatures

function is_finite(double) returns boolean

🔗 Official Documentation

`is_infinite`

Determine if x is infinite. Supported Signatures

function is_infinite(double) returns boolean

🔗 Official Documentation

`is_nan`

Determine if x is not-a-number. Examples:

examples.sql

select is_nan(1.1) as value; -- value 'false'

Supported Signatures

function is_nan(double) returns boolean
function is_nan(real) returns boolean

🔗 Official Documentation

`ln`

Returns the natural logarithm of x. Examples:

examples.sql

select ln(2.1) as value; -- value '0.7419373447293773'

Supported Signatures

function ln(double) returns double

🔗 Official Documentation

`log`

Returns the base b logarithm of x. Examples:

examples.sql

SELECT log(2.19, 1) AS value; -- value '0.0'

Supported Signatures

function log(double, double) returns double

🔗 Official Documentation

`log10`

Returns the base 10 logarithm of x. Examples:

examples.sql

select log10(10) as value; -- value '1.0'

Supported Signatures

function log10(double) returns double

🔗 Official Documentation

`log2`

Returns the base 2 logarithm of x. Examples:

examples.sql

select log2(2) as value; -- value '1.0'

Supported Signatures

function log2(double) returns double

🔗 Official Documentation

`mod`

Returns the modulus (remainder) of n divided by m. Supported Signatures

function mod(bigint, bigint) returns bigint
function mod(decimal(a_precision, a_scale), decimal(b_precision, b_scale)) returns decimal(r_precision, r_scale)
function mod(double, double) returns double
function mod(integer, integer) returns integer
function mod(real, real) returns real
function mod(smallint, smallint) returns smallint
function mod(tinyint, tinyint) returns tinyint

🔗 Official Documentation

`nan`

Returns the constant representing not-a-number. Supported Signatures

function nan() returns double

🔗 Official Documentation

`normal_cdf`

Compute the Normal cdf with given mean and standard deviation (sd). P(N < v; mean, sd). The mean and value v must be real values and the standard deviation must be a real and positive value. Supported Signatures

function normal_cdf(double, double, double) returns double

🔗 Official Documentation

`pi`

Returns the constant Pi. Examples:

examples.sql

SELECT PI() -- value '3.141592653589793'

Supported Signatures

function pi() returns double

🔗 Official Documentation

`pow`

This is an alias for power(). Supported Signatures

function pow(double, double) returns double

🔗 Official Documentation

`power`

Returns x raised to the power of p. Examples:

examples.sql

select power(2, 8) as value; -- value '256'

Supported Signatures

function power(double, double) returns double

🔗 Official Documentation

`radians`

Converts angle x in degrees to radians. Examples:

examples.sql

SELECT radians(360) AS value; -- value '6.283185307179586'

Supported Signatures

function radians(double) returns double

🔗 Official Documentation

`rand`

This is an alias for random(). Examples:

examples.sql

SELECT rand() AS value; -- value '0.20138668902074985'

Supported Signatures

function rand(bigint) returns bigint
function rand(bigint, bigint) returns bigint
function rand() returns double
function rand(integer) returns integer
function rand(integer, integer) returns integer
function rand(smallint) returns smallint
function rand(smallint, smallint) returns smallint
function rand(tinyint) returns tinyint
function rand(tinyint, tinyint) returns tinyint

Note: rand() is volatile, i.e. might return a different value for the same input. 🔗 Official Documentation

`random`

Returns a pseudo-random value in the range 0.0 <= x < 1.0. Supported Signatures

function random(bigint) returns bigint
function random(bigint, bigint) returns bigint
function random() returns double
function random(integer) returns integer
function random(integer, integer) returns integer
function random(smallint) returns smallint
function random(smallint, smallint) returns smallint
function random(tinyint) returns tinyint
function random(tinyint, tinyint) returns tinyint

Note: random() is volatile, i.e. might return a different value for the same input. 🔗 Official Documentation

`round`

Returns x rounded to the nearest integer. Examples:

examples.sql

select round(2.1) as value; -- value '2.0'

Supported Signatures

function round(double) returns double
function round(double, bigint) returns double
function round(real) returns real
function round(real, bigint) returns real
function round(integer) returns integer
function round(integer, integer) returns integer
function round(decimal(p, s)) returns decimal(rp, rs)
function round(decimal(p, s), bigint) returns decimal(rp, s)
function round(bigint) returns bigint
function round(bigint, bigint) returns bigint
function round(smallint) returns smallint
function round(smallint, bigint) returns smallint
function round(tinyint) returns tinyint
function round(tinyint, bigint) returns tinyint

🔗 Official Documentation

`sign`

Returns the signum function of x, that is. Supported Signatures

function sign(bigint) returns bigint
function sign(decimal(p, s)) returns decimal(1, 0)
function sign(double) returns double
function sign(integer) returns integer
function sign(real) returns real
function sign(smallint) returns smallint
function sign(tinyint) returns tinyint

🔗 Official Documentation

`sin`

Returns the sine of x. Examples:

examples.sql

select sin(2.1) as value; -- value '-0.8632093666488737'

Supported Signatures

function sin(double) returns double

🔗 Official Documentation

`sinh`

Returns the hyperbolic sine of x. Examples:

examples.sql

SELECT sinh(1) AS value; -- value '1.1752011936438014'

Supported Signatures

function sinh(double) returns double

🔗 Official Documentation

`sqrt`

Returns the square root of x. Examples:

examples.sql

select sqrt(16) as value; -- value '4.0'

Supported Signatures

function sqrt(double) returns double

🔗 Official Documentation

`tan`

Returns the tangent of x. Examples:

examples.sql

select tan(0.5) as value; -- value '0.5463024898437905'

Supported Signatures

function tan(double) returns double

🔗 Official Documentation

`tanh`

Returns the hyperbolic tangent of x. Examples:

examples.sql

SELECT tanh(1.0) AS value; -- value '0.7615941559557649'

Supported Signatures

function tanh(double) returns double

🔗 Official Documentation

`to_base`

Returns the base-radix representation of x. Supported Signatures

function to_base(bigint, bigint) returns varchar

🔗 Official Documentation

`truncate`

Returns x rounded to integer by dropping digits after decimal point. Examples:

examples.sql

SELECT truncate(1.23456, 2) as value; -- value '1.23'

Supported Signatures

function truncate(decimal(p, s), bigint) returns decimal(p, s)
function truncate(decimal(p, s)) returns decimal(rp, 0)
function truncate(double) returns double
function truncate(real) returns real

🔗 Official Documentation

`width_bucket`

Returns the bin number of x in an equi-width histogram with the specified bound1 and bound2 bounds and n number of buckets. Supported Signatures

function width_bucket(double, array<double>) returns bigint
function width_bucket(double, double, double, bigint) returns bigint

🔗 Official Documentation

`wilson_interval_lower`

Returns the lower bound of the Wilson score interval of a Bernoulli trial process at a confidence specified by the z-score z. Supported Signatures

function wilson_interval_lower(bigint, bigint, double) returns double

🔗 Official Documentation

`wilson_interval_upper`

Returns the upper bound of the Wilson score interval of a Bernoulli trial process at a confidence specified by the z-score z. Supported Signatures

function wilson_interval_upper(bigint, bigint, double) returns double

🔗 Official Documentation

​abs

​acos

​asin

​atan

​atan2

​beta_cdf

​cbrt

​ceil

​ceiling

​cos

​cosh

​cosine_similarity

​degrees

​e

​exp

​floor

​from_base

​infinity

​inverse_beta_cdf

​inverse_normal_cdf

​is_finite

​is_infinite

​is_nan

​ln

​log

​log10

​log2

​mod

​nan

​normal_cdf

​pi

​pow

​power

​radians

​rand

​random

​round

​sign

​sin

​sinh

​sqrt

​tan

​tanh

​to_base

​truncate

​width_bucket

​wilson_interval_lower

​wilson_interval_upper

`abs`

`acos`

`asin`

`atan`

`atan2`

`beta_cdf`

`cbrt`

`ceil`

`ceiling`

`cos`

`cosh`

`cosine_similarity`

`degrees`

`e`

`exp`

`floor`

`from_base`

`infinity`

`inverse_beta_cdf`

`inverse_normal_cdf`

`is_finite`

`is_infinite`

`is_nan`

`ln`

`log`

`log10`

`log2`

`mod`

`nan`

`normal_cdf`

`pi`

`pow`

`power`

`radians`

`rand`

`random`

`round`

`sign`

`sin`

`sinh`

`sqrt`

`tan`

`tanh`

`to_base`

`truncate`

`width_bucket`

`wilson_interval_lower`

`wilson_interval_upper`