Generate a Murmur Hash

Jim_KnicelyJim_Knicely - Select Field - Administrator
edited February 2019 in Tips from the Team

Murmur (Murmerhash) is a modern non-cryptographic hash function having a low collision rate and high performance. It is suitable for general hash-based lookups but not suitable for cryptographic use cases.

Vertica has a built-in function called murmurhash.


dbadmin=> SELECT murmurhash('VERTICA MURMUR Hash!');
(1 row)

dbadmin=> SELECT murmurhash('The quick brown fox jumps over the lazy dog'),
dbadmin->        hash('The quick brown fox jumps over the lazy dog');
     murmurhash      |        hash
 6788720976440246833 | 4647120267691732726
(1 row)

Helpful Link:

Have fun!

Sign In or Register to comment.