Clickhouse: Is there accumulate for array?

Created on 2 Jun 2019 · 2Comments · Source: ClickHouse/ClickHouse

data : [1, 4, 6, 8]

result : 1 * 4 * 6 * 8 = 192

question

Source

lzy305

Most helpful comment


SELECT exp2(arraySum(x -> log2(x), [1, 4, 6, 8]))

┌─exp2(arraySum(lambda(tuple(x), log2(x)), [1, 4, 6, 8]))─┐
│                                                     192 │
└─────────────────────────────────────────────────────────┘

den-crane on 4 Jun 2019

👍2

All 2 comments


SELECT exp2(arraySum(x -> log2(x), [1, 4, 6, 8]))

┌─exp2(arraySum(lambda(tuple(x), log2(x)), [1, 4, 6, 8]))─┐
│                                                     192 │
└─────────────────────────────────────────────────────────┘

den-crane on 4 Jun 2019

👍2

Good idea, Thanks

lzy305 on 5 Jun 2019

Was this page helpful?

0 / 5 - 0 ratings