minMappedArrays
Calculates the minimum from value array according to the keys specified in the key array.
This page describes the RawTree engine binary used to generate this reference. It does not define Query API support. Descriptions retain upstream ClickHouse terminology. See SQL interface scope.
Calculates the minimum from value array according to the keys specified in the key array.
:::note
- 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
keyandvaluemust be the same for each row that is totaled. :::
Syntax
minMappedArrays(key, value)
minMappedArrays(Tuple(key, value))Arguments
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
SELECT minMappedArrays(a, b)
FROM VALUES('a Array(Int32), b Array(Int64)', ([1, 2], [2, 2]), ([2, 3], [1, 1]));┌─minMappedArrays(a, b)───────────┐
│ ([1, 2, 3], [2, 1, 1]) │
└─────────────────────────────────┘Introduced in version 20.5.0.