MURMUR_HASH
Computes a 32-bit hash value for the input using the MurmurHash hash32x86 method.
Limits
MURMUR_HASH is supported only in Realtime Compute for Apache Flink that uses Ververica Runtime (VVR) 3.0.0 or later.
Syntax
INT MURMUR_HASH(value)Parameters
|
Parameter |
Data type |
|
|
VARCHAR or a numeric value |
Returns
An INT (32-bit hash value).
Usage notes
-
If
valueis NULL, the function returns NULL.
Examples
Example 1: VARCHAR input
Test data (table T1)
|
id (INT) |
hash_value (VARCHAR) |
|
1 |
This is a test String. |
|
2 |
NULL |
|
3 |
test |
Statement
SELECT id, MURMUR_HASH(hash_value) AS intt
FROM T1;Result
|
id (INT) |
intt (INT) |
|
1 |
740959099 |
|
2 |
NULL |
|
3 |
271330425 |
Example 2: Float input
Test data (table T2)
|
id (INT) |
hash_value (Float) |
|
1 |
4.5 |
|
2 |
NULL |
|
3 |
4 |
Statement
SELECT id, MURMUR_HASH(hash_value) AS intt
FROM T2;Result
|
id (INT) |
intt (INT) |
|
1 |
-2130121231 |
|
2 |
NULL |
|
3 |
1863595885 |