Mode

Supported in: Batch

Calculate mode of values in column.

Expression categories: Aggregate

Declared arguments

• Expression - The column of on which mode is computed.
  Expression<Any>

Type variable bounds: Any accepts Binary | Boolean | Byte | Date | Decimal | Double | Float | Integer | Long | Short | String | Timestamp

Output type: Any

Examples

Example 1: Base case

Argument values:

• Expression: values

Given input table:

Outputs: b

---

Example 2: Base case

Argument values:

• Expression: values

Given input table:

Outputs: 2

---

Example 3: Null case

Argument values:

• Expression: values

Given input table:

Outputs: null

---

Example 4: Null case

Argument values:

• Expression: values

Given input table:

Outputs: c

---