All Products
Search
Document Center

Realtime Compute for Apache Flink:MURMUR_HASH

Last Updated:Feb 05, 2024

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