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β
Parameter | Description |
---|---|
<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 |
+------------------------------------------+