This is an automated email from the ASF dual-hosted git repository.
zclll pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new c9ab033d8f4 [Enhancement](mmhash) Support mmhash3_u64_v2 (#3499)
c9ab033d8f4 is described below
commit c9ab033d8f45f7d32a4b95bc31b8b02cfa06f63b
Author: linrrarity <[email protected]>
AuthorDate: Mon Mar 30 11:33:29 2026 +0800
[Enhancement](mmhash) Support mmhash3_u64_v2 (#3499)
## Versions
- [x] dev
- [x] 4.x
- [ ] 3.x
- [ ] 2.1
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../encrypt-digest-functions/murmur-hash3-64-v2.md | 25 +++++++-
.../murmur-hash3-u64-v2.md | 67 ++++++++++++++++++++
.../encrypt-digest-functions/murmur-hash3-64-v2.md | 25 +++++++-
.../murmur-hash3-u64-v2.md | 72 ++++++++++++++++++++++
.../encrypt-digest-functions/murmur-hash3-64-v2.md | 29 ++++++++-
.../murmur-hash3-u64-v2.md | 72 ++++++++++++++++++++++
sidebars.ts | 1 +
.../encrypt-digest-functions/murmur-hash3-64-v2.md | 29 ++++++++-
.../murmur-hash3-u64-v2.md | 71 +++++++++++++++++++++
versioned_sidebars/version-4.x-sidebars.json | 1 +
10 files changed, 384 insertions(+), 8 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
index a0f76f89dd3..1a09d16581a 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
@@ -2,13 +2,13 @@
{
"title": "MURMUR_HASH3_64_V2",
"language": "en",
- "description": "Computes a 64-bit MurmurHash3 hash value."
+ "description": "Computes a signed 64-bit MurmurHash3 hash value."
}
---
## Description
-Computes a 64-bit MurmurHash3 hash value.
+Computes a singed 64-bit MurmurHash3 hash value. The unsigned version refer to
[murmur_hash3_u64_v2](./murmur-hash3-u64-v2.md)
The difference from `MURMUR_HASH3_64` is: this version reuses the 128-bit
processing function of MurmurHash3, outputting only the first 64-bit hash
value, which is consistent with the [standard
library](https://mmh3.readthedocs.io/en/latest/api.html#mmh3.hash64)
implementation.
@@ -44,4 +44,25 @@ select murmur_hash3_64_v2(null),
murmur_hash3_64_v2("hello"), murmur_hash3_64_v2
+--------------------------+-----------------------------+--------------------------------------+
| NULL | -3758069500696749310 |
-662943091231200135 |
+--------------------------+-----------------------------+--------------------------------------+
+```
+
+```sql
+-- The function outputs a signed 64-bit integer.
+SELECT
+ mmhash3_64_v2,
+ mmhash3_u64_v2,
+ i64_to_ui64 = mmhash3_u64_v2 AS is_equal
+FROM (
+ SELECT
+ murmur_hash3_64_v2('1013199993_1756808272') AS mmhash3_64_v2,
+ murmur_hash3_u64_v2('1013199993_1756808272') AS mmhash3_u64_v2,
+ CAST(murmur_hash3_64_v2('1013199993_1756808272') AS LARGEINT) &
18446744073709551615 AS i64_to_ui64
+) t;
+```
+```text
++----------------------+----------------------+----------+
+| mmhash3_64_v2 | mmhash3_u64_v2 | is_equal |
++----------------------+----------------------+----------+
+| -2648103510258542450 | 15798640563451009166 | 1 |
++----------------------+----------------------+----------+
```
\ No newline at end of file
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
new file mode 100644
index 00000000000..9578dc8cbb3
--- /dev/null
+++
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
@@ -0,0 +1,67 @@
+---
+{
+ "title": "MURMUR_HASH3_U64_V2",
+ "language": "en",
+ "description": "Computes an unsigned 64-bit MurmurHash3 hash value."
+}
+---
+
+## Description
+
+Computes an unsigned 64-bit MurmurHash3 hash value, returned as LARGEINT type.
The unsigned version refer to [murmur_hash3_64_v2](./murmur-hash3-64-v2.md)
+
+This function reuses the implementation of `MURMUR_HASH3_64_V2` and masks the
result to unsigned 64-bit range (0 to 2^64-1), which is consistent with the
[standard library](https://mmh3.readthedocs.io/en/latest/api.html#mmh3.hash64)
implementation when interpreted as unsigned.
+
+## Syntax
+
+```sql
+MURMUR_HASH3_U64_V2( <str> [ , <str> ... ] )
+```
+
+## Parameters
+
+| Parameter | Description |
+| --------- | ------------------------------------------------------------ |
+| `<str>` | The String type value to be computed as an unsigned 64-bit
MurmurHash3 hash |
+
+## Return Value
+
+Returns the unsigned 64-bit MurmurHash3 hash value of the input string as
LARGEINT type.
+
+Returns NULL if any parameter is NULL.
+
+## Examples
+
+```sql
+select murmur_hash3_u64_v2(null), murmur_hash3_u64_v2("hello"),
murmur_hash3_u64_v2("hello", "world");
+```
+
+```text
++----------------------------+-------------------------------+----------------------------------------+
+| murmur_hash3_u64_v2(null) | murmur_hash3_u64_v2("hello") |
murmur_hash3_u64_v2("hello", "world") |
++----------------------------+-------------------------------+----------------------------------------+
+| NULL | 14688674573012802306 |
17783800982478351481 |
++----------------------------+-------------------------------+----------------------------------------+
+```
+
+
+```sql
+-- The function outputs an unsigned 64-bit integer.
+SELECT
+ mmhash3_64_v2,
+ mmhash3_u64_v2,
+ i64_to_ui64 = mmhash3_u64_v2 AS is_equal
+FROM (
+ SELECT
+ murmur_hash3_64_v2('1013199993_1756808272') AS mmhash3_64_v2,
+ murmur_hash3_u64_v2('1013199993_1756808272') AS mmhash3_u64_v2,
+ CAST(murmur_hash3_64_v2('1013199993_1756808272') AS LARGEINT) &
18446744073709551615 AS i64_to_ui64
+) t;
+```
+```text
++----------------------+----------------------+----------+
+| mmhash3_64_v2 | mmhash3_u64_v2 | is_equal |
++----------------------+----------------------+----------+
+| -2648103510258542450 | 15798640563451009166 | 1 |
++----------------------+----------------------+----------+
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
similarity index 61%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
copy to
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
index 5590f63630c..b516fbf0d99 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
@@ -2,13 +2,13 @@
{
"title": "MURMUR_HASH3_64_V2",
"language": "zh-CN",
- "description": "计算 64 位 murmur3 hash 值"
+ "description": "计算有符号 64 位 murmur3 hash 值"
}
---
## 描述
-计算 64 位 murmur3 hash 值
+计算有符号 64 位 murmur3 hash 值,
无符号版本参考[murmur_hash3_u64_v2](./murmur-hash3-u64-v2.md)。
与`MURMUR_HASH3_64`的区别是：此版本复用 MurmurHash3 的 128 位处理函数，仅输出第一个 64
位哈希值，与[标准库](https://mmh3.readthedocs.io/en/latest/api.html#mmh3.hash64)的行为保持一致。
@@ -45,3 +45,24 @@ select murmur_hash3_64_v2(null),
murmur_hash3_64_v2("hello"), murmur_hash3_64_v2
| NULL | -3215607508166160593 |
3583109472027628045 |
+-----------------------+--------------------------+-----------------------------------+
```
+
+```sql
+-- 该函数输出有符号 64 位整形
+SELECT
+ mmhash3_64_v2,
+ mmhash3_u64_v2,
+ i64_to_ui64 = mmhash3_u64_v2 AS is_equal
+FROM (
+ SELECT
+ murmur_hash3_64_v2('1013199993_1756808272') AS mmhash3_64_v2,
+ murmur_hash3_u64_v2('1013199993_1756808272') AS mmhash3_u64_v2,
+ CAST(murmur_hash3_64_v2('1013199993_1756808272') AS LARGEINT) &
18446744073709551615 AS i64_to_ui64
+) t;
+```
+```text
++----------------------+----------------------+----------+
+| mmhash3_64_v2 | mmhash3_u64_v2 | is_equal |
++----------------------+----------------------+----------+
+| -2648103510258542450 | 15798640563451009166 | 1 |
++----------------------+----------------------+----------+
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
new file mode 100644
index 00000000000..07fd410789d
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
@@ -0,0 +1,72 @@
+---
+{
+ "title": "MURMUR_HASH3_U64_V2",
+ "language": "zh-CN",
+ "description": "计算无符号 64 位 MurmurHash3 哈希值。"
+}
+---
+
+## 描述
+
+计算无符号 64 位 murmur3 hash
值。有符号整形版本参考[murmur_hash3_64_v2](./murmur-hash3-64-v2.md)。
+
+与`MURMUR_HASH3_64`的区别是：此版本复用 MurmurHash3 的 128 位处理函数，仅输出第一个 64
位哈希值，与[标准库](https://mmh3.readthedocs.io/en/latest/api.html#mmh3.hash64)的行为保持一致。
+
+-注：经过测试 xxhash_64 的性能大约是 murmur_hash3_64_v2 的 2 倍，所以在计算 hash
值时，更推荐使用`xxhash_64`，而不是`murmur_hash3_64`。如需更优的 64 位 MurmurHash3 性能，可考虑使用
`murmur_hash3_64`。
+
+:::note
+自 4.1.0 版本起支持此函数。
+:::
+
+## 语法
+
+```sql
+MURMUR_HASH3_U64_V2( <str> [ , <str> ... ] )
+```
+
+## 参数
+
+| 参数 | 描述 |
+| --------- | --------------------------------------- |
+| `<str>` | 要计算无符号 64 位 MurmurHash3 哈希的值 |
+
+## 返回值
+
+返回输入字符串的无符号 64 位 MurmurHash3 哈希值，类型为 LARGEINT。
+
+如果任何参数为 NULL，则返回 NULL。
+
+## 示例
+
+```sql
+select murmur_hash3_u64_v2(null), murmur_hash3_u64_v2("hello"),
murmur_hash3_u64_v2("hello", "world");
+```
+
+```text
++----------------------------+-------------------------------+----------------------------------------+
+| murmur_hash3_u64_v2(null) | murmur_hash3_u64_v2("hello") |
murmur_hash3_u64_v2("hello", "world") |
++----------------------------+-------------------------------+----------------------------------------+
+| NULL | 14688674573012802306 |
17783800982478351481 |
++----------------------------+-------------------------------+----------------------------------------+
+```
+
+```sql
+-- 该函数输出无符号 64 位整形
+SELECT
+ mmhash3_64_v2,
+ mmhash3_u64_v2,
+ i64_to_ui64 = mmhash3_u64_v2 AS is_equal
+FROM (
+ SELECT
+ murmur_hash3_64_v2('1013199993_1756808272') AS mmhash3_64_v2,
+ murmur_hash3_u64_v2('1013199993_1756808272') AS mmhash3_u64_v2,
+ CAST(murmur_hash3_64_v2('1013199993_1756808272') AS LARGEINT) &
18446744073709551615 AS i64_to_ui64
+) t;
+```
+```text
++----------------------+----------------------+----------+
+| mmhash3_64_v2 | mmhash3_u64_v2 | is_equal |
++----------------------+----------------------+----------+
+| -2648103510258542450 | 15798640563451009166 | 1 |
++----------------------+----------------------+----------+
+```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
index 5590f63630c..c7c4095771c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
@@ -2,16 +2,20 @@
{
"title": "MURMUR_HASH3_64_V2",
"language": "zh-CN",
- "description": "计算 64 位 murmur3 hash 值"
+ "description": "计算有符号 64 位 murmur3 hash 值"
}
---
## 描述
-计算 64 位 murmur3 hash 值
+计算有符号 64 位 murmur3 hash 值
与`MURMUR_HASH3_64`的区别是：此版本复用 MurmurHash3 的 128 位处理函数，仅输出第一个 64
位哈希值，与[标准库](https://mmh3.readthedocs.io/en/latest/api.html#mmh3.hash64)的行为保持一致。
+:::note
+无符号版本自4.1.0起支持，参考[murmur_hash3_u64_v2](./murmur-hash3-u64-v2.md)
+:::
+
-注：经过测试 xxhash_64 的性能大约是 murmur_hash3_64_v2 的 2 倍，所以在计算 hash
值时，更推荐使用`xxhash_64`，而不是`murmur_hash3_64`。如需更优的 64 位 MurmurHash3 性能，可考虑使用
`murmur_hash3_64`。
## 语法
@@ -45,3 +49,24 @@ select murmur_hash3_64_v2(null),
murmur_hash3_64_v2("hello"), murmur_hash3_64_v2
| NULL | -3215607508166160593 |
3583109472027628045 |
+-----------------------+--------------------------+-----------------------------------+
```
+
+```sql
+-- 该函数输出有符号 64 位整形
+SELECT
+ mmhash3_64_v2,
+ mmhash3_u64_v2,
+ i64_to_ui64 = mmhash3_u64_v2 AS is_equal
+FROM (
+ SELECT
+ murmur_hash3_64_v2('1013199993_1756808272') AS mmhash3_64_v2,
+ murmur_hash3_u64_v2('1013199993_1756808272') AS mmhash3_u64_v2,
+ CAST(murmur_hash3_64_v2('1013199993_1756808272') AS LARGEINT) &
18446744073709551615 AS i64_to_ui64
+) t;
+```
+```text
++----------------------+----------------------+----------+
+| mmhash3_64_v2 | mmhash3_u64_v2 | is_equal |
++----------------------+----------------------+----------+
+| -2648103510258542450 | 15798640563451009166 | 1 |
++----------------------+----------------------+----------+
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
new file mode 100644
index 00000000000..07fd410789d
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
@@ -0,0 +1,72 @@
+---
+{
+ "title": "MURMUR_HASH3_U64_V2",
+ "language": "zh-CN",
+ "description": "计算无符号 64 位 MurmurHash3 哈希值。"
+}
+---
+
+## 描述
+
+计算无符号 64 位 murmur3 hash
值。有符号整形版本参考[murmur_hash3_64_v2](./murmur-hash3-64-v2.md)。
+
+与`MURMUR_HASH3_64`的区别是：此版本复用 MurmurHash3 的 128 位处理函数，仅输出第一个 64
位哈希值，与[标准库](https://mmh3.readthedocs.io/en/latest/api.html#mmh3.hash64)的行为保持一致。
+
+-注：经过测试 xxhash_64 的性能大约是 murmur_hash3_64_v2 的 2 倍，所以在计算 hash
值时，更推荐使用`xxhash_64`，而不是`murmur_hash3_64`。如需更优的 64 位 MurmurHash3 性能，可考虑使用
`murmur_hash3_64`。
+
+:::note
+自 4.1.0 版本起支持此函数。
+:::
+
+## 语法
+
+```sql
+MURMUR_HASH3_U64_V2( <str> [ , <str> ... ] )
+```
+
+## 参数
+
+| 参数 | 描述 |
+| --------- | --------------------------------------- |
+| `<str>` | 要计算无符号 64 位 MurmurHash3 哈希的值 |
+
+## 返回值
+
+返回输入字符串的无符号 64 位 MurmurHash3 哈希值，类型为 LARGEINT。
+
+如果任何参数为 NULL，则返回 NULL。
+
+## 示例
+
+```sql
+select murmur_hash3_u64_v2(null), murmur_hash3_u64_v2("hello"),
murmur_hash3_u64_v2("hello", "world");
+```
+
+```text
++----------------------------+-------------------------------+----------------------------------------+
+| murmur_hash3_u64_v2(null) | murmur_hash3_u64_v2("hello") |
murmur_hash3_u64_v2("hello", "world") |
++----------------------------+-------------------------------+----------------------------------------+
+| NULL | 14688674573012802306 |
17783800982478351481 |
++----------------------------+-------------------------------+----------------------------------------+
+```
+
+```sql
+-- 该函数输出无符号 64 位整形
+SELECT
+ mmhash3_64_v2,
+ mmhash3_u64_v2,
+ i64_to_ui64 = mmhash3_u64_v2 AS is_equal
+FROM (
+ SELECT
+ murmur_hash3_64_v2('1013199993_1756808272') AS mmhash3_64_v2,
+ murmur_hash3_u64_v2('1013199993_1756808272') AS mmhash3_u64_v2,
+ CAST(murmur_hash3_64_v2('1013199993_1756808272') AS LARGEINT) &
18446744073709551615 AS i64_to_ui64
+) t;
+```
+```text
++----------------------+----------------------+----------+
+| mmhash3_64_v2 | mmhash3_u64_v2 | is_equal |
++----------------------+----------------------+----------+
+| -2648103510258542450 | 15798640563451009166 | 1 |
++----------------------+----------------------+----------+
+```
\ No newline at end of file
diff --git a/sidebars.ts b/sidebars.ts
index f50f5ab7794..19784523b22 100644
--- a/sidebars.ts
+++ b/sidebars.ts
@@ -1602,6 +1602,7 @@ const sidebars: SidebarsConfig = {
'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32',
'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64',
'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2',
+
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2",
'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sha',
'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sha2',
'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sm3',
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
index a0f76f89dd3..95023145601 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
@@ -2,16 +2,20 @@
{
"title": "MURMUR_HASH3_64_V2",
"language": "en",
- "description": "Computes a 64-bit MurmurHash3 hash value."
+ "description": "Computes a signed 64-bit MurmurHash3 hash value."
}
---
## Description
-Computes a 64-bit MurmurHash3 hash value.
+Computes a singed 64-bit MurmurHash3 hash value.
The difference from `MURMUR_HASH3_64` is: this version reuses the 128-bit
processing function of MurmurHash3, outputting only the first 64-bit hash
value, which is consistent with the [standard
library](https://mmh3.readthedocs.io/en/latest/api.html#mmh3.hash64)
implementation.
+:::note
+The unsigned version is supported since 4.1.0, refer to
[murmur_hash3_u64_v2](./murmur-hash3-u64-v2.md)
+:::
+
Note: According to testing, the performance of `xxhash_64` is approximately 2
times that of `murmur_hash3_64`. Therefore, when calculating hash values, it is
recommended to use `xxhash_64` instead of `murmur_hash3_64`.
## Syntax
@@ -44,4 +48,25 @@ select murmur_hash3_64_v2(null),
murmur_hash3_64_v2("hello"), murmur_hash3_64_v2
+--------------------------+-----------------------------+--------------------------------------+
| NULL | -3758069500696749310 |
-662943091231200135 |
+--------------------------+-----------------------------+--------------------------------------+
+```
+
+```sql
+-- The function outputs a signed 64-bit integer.
+SELECT
+ mmhash3_64_v2,
+ mmhash3_u64_v2,
+ i64_to_ui64 = mmhash3_u64_v2 AS is_equal
+FROM (
+ SELECT
+ murmur_hash3_64_v2('1013199993_1756808272') AS mmhash3_64_v2,
+ murmur_hash3_u64_v2('1013199993_1756808272') AS mmhash3_u64_v2,
+ CAST(murmur_hash3_64_v2('1013199993_1756808272') AS LARGEINT) &
18446744073709551615 AS i64_to_ui64
+) t;
+```
+```text
++----------------------+----------------------+----------+
+| mmhash3_64_v2 | mmhash3_u64_v2 | is_equal |
++----------------------+----------------------+----------+
+| -2648103510258542450 | 15798640563451009166 | 1 |
++----------------------+----------------------+----------+
```
\ No newline at end of file
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
new file mode 100644
index 00000000000..f0c12bc670e
--- /dev/null
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2.md
@@ -0,0 +1,71 @@
+---
+{
+ "title": "MURMUR_HASH3_U64_V2",
+ "language": "en",
+ "description": "Computes an unsigned 64-bit MurmurHash3 hash value."
+}
+---
+
+## Description
+
+Computes an unsigned 64-bit MurmurHash3 hash value, returned as LARGEINT type.
The unsigned version refer to [murmur_hash3_64_v2](./murmur-hash3-64-v2.md)
+
+This function reuses the implementation of `MURMUR_HASH3_64_V2` and masks the
result to unsigned 64-bit range (0 to 2^64-1), which is consistent with the
[standard library](https://mmh3.readthedocs.io/en/latest/api.html#mmh3.hash64)
implementation when interpreted as unsigned.
+
+:::note
+This function is supported since 4.1.0.
+:::
+
+## Syntax
+
+```sql
+MURMUR_HASH3_U64_V2( <str> [ , <str> ... ] )
+```
+
+## Parameters
+
+| Parameter | Description |
+| --------- | ------------------------------------------------------------ |
+| `<str>` | The String type value to be computed as an unsigned 64-bit
MurmurHash3 hash |
+
+## Return Value
+
+Returns the unsigned 64-bit MurmurHash3 hash value of the input string as
LARGEINT type.
+
+Returns NULL if any parameter is NULL.
+
+## Examples
+
+```sql
+select murmur_hash3_u64_v2(null), murmur_hash3_u64_v2("hello"),
murmur_hash3_u64_v2("hello", "world");
+```
+
+```text
++----------------------------+-------------------------------+----------------------------------------+
+| murmur_hash3_u64_v2(null) | murmur_hash3_u64_v2("hello") |
murmur_hash3_u64_v2("hello", "world") |
++----------------------------+-------------------------------+----------------------------------------+
+| NULL | 14688674573012802306 |
17783800982478351481 |
++----------------------------+-------------------------------+----------------------------------------+
+```
+
+
+```sql
+-- The function outputs an unsigned 64-bit integer.
+SELECT
+ mmhash3_64_v2,
+ mmhash3_u64_v2,
+ i64_to_ui64 = mmhash3_u64_v2 AS is_equal
+FROM (
+ SELECT
+ murmur_hash3_64_v2('1013199993_1756808272') AS mmhash3_64_v2,
+ murmur_hash3_u64_v2('1013199993_1756808272') AS mmhash3_u64_v2,
+ CAST(murmur_hash3_64_v2('1013199993_1756808272') AS LARGEINT) &
18446744073709551615 AS i64_to_ui64
+) t;
+```
+```text
++----------------------+----------------------+----------+
+| mmhash3_64_v2 | mmhash3_u64_v2 | is_equal |
++----------------------+----------------------+----------+
+| -2648103510258542450 | 15798640563451009166 | 1 |
++----------------------+----------------------+----------+
+```
diff --git a/versioned_sidebars/version-4.x-sidebars.json
b/versioned_sidebars/version-4.x-sidebars.json
index 49c6cadff6f..d588cb407de 100644
--- a/versioned_sidebars/version-4.x-sidebars.json
+++ b/versioned_sidebars/version-4.x-sidebars.json
@@ -1619,6 +1619,7 @@
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32",
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64",
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2",
+
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2",
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sha",
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sha2",
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sm3",
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
