Array contains null

Supported in: Batch, Streaming

Returns true if the array contains null.

Expression categories: Array, Boolean

Declared arguments

  • Expression - An array that could contain null values.
    Expression<Array<ComparableType>>

Output type: Boolean

Examples

Example 1: Base case

Argument values:

  • Expression: part_ids
part_idsOutput
[ AWE-112, BRR-123, null ]true
[ AWE-222, ABC-543 ]false

Example 2: Null case

Argument values:

  • Expression: part_ids
part_idsOutput
nullfalse
[ AWE-222, ABC-543 ]false

Example 3: Edge case

Argument values:

  • Expression: part_ids
part_idsOutput
[ ]false