Specifies the 32-bit hash value for a parameter by using the hash32x86 method.
Limits
This function is supported only in Realtime Compute for Apache Flink that uses Ververica Runtime (VVR) 3.0.0 or later.
Syntax
INT MURMUR_HASH(value)Input parameters
Parameter | Data type |
value | VARCHAR or a numeric value |
Examples
Example 1
Test data
Table 1 T1 id(INT)
hash_value(VARCHAR)
1
This is a test String.
2
NULL
3
test
Test statement
SELECT id,MURMUR_HASH(hash_value) as intt FROM T1;Test result
id(INT)
intt(INT)
1
740959099
2
NULL
3
271330425
Example 2
Test data
Table 2. T2 id(INT)
hash_value(Float)
1
4.5
2
NULL
3
4
Test statement
SELECT id,MURMUR_HASH(hash_value) as intt FROM T2;Test result
id(INT)
intt(INT)
1
-2130121231
2
NULL
3
1863595885