Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Updated Dec 05, 2024
Send us feedback
isnan
Applies to: Databricks SQL Databricks Runtime
Returns true if expr is NaN.
true
expr
NaN
isnan(expr)
expr: An expression that evaluates to a numeric.
A BOOLEAN.
> SELECT isnan(cast('NaN' as double)); true > SELECT isnan(7); false
isnotnull function
isnull function