Returns the 64-bit hash value of an input using the hash128x64 method.
Limitations
MURMUR_HASH_64 is supported only in Realtime Compute for Apache Flink that uses Ververica Runtime (VVR) 3.0.0 or later.
Syntax
BIGINT MURMUR_HASH_64(value)Returns: BIGINT. Returns NULL if value is NULL.
Parameters
| Parameter | Data type |
|---|---|
value | VARCHAR or a numeric value |
Examples
Example 1: VARCHAR input
Test data (T1)
| id (INT) | hash_64_value (VARCHAR) |
|---|---|
| 1 | This is a test String. |
| 2 | null |
| 3 | test |
Test statement
SELECT id, MURMUR_HASH_64(hash_64_value) AS big
FROM T1;Result
| id (INT) | big (BIGINT) |
|---|---|
| 1 | 2706826604463635000 |
| 2 | - |
| 3 | 5010266691562018000 |
Example 2: FLOAT input
Test data (T2)
| id (INT) | hash_64_value (FLOAT) |
|---|---|
| 1 | 4.5 |
| 2 | NULL |
| 3 | 4 |
Test statement
SELECT MURMUR_HASH_64(hash_64_value) AS big
FROM T2;Result
| id (INT) | big (BIGINT) |
|---|---|
| 1 | 8033179276572535000 |
| 2 | - |
| 3 | -6697622088025985000 |
Related functions
MURMUR_HASH: Returns a 32-bit hash value using the hash32x86 method.