Mathematical functions

Preview Spark mathematical functions in SparkSQL and Databricks compatibility modes. Both modes share these functions. Support is one of: Supported, With limitations, or Not supported. Supported means every example in the Spark reference returns what Spark returns; a note under With limitations quotes a call that differs.

Function	Support	Notes
`ASINH`	Supported
`ATAN`	Supported
`ATAN2`	Supported
`CBRT`	Supported
`COS`	Supported
`COSH`	Supported
`COT`	Supported
`CSC`	Supported
`DEGREES`	Supported
`E`	Supported
`EXP`	Supported
`GREATEST`	Supported
`HEX`	Supported
`LEAST`	Supported
`LN`	Supported
`LOG`	Supported
`LOG10`	Supported
`LOG2`	Supported
`NEGATIVE`	Supported
`PI`	Supported
`PMOD`	Supported
`POSITIVE`	Supported
`POW`	Supported
`POWER`	Supported
`RADIANS`	Supported
`SEC`	Supported
`SIN`	Supported
`SINH`	Supported
`SQRT`	Supported
`TAN`	Supported
`TANH`	Supported
`UNHEX`	Supported
`ABS`	With limitations	`abs(INTERVAL -'1-1' YEAR TO MONTH)` is not supported.
`ACOS`	With limitations	`acos(2)` raises an error, where Spark returns `NaN`.
`ACOSH`	With limitations	`acosh(0)` raises an error, where Spark returns `NaN`.
`ASIN`	With limitations	`asin(2)` raises an error, where Spark returns `NaN`.
`ATANH`	With limitations	`atanh(2)` raises an error, where Spark returns `NaN`.
`BIN`	With limitations	A negative number renders as 32 bits, where Spark renders 64. A non-integer argument is not supported.
`CEIL`	With limitations	Returns `DOUBLE`, where Spark returns `NUMERIC(1, 0)`.
`CEILING`	With limitations	Returns `DOUBLE`, where Spark returns `NUMERIC(1, 0)`.
`DIV`	With limitations	`INTERVAL '1-1' YEAR TO MONTH div INTERVAL '-1' MONTH` is not supported.
`FLOOR`	With limitations	Returns `DOUBLE`, where Spark returns `NUMERIC(1, 0)`.
`MOD`	With limitations	Integer arguments only: `mod(5.5, 2)` and `2 % 1.8` raise an error.
`RAND`	With limitations	A seed, as in `rand(0)`, is not supported.
`RANDOM`	With limitations	A seed, as in `random(0)`, is not supported.
`ROUND`	With limitations	`round(2.5, 0)` returns `2`, where Spark returns `3`.
`SIGN`	With limitations	Returns `INTEGER`, where Spark returns `DOUBLE`.
`SIGNUM`	With limitations	Returns `INTEGER`, where Spark returns `DOUBLE`.
`BROUND`, `CONV`, `EXPM1`, `FACTORIAL`, `HYPOT`, `LOG1P`, `RANDN`, `RINT`, `TRY_ADD`, `TRY_DIVIDE`, `TRY_MOD`, `TRY_MULTIPLY`, `TRY_SUBTRACT`, `UNIFORM`, `WIDTH_BUCKET`	Not supported

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal