murmur_hash3_64

description

Syntax

BIGINT MURMUR_HASH3_64(VARCHAR input, ...)

Return the 64 bits murmur3 hash of input string.

Note: When calculating hash values, it is more recommended to use xxhash_64 instead of 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