Data connectivity & integrationPipeline Builder ExpressionsAdd numbers

Add numbers

Supported in: Batch, Streaming

Calculates the sum of all input columns. Returns null on overflow.

Expression categories: Numeric

Declared arguments

  • Expressions: List of columns to be added.
    List<Expression<Numeric>>

Output type: Numeric

Examples

Example 1: Base case

Argument values:

  • Expressions: [col_a, col_b]
col_acol_bOutput
123

Example 2: Null case

Argument values:

  • Expressions: [col_a, col_b]
col_acol_bOutput
nullnullnull

Example 3: Null case

Argument values:

  • Expressions: [col_a, col_b]
col_acol_bOutput
1nullnull

Example 4: Null case

Argument values:

  • Expressions: [col_a, col_b]
col_acol_bOutput
null1null