minMap
Syntax: minMap(key, value)
or minMap(Tuple(key, value))
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 two arrays of keys and values.
The number of elements in key
and value
must be the same for each row that is totaled.
Returns a tuple of two arrays: keys in sorted order, and values calculated for the corresponding keys.
Example:
SELECT minMap(a, b)
FROM values('a Array(Int32), b Array(Int64)', ([1, 2], [2, 2]), ([2, 3], [1, 1]))
┌─minMap(a, b)──────┐
│ ([1,2,3],[2,1,1]) │
└───────────────────┘
当前内容版权归 ClickHouse 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ClickHouse .