This is an automated email from the ASF dual-hosted git repository.
kassiez 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 13b4769dbac [doc](percentile) update percentile/percentile_array doc
as now support more type (#1350)
13b4769dbac is described below
commit 13b4769dbacc379f402d51578954acd275f95dbc
Author: zhangstar333 <zhangs...@selectdb.com>
AuthorDate: Wed Nov 27 20:47:55 2024 +0800
[doc](percentile) update percentile/percentile_array doc as now support
more type (#1350)
# Versions
- [x] dev
- [x] 3.0
- [ ] 2.1
- [ ] 2.0
# Languages
- [x] Chinese
- [x] English
---
.../sql-functions/aggregate-functions/percentile-array.md | 2 +-
.../sql-functions/aggregate-functions/percentile-array.md | 2 +-
.../sql-functions/aggregate-functions/percentile-array.md | 6 +++++-
.../sql-manual/sql-functions/aggregate-functions/percentile.md | 4 ++++
.../sql-functions/aggregate-functions/percentile-array.md | 6 +++++-
.../sql-manual/sql-functions/aggregate-functions/percentile.md | 4 ++++
6 files changed, 20 insertions(+), 4 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/aggregate-functions/percentile-array.md
b/docs/sql-manual/sql-functions/aggregate-functions/percentile-array.md
index 6e23573721c..42c697a84e4 100644
--- a/docs/sql-manual/sql-functions/aggregate-functions/percentile-array.md
+++ b/docs/sql-manual/sql-functions/aggregate-functions/percentile-array.md
@@ -28,7 +28,7 @@ under the License.
### Description
#### Syntax
-`ARRAY_DOUBLE PERCENTILE_ARRAY(BIGINT, ARRAY_DOUBLE p)`
+`ARRAY_DOUBLE PERCENTILE_ARRAY(expr, ARRAY_DOUBLE p)`
Calculate exact percentiles, suitable for small data volumes. Sorts the
specified column in descending order first, then takes the exact pth percentile.
The return value is the result of sequentially taking the specified
percentages in the array p.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile-array.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile-array.md
index 6d5f0beedf2..f54c641f2ef 100755
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile-array.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/percentile-array.md
@@ -28,7 +28,7 @@ under the License.
### description
#### Syntax
-`ARRAY_DOUBLE PERCENTILE_ARRAY(BIGINT, ARRAY_DOUBLE p)`
+`ARRAY_DOUBLE PERCENTILE_ARRAY(expr, ARRAY_DOUBLE p)`
计算精确的百分位数，适用于小数据量。先对指定列降序排列，然后取精确的第 p 位百分数。
返回值为依次取数组p中指定的百分数组成的结果。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-array.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-array.md
index 6d5f0beedf2..f601f6af043 100755
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-array.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-array.md
@@ -28,7 +28,7 @@ under the License.
### description
#### Syntax
-`ARRAY_DOUBLE PERCENTILE_ARRAY(BIGINT, ARRAY_DOUBLE p)`
+`ARRAY_DOUBLE PERCENTILE_ARRAY(expr, ARRAY_DOUBLE p)`
计算精确的百分位数，适用于小数据量。先对指定列降序排列，然后取精确的第 p 位百分数。
返回值为依次取数组p中指定的百分数组成的结果。
@@ -36,6 +36,10 @@ under the License.
expr: 必填。值为整数（最大为bigint） 类型的列。
p: 需要精确的百分位数, 由常量组成的数组, 取值为 [0.0,1.0]。
+:::tip
+自 Doris 3.0.3 版本开始支持, expr 支持了更多的输入类型, eg: float, double. 支持浮点数据参与计算，减少了cast
数据的开销。
+:::
+
### example
```
mysql> select percentile_array(k1,[0.3,0.5,0.9]) from baseall;
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile.md
index f1ee79ff302..c643d402642 100755
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile.md
@@ -36,6 +36,10 @@ under the License.
`expr`：必填。值为整数（最大为 `bigint`） 类型的列。
`p`：常量，必填。需要精确的百分位数。取值为 `[0.0,1.0]`。
+:::tip
+自 Doris 3.0.3 版本开始支持, expr 支持了更多的输入类型, eg: float, double. 支持浮点数据参与计算，减少了cast
数据的开销。
+:::
+
### Example
```sql
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-array.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-array.md
index 6e23573721c..003ceb1847d 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-array.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile-array.md
@@ -28,7 +28,7 @@ under the License.
### Description
#### Syntax
-`ARRAY_DOUBLE PERCENTILE_ARRAY(BIGINT, ARRAY_DOUBLE p)`
+`ARRAY_DOUBLE PERCENTILE_ARRAY(expr, ARRAY_DOUBLE p)`
Calculate exact percentiles, suitable for small data volumes. Sorts the
specified column in descending order first, then takes the exact pth percentile.
The return value is the result of sequentially taking the specified
percentages in the array p.
@@ -36,6 +36,10 @@ Parameter Description:
expr: Required. Columns whose values are of type integer (up to bigint).
p: The exact percentile is required, an array of constants, taking the value
[0.0, 1.0].
+:::tip
+Since version Doris 3.0.3, expr supports more input types, such as float and
double. This enables floating-point data to participate in calculations,
reducing the overhead of casting data.
+:::
+
### example
```
mysql> select percentile_array(k1,[0.3,0.5,0.9]) from baseall;
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile.md
index 597736cceb4..ac1cde65500 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/aggregate-functions/percentile.md
@@ -36,6 +36,10 @@ Parameters:
`expr`: required. The value is an integer (`bigint` at most).
`p`: required. The const value is `[0.0,1.0]`.
+:::tip
+Since version Doris 3.0.3, expr supports more input types, such as float and
double. This enables floating-point data to participate in calculations,
reducing the overhead of casting data.
+:::
+
### Example
```sql
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
