Data connectivity & integrationPipeline Builder ExpressionsNot any

Not any

Supported in: Batch, Streaming

Returns true only if none of the conditions hold. Treats nulls as false with ANSI mode off, propagates nulls otherwise.

Expression categories: Boolean

Declared arguments

  • Conditions: List of conditions from which the output is calculated.
    List<Expression<Boolean>>

Output type: Boolean

Examples

Example 1: Base case

Argument values:

  • Conditions: [left_boolean, right_boolean]
left_booleanright_booleanOutput
truetruefalse
truefalsefalse
falsetruefalse
falsefalsetrue

Example 2: Null case (ANSI mode on)

Argument values:

  • Conditions: [left_boolean, right_boolean]
left_booleanright_booleanOutput
nulltruefalse
truenullfalse
nullfalsenull
falsenullnull
nullnullnull

Example 3: Null case (ANSI mode off)

Argument values:

  • Conditions: [left_boolean, right_boolean]
left_booleanright_booleanOutput
nulltruefalse
truenullfalse
nullfalsetrue
falsenulltrue
nullnulltrue