Skip to main content
Version: 0.0.1

IS__NOT__DISTINCT_FROM

Categories: Boolean, Datatype

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

{{< codeheader "IS [NOT] DISTINCT FROM example" >}}

SELECT NULL IS DISTINCT
FROM NULL

-- False

{{< codeheader "IS [NOT] DISTINCT FROM example" >}}

SELECT NULL IS NOT DISTINCT
FROM NULL

-- True