Array maximum

Supported in: Batch, Streaming

Returns the maximum value of an array column.

Expression categories: Array

Declared arguments

  • Expression - Array from which to return the maximum element.
    Expression<Array<T>>

Type variable bounds: T accepts ComparableType

Output type: T

Examples

Example 1: Base case

Argument values:

  • Expression: [ 1, 2, 3 ]

Output: 3


Example 2: Base case

Argument values:

  • Expression: [ 10, 77, 140 ]

Output: 140


Example 3: Base case

Argument values:

  • Expression: [ false, true ]

Output: true


Example 4: Base case

Argument values:

  • Expression: [ 2024-11-25, 2024-07-23, 2024-05-10 ]

Output: 2024-11-25


Example 5: Base case

Argument values:

  • Expression: array
arrayOutput
[ foo, bar, baz, qux ]qux

Example 6: Null case

Argument values:

  • Expression: array
arrayOutput
[ {
field1: foo,
field2: bar,
}, {
field1: baz,
field2: qux,
}, {
field1: foo,
field2: baz,
} ]
{
field1: foo,
field2: baz,
}

Example 7: Null case

Argument values:

  • Expression: array
arrayOutput
[ 2025-01-03T00:00:00Z, 2025-04-01T00:00:00Z ]2025-04-01T00:00:00Z

Example 8: Null case

Argument values:

  • Expression: array
arrayOutput
nullnull
[ 1, null ]1