This is an automated email from the ASF dual-hosted git repository.
luzhijing pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 3a7bc3a7a8 [doc](retention) optimize retention doc (#19692)
3a7bc3a7a8 is described below
commit 3a7bc3a7a825fd3a72111126d47a5408397556c6
Author: abmdocrt <[email protected]>
AuthorDate: Wed May 17 08:17:45 2023 +0800
[doc](retention) optimize retention doc (#19692)
---
.../en/docs/sql-manual/sql-functions/aggregate-functions/retention.md | 4 +++-
.../docs/sql-manual/sql-functions/aggregate-functions/retention.md | 4 +++-
2 files changed, 6 insertions(+), 2 deletions(-)
diff --git
a/docs/en/docs/sql-manual/sql-functions/aggregate-functions/retention.md
b/docs/en/docs/sql-manual/sql-functions/aggregate-functions/retention.md
index 3811ec31cb..2c6fbd865c 100644
--- a/docs/en/docs/sql-manual/sql-functions/aggregate-functions/retention.md
+++ b/docs/en/docs/sql-manual/sql-functions/aggregate-functions/retention.md
@@ -41,13 +41,15 @@ The `retention` function takes as arguments a set of
conditions from 1 to 32 arg
The conditions, except the first, apply in pairs: the result of the second
will be true if the first and second are true, of the third if the first and
third are true, etc.
+To put it simply, the first digit of the return value array indicates whether
`event1` is true or false, the second digit represents the truth and falseness
of `event1` and `event2`, and the third digit represents whether `event1` is
true or false and `event3` is true False and, and so on. If `event1` is false,
return an array full of zeros.
+
#### Arguments
`event` — An expression that returns a `UInt8` result (1 or 0).
##### Returned value
-The array of 1 or 0.
+An array of 1s and 0s with a maximum length of 32 bits, the final output array
has the same length as the input parameter.
1 — Condition was met for the event.
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/aggregate-functions/retention.md
b/docs/zh-CN/docs/sql-manual/sql-functions/aggregate-functions/retention.md
index b52ff48667..e6d9bcf6b9 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/aggregate-functions/retention.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/aggregate-functions/retention.md
@@ -41,13 +41,15 @@ RETENTION
除了第一个以外，条件成对适用：如果第一个和第二个是真的，第二个结果将是真的，如果第一个和第三个是真的，第三个结果将是真的，等等。
+简单来讲，返回值数组第1位表示`event1`的真假，第二位表示`event1`真假与`event2`真假相与，第三位表示`event1`真假与`event3`真假相与，等等。如果`event1`为假，则返回全是0的数组。
+
#### Arguments
`event` — 返回`UInt8`结果（1或0）的表达式.
##### Returned value
-由1和0组成的数组。
+由1和0组成的最大长度为32位的数组，最终输出数组的长度与输入参数长度相同。
1 — 条件满足。
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
