Clickhouse: [question] How to do arrayToBitmask ?

Created on 28 Sep 2018  路  2Comments  路  Source: ClickHouse/ClickHouse

https://clickhouse.yandex/docs/en/query_language/functions/encoding_functions/
bitmaskToArray() is pretty useful.
Is it possible to encode an array<UInt64> to bitmask?

question
Source
picture jimmykuo

Most helpful comment

With higher-order functions.
Try that 

select
   number,
   bitmaskToArray(number) as bitmask,
   arrayReduce('groupBitOr', bitmask) as reverse
from numbers(100);
picture filimonov on 28 Sep 2018
👍2

All 2 comments

With higher-order functions.
Try that 

select
   number,
   bitmaskToArray(number) as bitmask,
   arrayReduce('groupBitOr', bitmask) as reverse
from numbers(100);
filimonov picture filimonov on 28 Sep 2018
👍2

@filimonov
thank you! help me a lot

jimmykuo picture jimmykuo on 28 Sep 2018
Was this page helpful?
0 / 5 - 0 ratings

Related issues

fizerkhan picture fizerkhan  路  3Comments
vixa2012 picture vixa2012  路  3Comments
SaltTan picture SaltTan  路  3Comments
healiseu picture healiseu  路  3Comments
innerr picture innerr  路  3Comments