nanvl function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns expr1 if it’s not NaN, or expr2 otherwise.

Syntax 

nanvl(expr1, expr2)

Arguments

  • expr1: An expression that evaluates to a numeric.

  • expr2: An expression that evaluates to a numeric.

Returns

A DOUBLE.

Examples 

> SELECT nanvl(cast('NaN' AS DOUBLE), 123);
 123.0