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 |
+------------------------------------------+