bitmap_hash64

description

Syntax

BITMAP BITMAP_HASH64(expr)

对任意类型的输入计算64位的哈希值,返回包含该哈希值的bitmap。主要用于stream load任务将非整型字段导入Doris表的bitmap字段。例如

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

example

  1. mysql> select bitmap_count(bitmap_hash64('hello'));
  2. +------------------------------------+
  3. | bitmap_count(bitmap_hash64('hello')) |
  4. +------------------------------------+
  5. | 1 |
  6. +------------------------------------+

keywords

  1. BITMAP_HASH,BITMAP