This is an automated email from the ASF dual-hosted git repository.
morningman 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 bf907e4a316 [doc](function) add some value notice in
percentile_approx_weighted function (#1053)
bf907e4a316 is described below
commit bf907e4a316e24c2e017bfa782433acb57901362
Author: zhangstar333 <[email protected]>
AuthorDate: Sun Sep 1 23:27:44 2024 +0800
[doc](function) add some value notice in percentile_approx_weighted
function (#1053)
---
.../percentile_approx_weighted.md | 1 +
.../percentile_approx_weighted.md | 3 +-
.../percentile-approx-weighted.md | 0
.../percentile-approx-weighted.md | 1 +
.../percentile-approx-weighted.md | 58 ----------------------
.../percentile-approx-weighted.md | 2 +-
versioned_sidebars/version-2.1-sidebars.json | 1 -
7 files changed, 5 insertions(+), 61 deletions(-)
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 fe142588ca4..3f34ac63512 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
@@ -32,6 +32,7 @@ under the License.
The function is similar to PERCENTILE_APPROX, with the only difference being
an additional parameter w, which represents the number of times expr appears.
+Note that the value of parameter W needs to be greater than 0. If the value of
a row is less than or equal to 0 during the calculation process, the current
row will be skipped.
### example
```
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 97bbe0b1e5a..d0be60786aa 100755
---
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
@@ -31,7 +31,8 @@ under the License.
`PERCENTILE_APPROX_WEIGHTED(expr, w ,DOUBLE p [, DOUBLE compression])`
-该函数和PERCENTILE_APPROX类似，唯一的区别是多了一个参数w，用来表示expr出现的次数。
+该函数和 PERCENTILE_APPROX 类似，唯一的区别是多了一个参数 w，用来表示 expr 出现的次数。
+注意参数 W 的取值需要大于0，如果计算过程中某一行的取值小于等于0时，则会跳过当前行。
### example
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx-weighted.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx-weighted.md
old mode 100755
new mode 100644
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 badfad066c7..7a7b57fea1f 100755
---
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
@@ -32,6 +32,7 @@ under the License.
该函数和 PERCENTILE_APPROX 类似，唯一的区别是多了一个参数 w，用来表示 expr 出现的次数。
+注意参数 W 的取值需要大于0，如果计算过程中某一行的取值小于等于0时，则会跳过当前行。
## Example
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx-weighted.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx-weighted.md
deleted file mode 100644
index fe142588ca4..00000000000
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/percentile-approx-weighted.md
+++ /dev/null
@@ -1,58 +0,0 @@
----
-{
- "title": "PERCENTILE_APPROX_WEIGHTED",
- "language": "zh-CN"
-}
----
-
-<!--
-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.
--->
-
-## PERCENTILE_APPROX_WEIGHTED
-### description
-#### Syntax
-
-`PERCENTILE_APPROX_WEIGHTED(expr, w ,DOUBLE p [, DOUBLE compression])`
-
-
-The function is similar to PERCENTILE_APPROX, with the only difference being
an additional parameter w, which represents the number of times expr appears.
-
-### example
-```
-mysql >select * from quantile_weighted_table order by k;
-+------+------+
-| k | w |
-+------+------+
-| 1 | 2 |
-| 3 | 1 |
-| 5 | 2 |
-+------+------+
-
-
-mysql >select percentile_approx_weighted(k,w,0.55) from
quantile_weighted_table;
-+----------------------------------------------------------------------------------------+
-| percentile_approx_weighted(cast(k as DOUBLE), cast(w as DOUBLE), cast(0.55
as DOUBLE)) |
-+----------------------------------------------------------------------------------------+
-|
3.3333332538604736 |
-+----------------------------------------------------------------------------------------+
-
-```
-
-### keywords
-PERCENTILE_APPROX,PERCENTILE,APPROX,PERCENTILE_APPROX_WEIGHTED
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 fe142588ca4..9dcb1c2edab 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
@@ -32,7 +32,7 @@ under the License.
The function is similar to PERCENTILE_APPROX, with the only difference being
an additional parameter w, which represents the number of times expr appears.
-
+Note that the value of parameter W needs to be greater than 0. If the value of
a row is less than or equal to 0 during the calculation process, the current
row will be skipped.
### example
```
mysql >select * from quantile_weighted_table order by k;
diff --git a/versioned_sidebars/version-2.1-sidebars.json
b/versioned_sidebars/version-2.1-sidebars.json
index c717e3057b1..b245a57ab8a 100644
--- a/versioned_sidebars/version-2.1-sidebars.json
+++ b/versioned_sidebars/version-2.1-sidebars.json
@@ -844,7 +844,6 @@
"sql-manual/sql-functions/aggregate-functions/percentile",
"sql-manual/sql-functions/aggregate-functions/percentile-array",
"sql-manual/sql-functions/aggregate-functions/percentile-approx",
-
"sql-manual/sql-functions/aggregate-functions/percentile-approx-weighted",
"sql-manual/sql-functions/aggregate-functions/histogram",
"sql-manual/sql-functions/aggregate-functions/group-array-intersect",
"sql-manual/sql-functions/aggregate-functions/group-bitmap-xor",
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
