unhexAsBitmap about clickhouse HOT 2 CLOSED

Hm, why do you need select bitmap ? Is it a part of an insert select?

JDBC supports bitmaps https://github.com/search?q=repo%3AClickHouse%2Fclickhouse-java%20ClickHouseBitmap&type=code

You can use input function or external data (jdbc supports external data) https://clickhouse.com/docs/en/engines/table-engines/special/external-data

And such function already exists unhex

select hex(bitmapBuild([1,2,3]));
┌─hex(bitmapBuild([1, 2, 3]))─┐
│ 0003010203                  │
└─────────────────────────────┘

select bitmapToArray(cast(unhex('0003010203'), 'AggregateFunction(groupBitmap, UInt8)'));
┌─bitmapToArray(CAST(unhex('0003010203'), 'AggregateFunction(groupBitmap, UInt8)'))─┐
│ [1,2,3]                                                                           │
└───────────────────────────────────────────────────────────────────────────────────┘

from clickhouse.

I require the 'select bitmap' functionality because the bitmap value is evaluated by my Java program. Subsequently, I utilize it to filter data from the 'clickhouse' table, rather than using an insert select scenario.
In conclusion,thank you for providing solution,it is very useful.

from clickhouse.