Clickhouse: Change bitmapBuild result type from default UInt8

Created on 6 Nov 2019  路  3Comments  路  Source: ClickHouse/ClickHouse

Hi there! Can i somehow change result type of bitmapBuild([1,2,3,4]) not to AggregateFunction(groupBitmap, UInt8) which i assume selects type by selecting max integer in set, but to AggregateFunction(groupBitmap, UInt32) without using hacks like bitmapBuild([1,2,3,4, 4294967295])

question
Source
picture mrAndersen

Most helpful comment

@mrAndersen You can cast array to UInt32 explicitly, for example bitmapBuild(cast([1,2,3,4] as Array(UInt32))).

picture yuzhichang on 6 Nov 2019
👍2

All 3 comments

CC @yuzhichang

alexey-milovidov picture alexey-milovidov on 6 Nov 2019

@mrAndersen You can cast array to UInt32 explicitly, for example bitmapBuild(cast([1,2,3,4] as Array(UInt32))).

yuzhichang picture yuzhichang on 6 Nov 2019
👍2

Thanks!

mrAndersen picture mrAndersen on 6 Nov 2019
Was this page helpful?
0 / 5 - 0 ratings

Related issues

SaltTan picture SaltTan  路  3Comments
amonakhov picture amonakhov  路  3Comments
jimmykuo picture jimmykuo  路  3Comments
opavader picture opavader  路  3Comments
zhicwu picture zhicwu  路  3Comments