Skip to main content

BITMAP_HASH64

Description​

Computes the 64-bit hash value of any input type and returns a Bitmap containing that hash value.

Syntax​

BITMAP_HASH64(<expr>)

Parameters​

ParameterDescription
<expr>Any value or field expression

Return Value​

Returns a Bitmap containing the 64-bit hash value of the parameter <expr>.

Examples​

To compute the 64-bit hash of a value, you can use:

select bitmap_to_string(bitmap_hash64('hello'));

The result will be:

+------------------------------------------+
| bitmap_to_string(bitmap_hash64('hello')) |
+------------------------------------------+
| 15231136565543391023 |
+------------------------------------------+