实时计算Flink版：MURMUR_HASH_64

语法

BIGINT MURMUR_HASH_64(value)

入参

示例

• 测试表T1数据

  id(INT)	hash_64_value1(VARCHAR)	hash_64_value2(FLOAT)
  1	This is a test String.	4.5
  2	null	null
  3	test	4

• 测试语句

  SELECT id, MURMUR_HASH_64(hash_64_value1) as big1, MURMUR_HASH_64(hash_64_value2) as big2
  FROM T1;         

• 测试结果

  id(INT)	big1(BIGINT)	big2(BIGINT)
  1	2706826604463635000	8033179276572535000
  2	-	-
  3	5010266691562018000	-6697622088025985000

相关文档

按Murmur 32哈希算法计算指定参数的32位哈希值函数，详情请参见MURMUR_HASH。