Apache Hive : HPL/SQL - NVL2 Function

Last updated: August 12, 2026

Table of Contents

Apache Hive : HPL/SQL - NVL2 Function

If the first expression is NOT NULL, NVL2 function returns the result of the second expression, otherwise it returns the result of the third expression.

Syntax:

NVL2(expr1, expr2, expr3);

Parameters:

ParameterTypeValue
exprNAnyVariable or expression

Notes:

  • If expr1 is not NULL, expr2 is only evaluated; and if expr1 is NULL, expr3 is only evaluated

Return Type:

The data type of the returned expression by expr2 or expr3 depending whether expr1 is NULL or not.

Example 1:

NVL2(NULL, 1, 2);

Result: 2

Compatibility: Oracle and IBM DB2.