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 60c574f2c23 [Fix](dox) Remove some docs for func that doesnt support
in 3.x (#3451)
60c574f2c23 is described below
commit 60c574f2c23f1c9cd170604861cdc700ae183aed
Author: linrrarity <[email protected]>
AuthorDate: Wed Mar 11 22:14:47 2026 +0800
[Fix](dox) Remove some docs for func that doesnt support in 3.x (#3451)
---
.../encrypt-digest-functions/xxhash-64.md | 4 -
.../encrypt-digest-functions/murmur-hash3-64-v2.md | 47 ----
.../encrypt-digest-functions/murmur-hash3-64.md | 2 -
.../encrypt-digest-functions/xxhash-64.md | 4 -
.../aggregate-functions/linear-histogram.md | 65 ------
.../aggregate-functions/regr_intercept.md | 63 ------
.../aggregate-functions/regr_slope.md | 63 ------
.../string-functions/count_substrings.md | 4 +
.../string-functions/regexp-count.md | 249 ---------------------
.../aggregate-functions/linear-histogram.md | 65 ------
.../aggregate-functions/regr_intercept.md | 63 ------
.../aggregate-functions/regr_slope.md | 63 ------
.../encrypt-digest-functions/murmur-hash3-64-v2.md | 47 ----
.../encrypt-digest-functions/murmur-hash3-64.md | 2 -
.../string-functions/count_substrings.md | 4 +
.../string-functions/regexp-count.md | 249 ---------------------
versioned_sidebars/version-3.x-sidebars.json | 5 -
17 files changed, 8 insertions(+), 991 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/xxhash-64.md
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/xxhash-64.md
index 34521996a9e..fa77090715b 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/xxhash-64.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/xxhash-64.md
@@ -12,10 +12,6 @@ Calculates the 64-bit xxhash value of the input string or
binary.
-Note: After testing, the performance of `xxhash_64` is about twice that of
`murmur_hash3_64`, so when calculating hash values, it is recommended to use
`xxhash_64` instead of `murmur_hash3_64`.
-## Alias
-
-- `XXHASH3_64`
-
## Syntax
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/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
deleted file mode 100644
index 5590f63630c..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
+++ /dev/null
@@ -1,47 +0,0 @@
----
-{
- "title": "MURMUR_HASH3_64_V2",
- "language": "zh-CN",
- "description": "计算 64 位 murmur3 hash 值"
-}
----
-
-## 描述
-
-计算 64 位 murmur3 hash 值
-
-与`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`。
-
-## 语法
-
-```sql
-MURMUR_HASH3_64_V2( <str> [ , <str> ... ] )
-```
-
-## 参数
-
-| 参数 | 说明 |
-|---------|------------------------|
-| `<str>` | 需要被计算 64 位 murmur3 hash 的值 |
-
-## 返回值
-
-返回输入字符串的 64 位 murmur3 hash 值。
-
-任一参数为 NULL 时返回 NULL
-
-## 示例
-
-```sql
-select murmur_hash3_64_v2(null), murmur_hash3_64_v2("hello"),
murmur_hash3_64_v2("hello", "world");
-```
-
-```text
-+-----------------------+--------------------------+-----------------------------------+
-| murmur_hash3_64(NULL) | murmur_hash3_64('hello') | murmur_hash3_64('hello',
'world') |
-+-----------------------+--------------------------+-----------------------------------+
-| NULL | -3215607508166160593 |
3583109472027628045 |
-+-----------------------+--------------------------+-----------------------------------+
-```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64.md
index e1559204725..471c394e112 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64.md
@@ -10,8 +10,6 @@
计算 64 位 murmur3 hash 值
-与`MURMUR_HASH3_64_V2`的区别是：此版本专门为 64 位输出优化，性能略优于 v2 版本,
但与[标准库](https://mmh3.readthedocs.io/en/latest/api.html#mmh3.hash64)实现不一致。
-
-注：经过测试 xxhash_64 的性能大约是 murmur_hash3_64 的 2 倍，所以在计算 hash
值时，更推荐使用`xxhash_64`，而不是`murmur_hash3_64`。
## 语法
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/xxhash-64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/xxhash-64.md
index b1cf7e791ee..e5aad81a8ac 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/xxhash-64.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/xxhash-64.md
@@ -12,10 +12,6 @@
-注：经过测试 xxhash_64 的性能大约是 murmur_hash3_64 的 2 倍，所以在计算 hash
值时，更推荐使用`xxhash_64`，而不是`murmur_hash3_64`。
-## 别名
-
-- `XXHASH3_64`
-
## 语法
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/linear-histogram.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/linear-histogram.md
deleted file mode 100644
index 7f7042d2a29..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/linear-histogram.md
+++ /dev/null
@@ -1,65 +0,0 @@
----
-{
- "title": "LINEAR_HISTOGRAM",
- "language": "zh-CN",
- "description": "LINEARHISTOGRAM 函数用于描述数据分布情况，它使用“等宽”的分桶策略，并按照数据的值大小进行分桶。"
-}
----
-
-## 描述
-
-LINEAR_HISTOGRAM 函数用于描述数据分布情况，它使用“等宽”的分桶策略，并按照数据的值大小进行分桶。
-
-## 语法
-
-```sql
-`LINEAR_HISTOGRAM(<expr>, DOUBLE <interval>[, DOUBLE <offset>)`
-```
-
-## 参数说明
-
-| 参数 | 说明 |
-| -- | -- |
-| `interval` | 必须。桶的宽度 |
-| `offset` | 可选。默认为 0，范围是 `[0, interval)` |
-
-## 返回值
-
-返回计算后的 JSON 类型的值。
-
-## 举例
-
-```sql
-select linear_histogram(a, 2) from histogram_test;
-```
-
-```text
-+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| linear_histogram(a, cast(2 as DOUBLE))
|
-+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|
{"num_buckets":6,"buckets":[{"lower":0.0,"upper":2.0,"count":2,"acc_count":2},{"lower":2.0,"upper":4.0,"count":4,"acc_count":6},{"lower":4.0,"upper":6.0,"count":4,"acc_count":10},{"lower":6.0,"upper":8.0,"count":4,"acc_count":14},{"lower":8.0,"upper":10.0,"count":4,"acc_count":18},{"lower":10.0,"upper":12.0,"count":2,"acc_count":20}]}
|
-+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-```
-
-```sql
-select linear_histogram(a, 2, 1) from histogram_test;
-```
-
-```text
-+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| linear_histogram(a, cast(2 as DOUBLE), cast(1 as DOUBLE))
|
-+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|
{"num_buckets":5,"buckets":[{"lower":1.0,"upper":3.0,"count":4,"acc_count":4},{"lower":3.0,"upper":5.0,"count":4,"acc_count":8},{"lower":5.0,"upper":7.0,"count":4,"acc_count":12},{"lower":7.0,"upper":9.0,"count":4,"acc_count":16},{"lower":9.0,"upper":11.0,"count":4,"acc_count":20}]}
|
-+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-```
-
-```text
-字段说明：
-
-- `num_buckets`：桶的数量。
-- `buckets`：直方图所包含的桶。
- - `lower`：桶的下界。（包含在内）
- - `upper`：桶的上界。（不包含在内）
- - `count`：桶内包含的元素数量。
- - `acc_count`：前面桶与当前桶元素的累计总量。
-```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_intercept.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_intercept.md
deleted file mode 100644
index a127c2e863f..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_intercept.md
+++ /dev/null
@@ -1,63 +0,0 @@
----
-{
- "title": "REGR_INTERCEPT",
- "language": "zh-CN",
- "description": "REGRINTERCEPT 用于计算一组数值对的最小二乘拟合线性方程的截距。"
-}
----
-
-## Description
-REGR_INTERCEPT 用于计算一组数值对的最小二乘拟合线性方程的截距。
-
-## Syntax
-```
-REGR_INTERCEPT(y, x)
-```
-
-## Parameters
-- `y` (数值类型)：因变量。
-- `x` (数值类型)：自变量。
-
-x 和 y 都支持基本数值类型。
-
-## Returned values
-返回数据类型：FLOAT64
-
-函数返回线性回归直线的截距。
-
-如果没有行，或者只有包含空值的行，函数返回 NULL。
-
-## Examples
-```sql
--- 示例 1：基本用法
-SELECT regr_intercept(y, x) FROM test;
-
--- 示例 2：在查询中使用示例数据
-SELECT * FROM test;
-+------+------+------+
-| id | x | y |
-+------+------+------+
-| 1 | 18 | 13 |
-| 3 | 12 | 2 |
-| 5 | 10 | 20 |
-| 2 | 14 | 27 |
-| 4 | 5 | 6 |
-+------+------+------+
-
-SELECT regr_intercept(y, x) FROM test;
-+----------------------+
-| regr_intercept(y, x) |
-+----------------------+
-| 5.512931034482759 |
-+----------------------+
-```
-
-## Usage notes
-- 此函数会忽略任何包含空值的数值对。
-- 在计算结果会导致除以零的情况下，函数将返回 NULL。
-
-## Related functions
-REGR_SLOPE, REGR_R2, REGR_COUNT, REGR_AVGX, REGR_AVGY
-
-## References
-有关线性回归函数的更多详细信息，请参阅 SQL 标准文档中关于聚合函数的部分。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_slope.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_slope.md
deleted file mode 100644
index ffa12ea47a4..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_slope.md
+++ /dev/null
@@ -1,63 +0,0 @@
----
-{
- "title": "REGR_SLOPE",
- "language": "zh-CN",
- "description": "REGRSLOPE 用于计算一组数值对的最小二乘拟合线性方程的斜率。"
-}
----
-
-## Description
-REGR_SLOPE 用于计算一组数值对的最小二乘拟合线性方程的斜率。
-
-## Syntax
-```
-REGR_SLOPE(y, x)
-```
-
-## Parameters
-- `y` (数值类型)：因变量。
-- `x` (数值类型)：自变量。
-
-x 和 y 都支持基本数值类型。
-
-## Returned values
-返回数据类型：FLOAT64
-
-函数返回线性回归直线的斜率。
-
-如果没有行，或者只有包含空值的行，函数返回 NULL。
-
-## Examples
-```sql
--- 示例 1：基本用法
-SELECT regr_slope(y, x) FROM test;
-
--- 示例 2：在查询中使用示例数据
-SELECT * FROM test;
-+------+------+------+
-| id | x | y |
-+------+------+------+
-| 1 | 18 | 13 |
-| 3 | 12 | 2 |
-| 5 | 10 | 20 |
-| 2 | 14 | 27 |
-| 4 | 5 | 6 |
-+------+------+------+
-
-SELECT regr_slope(y, x) FROM test;
-+--------------------+
-| regr_slope(y, x) |
-+--------------------+
-| 0.6853448275862069 |
-+--------------------+
-```
-
-## Usage notes
-- 此函数会忽略任何包含空值的数值对。
-- 在计算结果会导致除以零的情况下，函数将返回 NULL。
-
-## Related functions
-REGR_INTERCEPT, REGR_R2, REGR_COUNT, REGR_AVGX, REGR_AVGY
-
-## References
-有关线性回归函数的更多详细信息，请参阅 SQL 标准文档中关于聚合函数的部分。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
index 18583c93e22..75b2d02063f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
@@ -10,6 +10,10 @@
COUNT_SUBSTRINGS 函数用于计算一个字符串中指定子串出现的次数。注意：当前实现在每次匹配到子串时，会偏移一个子串长度继续查找。例如，当
str='ccc' 且 pattern='cc' 时，返回结果为 1。
+:::note
+该函数自3.1.1起支持
+:::
+
## 语法
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-count.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-count.md
deleted file mode 100644
index 0cf45799e15..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-count.md
+++ /dev/null
@@ -1,249 +0,0 @@
----
-{
- "title": "REGEXP_COUNT",
- "language": "zh-CN",
- "description":
"这是一个用于统计字符串中匹配给定正则表达式模式的字符数量的函数。输入包括用户提供的字符串和正则表达式模式。返回值为匹配字符的总数量；如果未找到匹配项，则返回
0。 需要注意的是，在处理字符集匹配时，应使用 Utf-8 标准字符类。这确保函数能够正确识别和处理来自不同语言的各种字符。"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
- http://www.apache.org/licenses/LICENSE-2.0
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-## 描述
-这是一个用于统计字符串中匹配给定正则表达式模式的字符数量的函数。输入包括用户提供的字符串和正则表达式模式。返回值为匹配字符的总数量；如果未找到匹配项，则返回
0。
-需要注意的是，在处理字符集匹配时，应使用 Utf-8 标准字符类。这确保函数能够正确识别和处理来自不同语言的各种字符。
-
-'str' 参数为 “string” 类型，是用户希望通过正则表达式进行匹配的字符串。
-
- 'pattern' 参数为 “string” 类型，是用于匹配字符串的正则表达式模式字符串。
-
- 返回值为 “int” 类型，表示成功匹配的字符数量。
-
-支持的字符匹配种类 : https://github.com/google/re2/wiki/Syntax
-
-## 语法
-
-```sql
-REGEXP_COUNT(<str>, <pattern>)
-```
-
-## 参数
-
-| 参数 | 描述 |
-| -- | -- |
-| `<str>` | 该参数为 “string” 类型，是通过正则表达式匹配得到的目标值。|
-| `<pattern>` |该参数为 “string” 类型，是一个正则表达式，用于匹配符合该模式规则的字符串。|
-
-## 返回值
-
-- 返回正则表达式 “pattern” 在字符串 “str” 中的匹配字符数量，返回类型为 “int”。若没有字符匹配，则返回 0。
-- 如果'str' 或者 'parttern' 为NULL ,或者他们都为NULL，返回NULL;
-- 如果 'pattern' 不符合正则表达式规则，则是错误的用法，抛出error;
-
-字符串区匹配包含转义字符的表达式返回结果
-
-```sql
-SELECT regexp_count('a.b:c;d', '[\\\\.:;]');
-```
-
-```text
-+--------------------------------------+
-| regexp_count('a.b:c;d', '[\\\\.:;]') |
-+--------------------------------------+
-| 3 |
-+--------------------------------------+
-```
-
-普通的字符':'的正则表达式的字符串匹配结果
-
-```sql
-SELECT regexp_count('a.b:c;d', ':');
-```
-
-```text
-+------------------------------+
-| regexp_count('a.b:c;d', ':') |
-+------------------------------+
-| 1 |
-+------------------------------+
-```
-字符串去匹配包含有两个中括号的正则表达式的返回结果
-
-```sql
-SELECT regexp_count('Hello, World!', '[[:punct:]]');
-```
-
-```text
-+----------------------------------------------+
-| regexp_count('Hello, World!', '[[:punct:]]') |
-+----------------------------------------------+
-| 2 |
-+----------------------------------------------+
-```
-
-
- 'patter' 为 NULL值的情况
-
-```sql
-SELECT regexp_count("abc",NULL);
-```
-```text
-+------------------------+
-| regexp_count("abc",NULL) |
-+------------------------+
-| NULL |
-+------------------------+
-```
-
-
- 'str' 为 NULL 值的情况
-
-```sql
-SELECT regexp_count(NULL,"abc");
-```
-```text
-+------------------------+
-| regexp_count(NULL,"abc") |
-+------------------------+
-| NULL |
-+------------------------+
-```
-
-都为NULL值的情况
-
-
-```sql
-SELECT regexp_count(NULL,NULL);
-```
-```text
-+------------------------+
-| regexp_count(NULL,NULL) |
-+------------------------+
-| NULL |
-+------------------------+
-```
-
-
-插入一定变量值，从存储行取出变量去匹配的返回结果
-
-```sql
-
-CREATE TABLE test_table_for_regexp_count (
- id INT,
- text_data VARCHAR(500),
- pattern VARCHAR(100)
- ) PROPERTIES ("replication_num"="1");
-
-INSERT INTO test_table_for_regexp_count VALUES
- (1, 'HelloWorld', '[A-Z][a-z]+'),
- (2, 'apple123', '[a-z]{5}[0-9]'),
- (3, 'aabbcc', '(aa|bb|cc)'),
- (4, '123-456-7890', '[0-9][0-9][0-9]'),
- (5, 'test,data', ','),
- (6, 'a1b2c3', '[a-z][0-9]'),
- (7, 'book keeper', 'oo|ee'),
- (8, 'ababab', '(ab)(ab)(ab)'),
- (9, 'aabbcc', '(aa|bb|cc)'),
- (10, 'apple,banana', '[aeiou][a-z]+');
-
-SELECT id, regexp_count(text_data, pattern) as count_result FROM
test_table_for_regexp_count ORDER BY id;
-
-```
-
-```text
-+------+--------------+
-| id | count_result |
-+------+--------------+
-| 1 | 2 |
-| 2 | 1 |
-| 3 | 3 |
-| 4 | 3 |
-| 5 | 1 |
-| 6 | 3 |
-| 7 | 2 |
-| 8 | 1 |
-| 9 | 3 |
-| 10 | 2 |
-+------+--------------+
-
-```
-插入一定变量值，从存储行取出变量去匹配的返回结果，但正则表达式为常量
-
-```sql
-CREATE TABLE test_table_for_regexp_count (
- id INT,
- text_data VARCHAR(500),
- pattern VARCHAR(100)
- ) PROPERTIES ("replication_num"="1");
-
-INSERT INTO test_table_for_regexp_count VALUES
- (1, 'HelloWorld', '[A-Z][a-z]+'),
- (2, 'apple123', '[a-z]{5}[0-9]'),
- (3, 'aabbcc', '(aa|bb|cc)'),
- (4, '123-456-7890', '[0-9][0-9][0-9]'),
- (5, 'test,data', ','),
- (6, 'a1b2c3', '[a-z][0-9]'),
- (7, 'book keeper', 'oo|ee'),
- (8, 'ababab', '(ab)(ab)(ab)'),
- (9, 'aabbcc', '(aa|bb|cc)'),
- (10, 'apple,banana', '[aeiou][a-z]+');
-
-SELECT id, regexp_count(text_data, 'e') as count_e FROM
test_table_for_regexp_count WHERE text_data IS NOT NULL ORDER BY id;
-```
-
-```text
-+------+---------+
-| id | count_e |
-+------+---------+
-| 1 | 1 |
-| 2 | 1 |
-| 3 | 0 |
-| 4 | 0 |
-| 5 | 1 |
-| 6 | 0 |
-| 7 | 3 |
-| 8 | 0 |
-| 9 | 0 |
-| 10 | 1 |
-+------+---------+
-```
-
-emoji字符匹配
-
-```sql
-SELECT regexp_count('🍔🍟🍕🌍', '🍔|🍟|🍕');
-```
-
-```text
-+----------------------------------------------------+
-| regexp_count('🍔🍟🍕🌍', '🍔|🍟|🍕') |
-+----------------------------------------------------+
-| 3 |
-+----------------------------------------------------+
-```
-
-如果 'pattern' 参数不符合正则表达式，则抛出错误
-
-```sql
-
-SELECT regexp_count('Hello, World!', '[[:punct:');
-```
-
-```text
-
-ERROR 1105 (HY000): errCode = 2, detailMessage =
(10.16.10.2)[INVALID_ARGUMENT]Could not compile regexp pattern: [[:punct:
-Error: missing ]: [[:punct:
-```
\ No newline at end of file
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/linear-histogram.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/linear-histogram.md
deleted file mode 100644
index 3c118e7fe06..00000000000
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/linear-histogram.md
+++ /dev/null
@@ -1,65 +0,0 @@
----
-{
- "title": "LINEAR_HISTOGRAM",
- "language": "en",
- "description": "The LINEARHISTOGRAM function is used to describe the data
distribution. It uses an \"equal width\" bucking strategy,"
-}
----
-
-## Description
-
-The LINEAR_HISTOGRAM function is used to describe the data distribution. It
uses an "equal width" bucking strategy, and divides the data into buckets
according to the value of the data.
-
-## Syntax
-
-```sql
-`LINEAR_HISTOGRAM(<expr>, DOUBLE <interval>[, DOUBLE <offset>)`
-```
-
-## Parameters
-
-| Parameters | Description |
-| -- | -- |
-| `interval` | Required. The width of the bucket. |
-| `offset` | Optional. The default value is 0, and the range is `[0,
interval)`. |
-
-## Return Value
-
-Returns a value of the computed JSON type.
-
-## Example
-
-```sql
-select linear_histogram(a, 2) from histogram_test;
-```
-
-```text
-+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| linear_histogram(a, cast(2 as DOUBLE))
|
-+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|
{"num_buckets":6,"buckets":[{"lower":0.0,"upper":2.0,"count":2,"acc_count":2},{"lower":2.0,"upper":4.0,"count":4,"acc_count":6},{"lower":4.0,"upper":6.0,"count":4,"acc_count":10},{"lower":6.0,"upper":8.0,"count":4,"acc_count":14},{"lower":8.0,"upper":10.0,"count":4,"acc_count":18},{"lower":10.0,"upper":12.0,"count":2,"acc_count":20}]}
|
-+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-```
-
-```sql
-select linear_histogram(a, 2, 1) from histogram_test;
-```
-
-```text
-+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| linear_histogram(a, cast(2 as DOUBLE), cast(1 as DOUBLE))
|
-+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|
{"num_buckets":5,"buckets":[{"lower":1.0,"upper":3.0,"count":4,"acc_count":4},{"lower":3.0,"upper":5.0,"count":4,"acc_count":8},{"lower":5.0,"upper":7.0,"count":4,"acc_count":12},{"lower":7.0,"upper":9.0,"count":4,"acc_count":16},{"lower":9.0,"upper":11.0,"count":4,"acc_count":20}]}
|
-+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-```
-
-```text
-Field description:
-
-- `num_buckets`: The number of buckets.
-- `buckets`: All buckets.
- - `lower`: Lower bound of the bucket. (included)
- - `upper`: Upper bound of the bucket. (not included)
- - `count`: The number of elements contained in the bucket.
- - `acc_count`: Accumulated count.
-```
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_intercept.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_intercept.md
deleted file mode 100644
index 5bb8bbb88b5..00000000000
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_intercept.md
+++ /dev/null
@@ -1,63 +0,0 @@
----
-{
- "title": "REGR_INTERCEPT",
- "language": "en",
- "description": "REGRINTERCEPT is used to calculate the y-intercept of the
least squares-fit linear equation for a set of number pairs."
-}
----
-
-## Description
-REGR_INTERCEPT is used to calculate the y-intercept of the least squares-fit
linear equation for a set of number pairs.
-
-## Syntax
-```
-REGR_INTERCEPT(y, x)
-```
-
-## Parameters
-- `y` (Numeric): The dependent variable.
-- `x` (Numeric): The independent variable.
-
-Both `x` and `y` support basic numeric types.
-
-## Returned values
-Returned data type: FLOAT64
-
-The function returns the y-intercept of the linear regression line.
-
-If there are no rows, or only rows with null values, the function returns NULL.
-
-## Examples
-```sql
--- Example 1: Basic Usage
-SELECT regr_intercept(y, x) FROM test;
-
--- Example 2: Usage in a query with sample data
-SELECT * FROM test;
-+------+------+------+
-| id | x | y |
-+------+------+------+
-| 1 | 18 | 13 |
-| 3 | 12 | 2 |
-| 5 | 10 | 20 |
-| 2 | 14 | 27 |
-| 4 | 5 | 6 |
-+------+------+------+
-
-SELECT regr_intercept(y, x) FROM test;
-+----------------------+
-| regr_intercept(y, x) |
-+----------------------+
-| 5.512931034482759 |
-+----------------------+
-```
-
-## Usage notes
-- This function ignores any pair where either value is null.
-- In cases where the calculation would result in a division by zero, the
function will return NULL.
-
-## Related functions
-REGR_SLOPE, REGR_R2, REGR_COUNT, REGR_AVGX, REGR_AVGY
-
-## References
-For more details about linear regression functions, please refer to the SQL
standard documentation on aggregate functions.
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_slope.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_slope.md
deleted file mode 100644
index c9607d602b1..00000000000
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/regr_slope.md
+++ /dev/null
@@ -1,63 +0,0 @@
----
-{
- "title": "REGR_SLOPE",
- "language": "en",
- "description": "REGRSLOPE is used to calculate the slope of the least
squares-fit linear equation for a set of number pairs."
-}
----
-
-## Description
-REGR_SLOPE is used to calculate the slope of the least squares-fit linear
equation for a set of number pairs.
-
-## Syntax
-```
-REGR_SLOPE(y, x)
-```
-
-## Parameters
-- `y` (Numeric): The dependent variable.
-- `x` (Numeric): The independent variable.
-
-Both `x` and `y` support basic numeric types.
-
-## Returned values
-Returned data type: FLOAT64
-
-The function returns the slope of the linear regression line.
-
-If there are no rows, or only rows with null values, the function returns NULL.
-
-## Examples
-```sql
--- Example 1: Basic Usage
-SELECT regr_slope(y, x) FROM test;
-
--- Example 2: Usage in a query with sample data
-SELECT * FROM test;
-+------+------+------+
-| id | x | y |
-+------+------+------+
-| 1 | 18 | 13 |
-| 3 | 12 | 2 |
-| 5 | 10 | 20 |
-| 2 | 14 | 27 |
-| 4 | 5 | 6 |
-+------+------+------+
-
-SELECT regr_slope(y, x) FROM test;
-+--------------------+
-| regr_slope(y, x) |
-+--------------------+
-| 0.6853448275862069 |
-+--------------------+
-```
-
-## Usage notes
-- This function ignores any pair where either value is null.
-- In cases where the calculation would result in a division by zero, the
function will return NULL.
-
-## Related functions
-REGR_INTERCEPT, REGR_R2, REGR_COUNT, REGR_AVGX, REGR_AVGY
-
-## References
-For more details about linear regression functions, please refer to the SQL
standard documentation on aggregate functions.
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
deleted file mode 100644
index 2228c62a8fe..00000000000
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
+++ /dev/null
@@ -1,47 +0,0 @@
----
-{
- "title": "MURMUR_HASH3_64_V2",
- "language": "en",
- "description": "Computes a 64-bit MurmurHash3 hash value."
-}
----
-
-## Description
-
-Computes a 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: 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`. If better 64-bit
MurmurHash3 performance is needed, consider using `murmur_hash3_64`.
-
-## Syntax
-
-```sql
-MURMUR_HASH3_64_V2( <str> [ , <str> ... ] )
-```
-
-## Parameters
-
-| Parameter | Description |
-| --------- | ----------------------------------------------------- |
-| `<str>` | The value to be computed as a 64-bit MurmurHash3 hash |
-
-## Return Value
-
-Returns the 64-bit MurmurHash3 hash value of the input string.
-
-Returns NULL if any parameter is NULL.
-
-## Examples
-
-```sql
-select murmur_hash3_64_v2(null), murmur_hash3_64_v2("hello"),
murmur_hash3_64_v2("hello", "world");
-```
-
-```text
-+--------------------------+-----------------------------+--------------------------------------+
-| murmur_hash3_64_v2(null) | murmur_hash3_64_v2("hello") |
murmur_hash3_64_v2("hello", "world") |
-+--------------------------+-----------------------------+--------------------------------------+
-| NULL | -3758069500696749310 |
-662943091231200135 |
-+--------------------------+-----------------------------+--------------------------------------+
-```
\ No newline at end of file
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64.md
index c24abeb65e5..3fc60bc1aa9 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64.md
@@ -10,8 +10,6 @@
Calculate 64-bit murmur3 hash value
-The difference from `MURMUR_HASH3_64_V2` is: This version is specifically
optimized for 64-bit output, with slightly better performance than the v2
version, but is inconsistent with the [standard
library](https://mmh3.readthedocs.io/en/latest/api.html#mmh3.hash64)
implementation.
-
-Note: After testing, the performance of `xxhash_64` is about twice that of
`murmur_hash3_64`, so when calculating hash values, it is recommended to use
`xxhash_64` instead of `murmur_hash3_64`.
## Syntax
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
index 44b0a93303b..7b562b6eeb5 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
@@ -10,6 +10,10 @@
The COUNT_SUBSTRINGS function counts the number of occurrences of a specified
substring within a string. Note: The current implementation continues searching
after shifting by the length of the substring when a match is found. For
example, when str='ccc' and pattern='cc', the result returned is 1.
+:::note
+Since 3.1.1
+:::
+
## Syntax
```sql
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-count.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-count.md
deleted file mode 100644
index aa12b6bdb79..00000000000
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-count.md
+++ /dev/null
@@ -1,249 +0,0 @@
----
-{
- "title": "REGEXP_COUNT",
- "language": "en",
- "description": "This is a function to count the number of characters in a
string that match a given regular expression pattern."
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
- http://www.apache.org/licenses/LICENSE-2.0
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## Description
-This is a function to count the number of characters in a string that match a
given regular expression pattern. The input consists of a user-provided string
and a regular expression pattern. The return value is n the total count of
matching characters; if no matches are found, it returns 0.
-
-'str' paratemer is 'string' type,it is the string of usr want to match by a
regexp expression.
-
-'pattern' paratemer is 'string' type, it is the string of a regexp regular
which will be used to match the string;
-
-It should be noted that when handling character set matching, Utf-8 standard
character classes should be used. This ensures that functions can correctly
identify and process various characters from different languages.
-
-Support character match classes : https://github.com/google/re2/wiki/Syntax
-
-## Syntax
-
-```sql
-REGEXP_COUNT(<str>, <pattern>)
-```
-
-## Parameters
-
-| Parameter | Description |
-| -- | -- |
-| `<str>` | The parameter is 'string' type,it is the dest value which matched
by the regexp expression. |
-| `<pattern>` | The parameter is 'string' type, it is a regexp expression and
it is used to match the string which meet the regular of the pattern. |
-## Return Value
-
-- Returns number of matches for a regular expression 'pattern' within a
'str',it is 'int',if no character can be matched, return 0;
-If pattern is NULL or str is NULL or both are NULL,return NULL;
-If pattern is not allowed regexp regular , it will throw error,it`s a wrong
for this action;
-
-## Examples
-
-The string region matching against an expression containing escape characters
and return the result
-
-```sql
-SELECT regexp_count('a.b:c;d', '[\\\\.:;]');
-```
-
-```text
-+--------------------------------------+
-| regexp_count('a.b:c;d', '[\\\\.:;]') |
-+--------------------------------------+
-| 3 |
-+--------------------------------------+
-```
-
-The string matching result of the regular expression for the ordinary
character ':'.
-
-```sql
-SELECT regexp_count('a.b:c;d', ':');
-```
-
-```text
-+------------------------------+
-| regexp_count('a.b:c;d', ':') |
-+------------------------------+
-| 1 |
-+------------------------------+
-```
-The return result when matching a string against a regular expression
containing two square brackets.
-
-```sql
-SELECT regexp_count('Hello, World!', '[[:punct:]]');
-```
-
-```text
-+----------------------------------------------+
-| regexp_count('Hello, World!', '[[:punct:]]') |
-+----------------------------------------------+
-| 2 |
-+----------------------------------------------+
-```
-
-
-Pattern is NULL case
-
-```sql
-SELECT regexp_count("abc",NULL);
-```
-```text
-+------------------------+
-| regexp_count("abc",NULL) |
-+------------------------+
-| NULL |
-+------------------------+
-```
-
-
-Str is NULL case
-
-```sql
-SELECT regexp_count(NULL,"abc");
-```
-```text
-+------------------------+
-| regexp_count(NULL,"abc") |
-+------------------------+
-| NULL |
-+------------------------+
-```
-
-Both are NULL
-
-
-```sql
-SELECT regexp_count(NULL,NULL);
-```
-```text
-+------------------------+
-| regexp_count(NULL,NULL) |
-+------------------------+
-| NULL |
-+------------------------+
-```
-
-The return result of inserting certain variable values and then retrieving the
variables from the stored rows for matching.
-
-```sql
-
-CREATE TABLE test_table_for_regexp_count (
- id INT,
- text_data VARCHAR(500),
- pattern VARCHAR(100)
- ) PROPERTIES ("replication_num"="1");
-
-INSERT INTO test_table_for_regexp_count VALUES
- (1, 'HelloWorld', '[A-Z][a-z]+'),
- (2, 'apple123', '[a-z]{5}[0-9]'),
- (3, 'aabbcc', '(aa|bb|cc)'),
- (4, '123-456-7890', '[0-9][0-9][0-9]'),
- (5, 'test,data', ','),
- (6, 'a1b2c3', '[a-z][0-9]'),
- (7, 'book keeper', 'oo|ee'),
- (8, 'ababab', '(ab)(ab)(ab)'),
- (9, 'aabbcc', '(aa|bb|cc)'),
- (10, 'apple,banana', '[aeiou][a-z]+');
-
-SELECT id, regexp_count(text_data, pattern) as count_result FROM
test_table_for_regexp_count ORDER BY id;
-
-```
-
-```text
-+------+--------------+
-| id | count_result |
-+------+--------------+
-| 1 | 2 |
-| 2 | 1 |
-| 3 | 3 |
-| 4 | 3 |
-| 5 | 1 |
-| 6 | 3 |
-| 7 | 2 |
-| 8 | 1 |
-| 9 | 3 |
-| 10 | 2 |
-+------+--------------+
-
-```
-The return result of inserting certain variable values, retrieving the
variables from stored rows for matching, with the regular expression being a
constant.
-
-```sql
-CREATE TABLE test_table_for_regexp_count (
- id INT,
- text_data VARCHAR(500),
- pattern VARCHAR(100)
- ) PROPERTIES ("replication_num"="1");
-
-INSERT INTO test_table_for_regexp_count VALUES
- (1, 'HelloWorld', '[A-Z][a-z]+'),
- (2, 'apple123', '[a-z]{5}[0-9]'),
- (3, 'aabbcc', '(aa|bb|cc)'),
- (4, '123-456-7890', '[0-9][0-9][0-9]'),
- (5, 'test,data', ','),
- (6, 'a1b2c3', '[a-z][0-9]'),
- (7, 'book keeper', 'oo|ee'),
- (8, 'ababab', '(ab)(ab)(ab)'),
- (9, 'aabbcc', '(aa|bb|cc)'),
- (10, 'apple,banana', '[aeiou][a-z]+');
-
-SELECT id, regexp_count(text_data, 'e') as count_e FROM
test_table_for_regexp_count WHERE text_data IS NOT NULL ORDER BY id;
-```
-
-```text
-+------+---------+
-| id | count_e |
-+------+---------+
-| 1 | 1 |
-| 2 | 1 |
-| 3 | 0 |
-| 4 | 0 |
-| 5 | 1 |
-| 6 | 0 |
-| 7 | 3 |
-| 8 | 0 |
-| 9 | 0 |
-| 10 | 1 |
-+------+---------+
-```
-
-Emoji regexp count
-
-```sql
-SELECT regexp_count('🍔🍟🍕🌍', '🍔|🍟|🍕');
-```
-
-```text
-+----------------------------------------------------+
-| regexp_count('🍔🍟🍕🌍', '🍔|🍟|🍕') |
-+----------------------------------------------------+
-| 3 |
-+----------------------------------------------------+
-```
-
-If the 'pattern' is not allowed the regexp regular, thorw error
-
-```sql
-
-SELECT regexp_count('Hello, World!', '[[:punct:');
-```
-
-```text
-
-ERROR 1105 (HY000): errCode = 2, detailMessage =
(10.16.10.2)[INVALID_ARGUMENT]Could not compile regexp pattern: [[:punct:
-Error: missing ]: [[:punct:
-```
\ No newline at end of file
diff --git a/versioned_sidebars/version-3.x-sidebars.json
b/versioned_sidebars/version-3.x-sidebars.json
index 9233c641a07..80e70053e08 100644
--- a/versioned_sidebars/version-3.x-sidebars.json
+++ b/versioned_sidebars/version-3.x-sidebars.json
@@ -1264,7 +1264,6 @@
"sql-manual/sql-functions/scalar-functions/string-functions/url-encode",
"sql-manual/sql-functions/scalar-functions/string-functions/uuid",
"sql-manual/sql-functions/scalar-functions/string-functions/xpath-string",
-
"sql-manual/sql-functions/scalar-functions/string-functions/regexp-count",
"sql-manual/sql-functions/scalar-functions/string-functions/week-ceil",
"sql-manual/sql-functions/scalar-functions/string-functions/week-floor"
]
@@ -1406,7 +1405,6 @@
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/md5sum",
"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/sha",
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sha2",
"sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sm3",
@@ -1720,7 +1718,6 @@
"sql-manual/sql-functions/aggregate-functions/hll-union-agg",
"sql-manual/sql-functions/aggregate-functions/intersect-count",
"sql-manual/sql-functions/aggregate-functions/kurt",
-
"sql-manual/sql-functions/aggregate-functions/linear-histogram",
"sql-manual/sql-functions/aggregate-functions/map-agg",
"sql-manual/sql-functions/aggregate-functions/max",
"sql-manual/sql-functions/aggregate-functions/max-by",
@@ -1731,8 +1728,6 @@
"sql-manual/sql-functions/aggregate-functions/percentile-array",
"sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted",
"sql-manual/sql-functions/aggregate-functions/quantile-union",
-
"sql-manual/sql-functions/aggregate-functions/regr_intercept",
-
"sql-manual/sql-functions/aggregate-functions/regr_slope",
"sql-manual/sql-functions/aggregate-functions/retention",
"sql-manual/sql-functions/aggregate-functions/sequence-count",
"sql-manual/sql-functions/aggregate-functions/sequence-match",
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
