ISNOTNULL (Lakehouse v2)

Checks whether a value is not NULL. Returns 1 if not NULL, 0 otherwise.

Analyze Syntax

func.isnotnull(<expr>)

Analyze Examples

func.isnotnull(1)

┌───┐
│ 1  │
└───┘

SQL Syntax

ISNOTNULL(<expr>)

SQL Examples

SELECT ISNOTNULL(1);

┌───┐
│ 1  │
└───┘