This is an automated email from the ASF dual-hosted git repository. panxiaolei pushed a commit to branch fix_0626 in repository https://gitbox.apache.org/repos/asf/doris-website.git
commit 8adfa4d6307a8918c9da77f031a24ced83590b38 Author: BiteTheDDDDt <[email protected]> AuthorDate: Thu Jun 26 14:51:31 2025 +0800 fix wrong describe about PERCENTILE_APPROX --- .../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 e0810d31d90..9343eb8c4c0 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/percentile-approx.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/percentile-approx.md @@ -26,8 +26,8 @@ under the License. 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 56aa8965c70..1e1826a62ef 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 @@ -28,7 +28,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 091f30c0729..eeb79654c51 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 @@ -26,8 +26,8 @@ under the License. `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 9503561ec0f..c823de97ed7 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 @@ -28,7 +28,7 @@ under the License. 主要特点： 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 573dbcf572b..8f0dcb210bb 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 @@ -36,7 +36,7 @@ under the License. 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 573dbcf572b..8f0dcb210bb 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 @@ -36,7 +36,7 @@ under the License. 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 091f30c0729..4929bf94501 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 @@ -26,8 +26,8 @@ under the License. `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 091f30c0729..4929bf94501 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 @@ -26,8 +26,8 @@ under the License. `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 9503561ec0f..c823de97ed7 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 @@ -28,7 +28,7 @@ under the License. 主要特点： 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 e0810d31d90..9343eb8c4c0 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 @@ -26,8 +26,8 @@ under the License. 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 e0810d31d90..9343eb8c4c0 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 @@ -26,8 +26,8 @@ under the License. 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 56aa8965c70..1e1826a62ef 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 @@ -28,7 +28,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]
