to_bitmap

description

Syntax

BITMAP TO_BITMAP(expr)

Convert an unsigned bigint (ranging from 0 to 18446744073709551615) to a bitmap containing that value. Null will be return when the input value is not in this range. Mainly be used to load integer value into bitmap column, e.g.,

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

example

  1. mysql> select bitmap_count(to_bitmap(10));
  2. +-----------------------------+
  3. | bitmap_count(to_bitmap(10)) |
  4. +-----------------------------+
  5. |                           1 |
  6. +-----------------------------+
  8. MySQL> select bitmap_to_string(to_bitmap(-1));
  9. +---------------------------------+
  10. | bitmap_to_string(to_bitmap(-1)) |
  11. +---------------------------------+
  12. | NULL                            |
  13. +---------------------------------+

keyword

  1. TO_BITMAP,BITMAP