哈希函数
更新时间:2022-09-13
PALO支持的哈希函数如下:
MURMUR_HASH3_32
Description
SQL
1INT MURMUR_HASH3_32(VARCHAR input, ...)
- 功能:返回输入字符串的32位murmur3 hash值
- 返回类型:string类型
Example
SQL
1mysql> select murmur_hash3_32(null);
2+-----------------------+
3| murmur_hash3_32(NULL) |
4+-----------------------+
5| NULL |
6+-----------------------+
7
8mysql> select murmur_hash3_32("hello");
9+--------------------------+
10| murmur_hash3_32('hello') |
11+--------------------------+
12| 1321743225 |
13+--------------------------+
14
15mysql> select murmur_hash3_32("hello", "world");
16+-----------------------------------+
17| murmur_hash3_32('hello', 'world') |
18+-----------------------------------+
19| 984713481 |
20+-----------------------------------+
Keywords
Plain Text
1MURMUR_HASH3_32,HASH