zeroifnull
function
Applies to: Databricks Runtime 16.0 and later
Returns 0
if expr
is NULL
, or expr
otherwise. This function is a synonym for `coalesce(expr, 0)`.
CLUSTER BY
clause (TABLE)mask
clauseROW FILTER
clauseUpdated Dec 04, 2024
zeroifnull
function Applies to: Databricks Runtime 16.0 and later
Returns 0
if expr
is NULL
, or expr
otherwise. This function is a synonym for `coalesce(expr, 0)`.