On this page

    Categories: Boolean

    IS [NOT] NULL

    Determines if an expression is NULL or not NULL. Alias for the function ISNULL/ISNOTNULL.

    Syntax

    IS [NOT] NULL(expression any) → boolean

    • expression: Expression of any Dremio supported data type to evaluate.

    Examples

    ISNULL function returns true if is NULL, and false otherwise.

    select ISNULL('dremio')
    -- False
    

    ISNULL operator returns true if is NULL, and false otherwise.

    select 'dremio' IS NULL
    -- False
    

    IS [NOT] NULL(expression any) → boolean

    • expression: Expression of any Dremio supported data type to evaluate.

    Examples

    ISNOTNULL function returns true if is not NULL, and false otherwise.

    select ISNOTNULL('dremio')
    -- True
    

    ISNOTNULL operator returns true if is not NULL, and false otherwise.

    select 'dremio' IS NOT NULL
    -- False