murmur_hash3_64

description

Syntax

BIGINT MURMUR_HASH3_64(VARCHAR input, ...)

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

注：在计算hash值时，更推荐使用xxhash_64，而不是murmur_hash3_64。

example

1. mysql> select murmur_hash3_64(null);
2. +-----------------------+
3. | murmur_hash3_64(NULL) |
4. +-----------------------+
5. |                  NULL |
6. +-----------------------+

8. mysql> select murmur_hash3_64("hello");
9. +--------------------------+
10. | murmur_hash3_64('hello') |
11. +--------------------------+
12. |     -3215607508166160593 |
13. +--------------------------+

15. mysql> select murmur_hash3_64("hello", "world");
16. +-----------------------------------+
17. | murmur_hash3_64('hello', 'world') |
18. +-----------------------------------+
19. |               3583109472027628045 |
20. +-----------------------------------+

keywords

1. MURMUR_HASH3_64,HASH