On this page

    Categories: Boolean

    IS [NOT] DISTINCT FROM

    Compares two expressions to determine whether they have the same or different values. NULLs are considered as comparable values.

    Syntax

    IS [NOT] DISTINCT FROM(expression any) → boolean

    • expression: Can be a general expression of any Dremio-supported data type.

    Examples

    SELECT NULL IS DISTINCT
    FROM NULL
    
    -- False
    
    SELECT NULL IS NOT DISTINCT
    FROM NULL
    
    -- True