This is an automated email from the ASF dual-hosted git repository.
lihaopeng 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 0daa8e9713a [Doc] fix wrong description about PERCENTILE_APPROX (#2562)
0daa8e9713a is described below
commit 0daa8e9713aa524d0dce5d58f54e126f1fa7dc3e
Author: Pxl <[email protected]>
AuthorDate: Thu Jun 26 15:18:21 2025 +0800
[Doc] fix wrong description about PERCENTILE_APPROX (#2562)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../sql-manual/sql-functions/aggregate-functions/percentile-approx.md | 4 ++--
.../sql-functions/aggregate-functions/percentile_approx_weighted.md | 2 +-
.../sql-manual/sql-functions/aggregate-functions/percentile-approx.md | 4 ++--
.../sql-functions/aggregate-functions/percentile_approx_weighted.md | 2 +-
.../sql-manual/sql-functions/aggregate-functions/percentile-approx.md | 2 +-
.../sql-manual/sql-functions/aggregate-functions/percentile-approx.md | 2 +-
.../sql-manual/sql-functions/aggregate-functions/percentile-approx.md | 4 ++--
.../sql-manual/sql-functions/aggregate-functions/percentile-approx.md | 4 ++--
.../sql-functions/aggregate-functions/percentile_approx_weighted.md | 2 +-
.../sql-manual/sql-functions/aggregate-functions/percentile-approx.md | 4 ++--
.../sql-manual/sql-functions/aggregate-functions/percentile-approx.md | 4 ++--
.../sql-functions/aggregate-functions/percentile_approx_weighted.md | 2 +-
12 files changed, 18 insertions(+), 18 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
b/docs/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
index 041cea4c253..4d6c906cb4a 100644
--- a/docs/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
+++ b/docs/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
@@ -9,8 +9,8 @@
The `PERCENTILE_APPROX` function is used to calculate approximate percentiles,
primarily for large datasets. Compared to the `PERCENTILE` function, it has the
following features:
-1. Memory Efficiency: Uses fixed-size memory, maintaining low memory
consumption even when processing high-cardinality columns (large data volumes)
-2. Performance Advantage: Suitable for processing large-scale datasets with
faster computation
+1. Memory Efficiency: Uses fixed-size memory, maintaining low memory
consumption even when processing low-cardinality columns (large data volumes
but the number of different elements is small)
+2. Performance Advantage: Suitable for processing low-cardinality large-scale
datasets with faster computation
3. Adjustable Precision: Balance between precision and performance through the
compression parameter
diff --git
a/docs/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
b/docs/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
index a3c4687a382..00c63988968 100644
---
a/docs/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
+++
b/docs/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
@@ -11,7 +11,7 @@ The `PERCENTILE_APPROX_WEIGHTED` function calculates weighted
approximate percen
Key features:
1. Weight Support: Each value can be assigned a corresponding weight,
affecting the final percentile calculation
-2. Memory Efficiency: Uses fixed-size memory, suitable for processing
large-scale data
+2. Memory Efficiency: Uses fixed-size memory, maintaining low memory
consumption even when processing low-cardinality columns (large data volumes
but the number of different elements is small)
3. Adjustable Precision: Balance between precision and performance through the
compression parameter
## Syntax
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
index a83676bd6f7..a293e43e4a7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
@@ -9,8 +9,8 @@
`PERCENTILE_APPROX` 函数用于计算近似百分位数,主要用于大数据集的场景。与 `PERCENTILE` 函数相比,它具有以下特点:
-1. 内存效率:使用固定大小的内存,即使在处理高基数列(数据量很大)时也能保持较低的内存消耗
-2. 性能优势:适合处理大规模数据集,计算速度快
+1. 内存效率:使用固定大小的内存,即使在处理低基数列(数据量很大但不同元素数很少)时也能保持较低的内存消耗
+2. 性能优势:适合处理低基数大规模数据集,计算速度快
3. 精度可调:通过 compression 参数可以在精度和性能之间做平衡
## 语法
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
index c8decc682d6..6645967819b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
@@ -11,7 +11,7 @@
主要特点:
1. 支持权重:每个数值可以设置对应的权重,影响最终的百分位数计算
-2. 内存效率:使用固定大小的内存,适合处理大规模数据
+2. 内存效率:使用固定大小的内存,适合处理低基数大规模数据
3. 精度可调:通过 compression 参数平衡精度和性能
## 语法
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
index 3e23db90bf9..f8f4677e4e3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
@@ -17,7 +17,7 @@
compression参数是可选项,可设置范围是[2048, 10000],值越大,精度越高,内存消耗越大,计算耗时越长。
compression参数未指定或设置的值在[2048, 10000]范围外,以10000的默认值运行
-该函数使用固定大小的内存,因此对于高基数的列可以使用更少的内存,可用于计算tp99等统计值
+该函数使用固定大小的内存,因此对于低基数的列可以使用更少的内存,可用于计算tp99等统计值
## 举例
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
index 3e23db90bf9..f8f4677e4e3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
@@ -17,7 +17,7 @@
compression参数是可选项,可设置范围是[2048, 10000],值越大,精度越高,内存消耗越大,计算耗时越长。
compression参数未指定或设置的值在[2048, 10000]范围外,以10000的默认值运行
-该函数使用固定大小的内存,因此对于高基数的列可以使用更少的内存,可用于计算tp99等统计值
+该函数使用固定大小的内存,因此对于低基数的列可以使用更少的内存,可用于计算tp99等统计值
## 举例
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
index a83676bd6f7..0c0f58f02c4 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
@@ -9,8 +9,8 @@
`PERCENTILE_APPROX` 函数用于计算近似百分位数,主要用于大数据集的场景。与 `PERCENTILE` 函数相比,它具有以下特点:
-1. 内存效率:使用固定大小的内存,即使在处理高基数列(数据量很大)时也能保持较低的内存消耗
-2. 性能优势:适合处理大规模数据集,计算速度快
+1. 内存效率:使用固定大小的内存,即使在处理低基数列(不同元素数很少)时也能保持较低的内存消耗
+2. 性能优势:适合处理低基数大规模数据集,计算速度快
3. 精度可调:通过 compression 参数可以在精度和性能之间做平衡
## 语法
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
index a83676bd6f7..0c0f58f02c4 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
@@ -9,8 +9,8 @@
`PERCENTILE_APPROX` 函数用于计算近似百分位数,主要用于大数据集的场景。与 `PERCENTILE` 函数相比,它具有以下特点:
-1. 内存效率:使用固定大小的内存,即使在处理高基数列(数据量很大)时也能保持较低的内存消耗
-2. 性能优势:适合处理大规模数据集,计算速度快
+1. 内存效率:使用固定大小的内存,即使在处理低基数列(不同元素数很少)时也能保持较低的内存消耗
+2. 性能优势:适合处理低基数大规模数据集,计算速度快
3. 精度可调:通过 compression 参数可以在精度和性能之间做平衡
## 语法
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
index c8decc682d6..6645967819b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
@@ -11,7 +11,7 @@
主要特点:
1. 支持权重:每个数值可以设置对应的权重,影响最终的百分位数计算
-2. 内存效率:使用固定大小的内存,适合处理大规模数据
+2. 内存效率:使用固定大小的内存,适合处理低基数大规模数据
3. 精度可调:通过 compression 参数平衡精度和性能
## 语法
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
index 041cea4c253..4d6c906cb4a 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
@@ -9,8 +9,8 @@
The `PERCENTILE_APPROX` function is used to calculate approximate percentiles,
primarily for large datasets. Compared to the `PERCENTILE` function, it has the
following features:
-1. Memory Efficiency: Uses fixed-size memory, maintaining low memory
consumption even when processing high-cardinality columns (large data volumes)
-2. Performance Advantage: Suitable for processing large-scale datasets with
faster computation
+1. Memory Efficiency: Uses fixed-size memory, maintaining low memory
consumption even when processing low-cardinality columns (large data volumes
but the number of different elements is small)
+2. Performance Advantage: Suitable for processing low-cardinality large-scale
datasets with faster computation
3. Adjustable Precision: Balance between precision and performance through the
compression parameter
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
index 041cea4c253..4d6c906cb4a 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-approx.md
@@ -9,8 +9,8 @@
The `PERCENTILE_APPROX` function is used to calculate approximate percentiles,
primarily for large datasets. Compared to the `PERCENTILE` function, it has the
following features:
-1. Memory Efficiency: Uses fixed-size memory, maintaining low memory
consumption even when processing high-cardinality columns (large data volumes)
-2. Performance Advantage: Suitable for processing large-scale datasets with
faster computation
+1. Memory Efficiency: Uses fixed-size memory, maintaining low memory
consumption even when processing low-cardinality columns (large data volumes
but the number of different elements is small)
+2. Performance Advantage: Suitable for processing low-cardinality large-scale
datasets with faster computation
3. Adjustable Precision: Balance between precision and performance through the
compression parameter
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
index a3c4687a382..00c63988968 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile_approx_weighted.md
@@ -11,7 +11,7 @@ The `PERCENTILE_APPROX_WEIGHTED` function calculates weighted
approximate percen
Key features:
1. Weight Support: Each value can be assigned a corresponding weight,
affecting the final percentile calculation
-2. Memory Efficiency: Uses fixed-size memory, suitable for processing
large-scale data
+2. Memory Efficiency: Uses fixed-size memory, maintaining low memory
consumption even when processing low-cardinality columns (large data volumes
but the number of different elements is small)
3. Adjustable Precision: Balance between precision and performance through the
compression parameter
## Syntax
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]