Data connectivity & integrationPipeline Builder ExpressionsEquals

Equals

Supported in: Batch, Faster, Streaming

Returns true if left and right are equal.

Expression categories: Boolean

Declared arguments

  • Left: Left expression.
    Expression<ComparableType>
  • Right: Right expression.
    Expression<ComparableType>
  • optional Null safe: Treats nulls as false.
    Literal<Boolean>

Output type: Boolean

Examples

Example 1: Base case

Argument values:

  • Left: a
  • Right: b
  • Null safe: true
abOutput
11true
10false

Example 2: Base case

Argument values:

  • Left: a
  • Right: b
  • Null safe: true
abOutput
1.01true
1.00false

Example 3: Base case

Argument values:

  • Left: departure
  • Right: destination
  • Null safe: true
departuredestinationOutput
HeathrowHeathrowtrue
HeathrowGatwickfalse

Example 4: Null case

Argument values:

  • Left: departure
  • Right: destination
  • Null safe: true
departuredestinationOutput
nullnulltrue
nullHeathrowfalse

Example 5: Null case

Argument values:

  • Left: departure
  • Right: destination
  • Null safe: false
departuredestinationOutput
nullnullnull
nullHeathrownull

Example 6: Null case

Argument values:

  • Left: departure
  • Right: destination
  • Null safe: null
departuredestinationOutput
nullnulltrue
nullHeathrowfalse