minMap - ClickHouse Documentation

minMappedArrays

Introduced in: v20.5.0

Calculates the minimum from value array according to the keys specified in the key array.

Passing a tuple of keys and value arrays is identical to passing an array of keys and an array of values.
The number of elements in key and value must be the same for each row that is totaled.

Syntax

minMappedArrays(key, value)
minMappedArrays(Tuple(key, value))

Arguments

key — Array of keys. Array(T)

value — Array of values. Array(T)

Returned value

Returns a tuple of two arrays: keys in sorted order, and values calculated for the corresponding keys. Tuple(Array(T), Array(T))

Examples

Usage example

Query

SELECT minMappedArrays(a, b)
FROM VALUES('a Array(Int32), b Array(Int64)', ([1, 2], [2, 2]), ([2, 3], [1, 1]));

Response

┌─minMappedArrays(a, b)───────────┐
│ ([1, 2, 3], [2, 1, 1])          │
└─────────────────────────────────┘

​minMappedArrays