VeloDB Cloud
SQL Manual
Functions
bitmap-functions
bitmap_hash

bitmap_hash

Description

Syntax:

BITMAP BITMAP_HASH(expr)

This function computes the 32-bit hash value for a expr of any type and returns a bitmap containing that hash value. It is mainly used to load non-integer value into bitmap columns in stream load tasks.

cat data | curl --location-trusted -u user:passwd -T - -H "columns: dt,page,device_id, device_id=bitmap_hash(device_id)"   http://host:8410/api/test/testDb/_stream_load

Example

mysql> select bitmap_count(bitmap_hash('hello'));
+------------------------------------+
| bitmap_count(bitmap_hash('hello')) |
+------------------------------------+
|                                  1 |
+------------------------------------+

Keywords

BITMAP_HASH,BITMAP