The topic describes how to use the MURMUR_HASH_64 function. This function specifies the 64-bit hash value for a parameter by using the hash128x64 method.
Limits
This function 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)
Input parameters
Parameter | Data type |
---|---|
value | VARCHAR or a numeric value |
Example 1
- Test data
Table 1. T1 value This is a test String. NULL test - Test statement
SELECT MURMUR_HASH_64(value) as big FROM T1;
- Test result
big(VARCHAR) 2706826604463634835 NULL 5010266691562018262
Example 2
- Test data
Table 2. T2 value 4.5 NULL 4 - Test statement
SELECT MURMUR_HASH_64(CAST(value AS FLOAT)) as big FROM T2;
- Test result
big(VARCHAR) 8033179276572534397 NULL -6697622088025985219