Array sort

Supported in: Batch, Streaming

Returns a sorted array of the given input array. All null values are placed at the end of a descending array and at the front of an ascending array.

Expression categories: Array

Declared arguments

• Direction - Choose sorting direction.
  Enum<Ascending, Descending>
• Expression - Array to be sorted.
  Expression<Array<T>>

Type variable bounds: T accepts ComparableType

Output type: Array<T>

Examples

Example 1: Base case

Argument values:

• Direction: ASCENDING
• Expression: [ 5, 3, 6 ]

Output: [ 3, 5, 6 ]

---

Example 2: Base case

Argument values:

• Direction: DESCENDING
• Expression: [ 5, 3, 6 ]

Output: [ 6, 5, 3 ]

---

Example 3: Base case

Argument values:

• Direction: ASCENDING
• Expression: [ 3, null, 1, 2 ]

Output: [ null, 1, 2, 3 ]

---

Example 4: Base case

Argument values:

• Direction: DESCENDING
• Expression: [ 3, null, 1, 2 ]

Output: [ 3, 2, 1, null ]

---

Example 5: Null case

Argument values:

• Direction: ASCENDING
• Expression: array

---