SelectDB Cloud
SQL 手册
函数
hash-functions
murmur_hash3_64

murmur_hash3_64

description

Syntax

BIGINT MURMUR_HASH3_64(VARCHAR input, ...)

返回输入字符串的64位murmur3 hash值

example

mysql> select murmur_hash3_64(null);
+-----------------------+
| murmur_hash3_64(NULL) |
+-----------------------+
|                  NULL |
+-----------------------+

mysql> select murmur_hash3_64("hello");
+--------------------------+
| murmur_hash3_64('hello') |
+--------------------------+
|     -3215607508166160593 |
+--------------------------+

mysql> select murmur_hash3_64("hello", "world");
+-----------------------------------+
| murmur_hash3_64('hello', 'world') |
+-----------------------------------+
|               3583109472027628045 |
+-----------------------------------+

keywords

MURMUR_HASH3_64,HASH
© 2023 北京飞轮数据科技有限公司 京ICP备2022004029号 | Apache、Apache Doris 以及相关开源项目名称均为 Apache 基金会商标