Conditional and predicate functions - Firebolt Documentation

Preview Spark conditional and predicate 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.

Conditional functions

Function	Support	Notes
`BETWEEN`	Supported
`COALESCE`	Supported
`IF`	Supported
`IFNULL`	Supported
`NULLIF`	Supported
`NULLIFZERO`	Supported
`NVL`	Supported
`NVL2`	Supported
`WHEN`	With limitations	Returns `DOUBLE`, where Spark returns `NUMERIC(11, 1)`.
`ZEROIFNULL`	With limitations	Returns `DOUBLE`, where Spark returns `INTEGER`.
`NANVL`	Not supported

Predicate functions

Function	Support	Notes
`AND`	Supported
`EQUAL_NULL`	Supported
`ISNOTNULL`	Supported
`ISNULL`	Supported
`NOT`	Supported
`OR`	Supported
`REGEXP`	Supported
`REGEXP_LIKE`	Supported
`RLIKE`	Supported
`ILIKE`	With limitations	`'%SystemDrive%/Users/John' ilike '/%SYSTEMDrive/%//Users%' ESCAPE '/'` is not supported.
`IN`	With limitations	Not supported for `STRUCT` values.
`LIKE`	With limitations	`'%SystemDrive%/Users/John' like '/%SystemDrive/%//Users%' ESCAPE '/'` is not supported.
`ISNAN`	Not supported