Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Updated Jul 26, 2024
Send us feedback
is null
Applies to: Databricks SQL Databricks Runtime
Tests whether expr is NULL.
expr
NULL
expr is [not] null
expr: An expression of any type.
A BOOLEAN.
If not is specified this operator is a synonym for isnotnull(expr). Otherwise the operator is a synonym for isnull(expr).
not
isnotnull(expr)
isnull(expr)
> SELECT 1 is null; false > SELECT 1 is not null; true
isnotnull function
isnull function
isnan function
is false operator
is true operator