Clickhouse: Array arithmetic functions like arrayPlus, arraySub, arrayMulti ?

[ramazanpolat]

Are there array arithmetic functions for arrays, like subtract each element of an array from another array elements?

:) SELECT arraySub([5,6,7], [1,2,3]) as sub
result:
sub
[4,4,4]

[ludv1x]

Hi!
You could use lambdas:

SELECT arrayMap((a, b) -> (a - b), [5, 6, 7], [1, 2, 3])

┌─arrayMap(lambda(tuple(a, b), minus(a, b)), [5, 6, 7], [1, 2, 3])─┐
│ [4,4,4]                                                          │
└──────────────────────────────────────────────────────────────────┘

1 rows in set. Elapsed: 0.001 sec. 

[ludv1x]

More details about higher-order functions: https://clickhouse.yandex/docs/en/single/#higher-order-functions