This is an automated email from the ASF dual-hosted git repository. panxiaolei pushed a commit to branch dev_0826 in repository https://gitbox.apache.org/repos/asf/doris-website.git
commit f7b5ca1129f5e3e412a25626d5bb4a17cbcc549a Author: BiteTheDDDDt <[email protected]> AuthorDate: Tue Aug 26 17:46:37 2025 +0800 update retention/sequence series/skew/stddev series/var series/sum series doc --- .../sql-functions/aggregate-functions/retention.md | 15 ++++++--------- .../aggregate-functions/sequence-count.md | 7 ++++--- .../aggregate-functions/sequence-match.md | 9 +++++---- .../sql-functions/aggregate-functions/skew.md | 8 +++++--- .../sql-functions/aggregate-functions/stddev-samp.md | 5 +++-- .../sql-functions/aggregate-functions/stddev.md | 5 +++-- .../sql-functions/aggregate-functions/sum.md | 3 ++- .../sql-functions/aggregate-functions/sum0.md | 2 +- .../sql-functions/aggregate-functions/var-samp.md | 5 +++-- .../sql-functions/aggregate-functions/variance.md | 5 +++-- .../sql-functions/aggregate-functions/retention.md | 18 +++++++++--------- .../aggregate-functions/sequence-count.md | 8 +++++--- .../aggregate-functions/sequence-match.md | 8 +++++--- .../sql-functions/aggregate-functions/skew.md | 8 +++++--- .../sql-functions/aggregate-functions/stddev-samp.md | 5 +++-- .../sql-functions/aggregate-functions/stddev.md | 5 +++-- .../sql-functions/aggregate-functions/sum.md | 4 ++-- .../sql-functions/aggregate-functions/sum0.md | 2 +- .../sql-functions/aggregate-functions/var-samp.md | 5 +++-- .../sql-functions/aggregate-functions/variance.md | 5 +++-- .../sql-functions/aggregate-functions/window-funnel.md | 10 +++++----- 21 files changed, 79 insertions(+), 63 deletions(-) diff --git a/docs/sql-manual/sql-functions/aggregate-functions/retention.md b/docs/sql-manual/sql-functions/aggregate-functions/retention.md index df0af61e7a8..dee027d6188 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/retention.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/retention.md @@ -7,11 +7,11 @@ ## Description -The `retention` function takes as arguments a set of conditions from 1 to 32 arguments of type `UInt8` that indicate whether a certain condition was met for the event. Any condition can be specified as an argument. +The `retention` function takes as arguments a set of conditions from 1 to 32 arguments of type Bool that indicate whether a certain condition was met for the event. Any condition can be specified as an argument. 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 `event_1` is true or false, the second digit represents the truth and falseness of `event_1` and `event_2`, and the third digit represents whether `event_1` is true or false and `event_3` is true False and, and so on. If `event_1` is false, return an array full of zeros. +To put it simply, the first digit of the return value array indicates whether `event_1` is true or false, the second digit represents the truth and falseness of `event_1` and `event_2`, and the third digit represents whether `event_1` is true or false and `event_3` is true or false, and so on. If `event_1` is false, return an array full of false. ## Syntax @@ -23,17 +23,14 @@ RETENTION(<event_1> [, <event_2>, ... , <event_n>]); | Parameter | Description | | -- | -- | -| `<event_n>` | The `n`th event condition, of type `UInt8` and value 1 or 0. | +| `<event_n>` | The `n`th event condition, type Bool. | ## Returned value -- 1: Condition is met. -- 0: Condition is not met. - -An array of 1 and 0 with a maximum length of 32, where the final output array length matches the input parameter length. +- true: Condition is met. +- false: Condition is not met. +An array of Bool with a maximum length of 32, where the final output array length matches the input parameter length. If no data is involved in the aggregation, a NULL value will be returned. - When multiple columns are involved in a calculation, if any column contains a NULL value, the current row with the NULL value will not participate in the aggregate calculation and will be directly discarded. - You can use the IFNULL function on the calculation column to handle NULL values. For details, refer to the subsequent examples. ## Examples diff --git a/docs/sql-manual/sql-functions/aggregate-functions/sequence-count.md b/docs/sql-manual/sql-functions/aggregate-functions/sequence-count.md index 6f6bd4f3440..2ef7940b1d7 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/sequence-count.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/sequence-count.md @@ -23,9 +23,9 @@ SEQUENCE_COUNT(<pattern>, <timestamp>, <cond_1> [, <cond_2>, ..., <cond_n>]); | Parameter | Description | | -- | -- | -| `<pattern>` | Pattern string, see **Pattern syntax** below. | -| `<timestamp>` | Column considered to contain time data. Typical data types are `Date` and `DateTime`. You can also use any of the supported UInt data types. | -| `<cond_n>` | Conditions that describe the chain of events. Data type: `UInt8`. You can pass up to 32 condition arguments. The function takes only the events described in these conditions into account. If the sequence contains data that isn’t described in a condition, the function skips them. | +| `<pattern>` | Pattern string, see **Pattern syntax** below. Supports type String. | +| `<timestamp>` | Column considered to contain time data. Supports type Date, DateTime. | +| `<cond_n>` | Conditions that describe the chain of events. Supports type Bool. Up to 32 condition arguments can be passed. The function takes only the events described in these conditions into account. If the sequence contains data that isnt described in a condition, the function skips them. | **Pattern syntax** @@ -41,6 +41,7 @@ SEQUENCE_COUNT(<pattern>, <timestamp>, <cond_1> [, <cond_2>, ..., <cond_n>]); ## Return Value Number of non-overlapping event chains that are matched. +If there is no valid data in the group, returns 0. ## Examples diff --git a/docs/sql-manual/sql-functions/aggregate-functions/sequence-match.md b/docs/sql-manual/sql-functions/aggregate-functions/sequence-match.md index ff1e1711643..f6c4b86ead4 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/sequence-match.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/sequence-match.md @@ -24,9 +24,9 @@ SEQUENCE_MATCH(<pattern>, <timestamp>, <cond_1> [, <cond_2>, ..., <cond_n>]) | Parameter | Description | | -- | -- | -| `<pattern>` | Pattern string. See **Pattern syntax** below. | -| `<timestamp>` | Column considered to contain time data. Typical data types are `Date` and `DateTime`. You can also use any of the supported UInt data types. | -| `<cond_n>` | Conditions that describe the chain of events. Data type: `UInt8`. You can pass up to 32 condition arguments. The function takes only the events described in these conditions into account. If the sequence contains data that isn’t described in a condition, the function skips them. | +| `<pattern>` | Pattern string. See **Pattern syntax** below. Supports type String. | +| `<timestamp>` | Column considered to contain time data. Supports type Date, DateTime. | +| `<cond_n>` | Conditions that describe the chain of events. Supports type Bool. Up to 32 condition arguments can be passed. The function takes only the events described in these conditions into account. If the sequence contains data that isnt described in a condition, the function skips them. | **Pattern syntax** @@ -42,7 +42,8 @@ SEQUENCE_MATCH(<pattern>, <timestamp>, <cond_1> [, <cond_2>, ..., <cond_n>]) 1: if the pattern is matched. -0: if the pattern isn’t matched. +0: if the pattern isnt matched. +If there is no valid data in the group, returns NULL. ## Examples diff --git a/docs/sql-manual/sql-functions/aggregate-functions/skew.md b/docs/sql-manual/sql-functions/aggregate-functions/skew.md index 28f1a4214aa..28ab86e3a7c 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/skew.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/skew.md @@ -8,7 +8,7 @@ ## Description Returns the [skewness](https://en.wikipedia.org/wiki/Skewness) of the expr expression. -The forumula used for this function is `3-th centrol moment / ((variance)^{1.5})`, when variance is zero, `SKEWNESS` will return `NULL`. +The formula used for this function is `3rd central moment / ((variance)^{1.5})`. **Related Commands** @@ -29,11 +29,13 @@ SKEWNESS(<col>) | Parameter | Description | | -- | -- | -| `<col>` | The column to be calculated skewness | +| `<col>` | The column to be calculated skewness, supports type Double. | ## Return Value -Returns the skewness of the expr expression, which is a `Double` type. +Returns the skewness of the expr expression, which is a Double type. +If variance is zero, returns NULL. +If there is no valid data in the group, returns NULL. ## Examples ```sql diff --git a/docs/sql-manual/sql-functions/aggregate-functions/stddev-samp.md b/docs/sql-manual/sql-functions/aggregate-functions/stddev-samp.md index 1966a74286b..a5845dba73b 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/stddev-samp.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/stddev-samp.md @@ -19,11 +19,12 @@ STDDEV_SAMP(<expr>) | Parameter | Description | | -- | -- | -| `<expr>` | The value to be calculated standard deviation | +| `<expr>` | The value to be calculated standard deviation, supports type Double. | ## Return Value -Return the sample standard deviation of the expr expression +Return the sample standard deviation of the expr expression as Double type. +If there is no valid data in the group, returns NULL. ### Examples ```sql diff --git a/docs/sql-manual/sql-functions/aggregate-functions/stddev.md b/docs/sql-manual/sql-functions/aggregate-functions/stddev.md index 6f0acb174e0..a6aea1eb6e5 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/stddev.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/stddev.md @@ -24,11 +24,12 @@ STDDEV(<expr>) | Parameter | Description | | -- | -- | -| `<expr>` | The value to be calculated standard deviation, support all numeric type | +| `<expr>` | The value to be calculated standard deviation, supports type Double. | ## Return Value -Return the standard deviation of the expr expression +Return the sample standard deviation of the expr expression as Double type. +If there is no valid data in the group, returns NULL. ## Examples ```sql diff --git a/docs/sql-manual/sql-functions/aggregate-functions/sum.md b/docs/sql-manual/sql-functions/aggregate-functions/sum.md index d4d7efa164d..86566367014 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/sum.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/sum.md @@ -19,11 +19,12 @@ SUM(<expr>) | Parameter | Description | | --- | --- | -| `<expr>` | The field to calculate the sum of | +| `<expr>` | The field to calculate the sum of, supports type Double, Float, Decimal, LargeInt, BigInt, Integer, SmallInt, TinyInt. | ## Return Value Return the sum of all values of the selected field. +If there is no valid data in the group, returns NULL. ## Examples ```sql diff --git a/docs/sql-manual/sql-functions/aggregate-functions/sum0.md b/docs/sql-manual/sql-functions/aggregate-functions/sum0.md index 0891f381d1e..72f326c8bef 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/sum0.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/sum0.md @@ -19,7 +19,7 @@ SUM0(<expr>) | Parameter | Description | | -- | -- | -| `<expr>` | The field to calculate the sum of | +| `<expr>` | The field to calculate the sum of, supports type Double, Float, Decimal, LargeInt, BigInt, Integer, SmallInt, TinyInt. | ## Return Value diff --git a/docs/sql-manual/sql-functions/aggregate-functions/var-samp.md b/docs/sql-manual/sql-functions/aggregate-functions/var-samp.md index 76df5fcafdd..19e05042b58 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/var-samp.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/var-samp.md @@ -23,10 +23,11 @@ VAR_SAMP(<expr>) | Parameter | Description | | -- | -- | -| `<expr>` | The column or expression to calculate sample variance for. Must be numeric type | +| `<expr>` | The column or expression to calculate sample variance for, supports type Double. | ## Return Value -Returns a DOUBLE value representing the calculated sample variance. +Returns a Double value representing the calculated sample variance. +If there is no valid data in the group, returns NULL. ## Examples ```sql diff --git a/docs/sql-manual/sql-functions/aggregate-functions/variance.md b/docs/sql-manual/sql-functions/aggregate-functions/variance.md index 1aa9e17c084..624b34c47cc 100644 --- a/docs/sql-manual/sql-functions/aggregate-functions/variance.md +++ b/docs/sql-manual/sql-functions/aggregate-functions/variance.md @@ -23,10 +23,11 @@ VARIANCE(<expr>) ## Parameters | Parameter | Description | | -- | -- | -| `<expr>` | The column or expression to calculate variance for. Must be numeric type | +| `<expr>` | The column or expression to calculate variance for, supports type Double. | ## Return Value -Returns a DOUBLE value representing the calculated variance. +Returns a Double value representing the calculated variance. +If there is no valid data in the group, returns NULL. ## Examples ```sql diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/retention.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/retention.md index 576e28e5135..a440ed51f9c 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/retention.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/retention.md @@ -7,11 +7,11 @@ ## 描述 -留存函数将一组条件作为参数，类型为 1 到 32 个`UInt8`类型的参数，用来表示事件是否满足特定条件。任何条件都可以指定为参数。 +留存函数将一组条件作为参数，类型为 1 到 32 个 Bool 类型的参数，用来表示事件是否满足特定条件。任何条件都可以指定为参数。 除了第一个以外，条件成对适用：如果第一个和第二个是真的，第二个结果将是真的，如果第一个和第三个是真的，第三个结果将是真的，等等。 -简单来讲，返回值数组第 1 位表示`event_1`的真假，第二位表示`event_1`真假与`event_2`真假相与，第三位表示`event_1`真假与`event_3`真假相与，等等。如果`event_1`为假，则返回全是 0 的数组。 +简单来讲，返回值数组第 1 位表示`event_1`的真假，第二位表示`event_1`真假与`event_2`真假相与，第三位表示`event_1`真假与`event_3`真假相与，等等。如果`event_1`为假，则返回全是 false 的数组。 ## 语法 @@ -23,15 +23,15 @@ RETENTION(<event_1> [, <event_2>, ... , <event_n>]); | 参数 | 说明 | | -- | -- | -| `<event_n>` | 第`n`个事件条件，类型为`UInt8`，取值为 1 或 0 | +| `<event_n>` | 第`n`个事件条件，支持类型为 Bool。 | ## 返回值 -- 1: 条件满足。 -- 0: 条件不满足。 -由 1 和 0 组成的最大长度为 32 位的数组，最终输出数组的长度与输入参数长度相同。 -如果在没有任何数据参与聚合的情况下，会返回NULL值 -当有多个列参与计算时，如果任意一列出现了NULL值，则NULL值的当前行不会参与聚合计算，被直接丢弃 -可以在计算列上加IF NULL函数处理NULL值，详情见后续示例。 +- true: 条件满足。 +- false: 条件不满足。 +由 Bool 组成的最大长度为 32 位的数组，最终输出数组的长度与输入参数长度相同。 +如果在没有任何数据参与聚合的情况下，会返回 NULL 值。 +当有多个列参与计算时，如果任意一列出现了 NULL 值，则 NULL 值的当前行不会参与聚合计算，被直接丢弃。 +可以在计算列上加 IFNULL 函数处理 NULL值 ，详情见后续示例。 ## 举例 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sequence-count.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sequence-count.md index 5819db5b17b..6163c9267df 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sequence-count.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sequence-count.md @@ -23,9 +23,9 @@ SEQUENCE_COUNT(<pattern>, <timestamp>, <cond_1> [, <cond_2>, ..., <cond_n>]); | 参数 | 说明 | | -- | -- | -| `<pattern>` | 模式字符串，可参考下面的**模式语法** | -| `<timestamp>` | 包含时间的列。典型的时间类型是： `Date` 和 `DateTime`。也可以使用任何支持的 `UInt` 数据类型。 | -| `<cond_n>` | 事件链的约束条件。数据类型是： `UInt8`。最多可以传递 32 个条件参数。该函数只考虑这些条件中描述的事件。如果序列包含未在条件中描述的数据，则函数将跳过这些数据 | +| `<pattern>` | 模式字符串，可参考下面的**模式语法**。支持类型为 String。 | +| `<timestamp>` | 包含时间的列。支持类型为Date，DateTime。| +| `<cond_n>` | 事件链的约束条件。支持类型为 Bool。最多可以传递 32 个条件参数。该函数只考虑这些条件中描述的事件。如果序列包含未在条件中描述的数据，则函数将跳过这些数据。 | **模式语法** @@ -41,6 +41,8 @@ SEQUENCE_COUNT(<pattern>, <timestamp>, <cond_1> [, <cond_2>, ..., <cond_n>]); 匹配的非重叠事件链数。 +如果组内没有合法数据，则返回0。 + ## 举例 **匹配例子** diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sequence-match.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sequence-match.md index 2ae11d659f1..d8c4394b0d3 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sequence-match.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sequence-match.md @@ -22,9 +22,9 @@ SEQUENCE_MATCH(<pattern>, <timestamp>, <cond_1> [, <cond_2>, ..., <cond_n>]) | 参数 | 说明 | | -- | -- | -| `<pattern>` | 模式字符串，可参考下面的**模式语法** | -| `<timestamp>` | 包含时间的列。典型的时间类型是： `Date` 和 `DateTime`。也可以使用任何支持的 `UInt` 数据类型。 | -| `<cond_n>` | 事件链的约束条件。数据类型是： `UInt8`。最多可以传递 32 个条件参数。该函数只考虑这些条件中描述的事件。如果序列包含未在条件中描述的数据，则函数将跳过这些数据。 | +| `<pattern>` | 模式字符串，可参考下面的**模式语法**。支持类型为 String。 | +| `<timestamp>` | 包含时间的列。支持类型为Date，DateTime。| +| `<cond_n>` | 事件链的约束条件。支持类型为 Bool。最多可以传递 32 个条件参数。该函数只考虑这些条件中描述的事件。如果序列包含未在条件中描述的数据，则函数将跳过这些数据。 | **模式语法** @@ -44,6 +44,8 @@ SEQUENCE_MATCH(<pattern>, <timestamp>, <cond_1> [, <cond_2>, ..., <cond_n>]) 0：模式不匹配。 +如果组内没有合法数据，则返回 NULL 。 + ## 举例 **匹配例子** diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/skew.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/skew.md index 138f59123b6..47acd1fc2cb 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/skew.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/skew.md @@ -8,7 +8,7 @@ ## 描述 返回表达式的 [斜度](https://en.wikipedia.org/wiki/Skewness)。 -用来计算斜度的公式是 `3阶中心矩 / ((方差)^{1.5})`, 当方差为零时，`SKEWNESS` 会返回 `NULL`。 +用来计算斜度的公式是 `3阶中心矩 / ((方差)^{1.5})`。 **相关命令** @@ -29,11 +29,13 @@ SKEWNESS(<col>) | 参数 | 说明 | | -- | -- | -| `<col>` | 需要被计算斜度的列 | +| `<col>` | 需要被计算斜度的列，支持类型为 Double。 | ## 返回值 -返回表达式的斜度， `Double` 类型。 +返回 Double 类型的表达式的斜度。 +当方差为零时，返回 NULL。 +当组内没有合法数据时，返回 NULL。 ## 举例 ```sql diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/stddev-samp.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/stddev-samp.md index 83f9e49089c..d48accda682 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/stddev-samp.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/stddev-samp.md @@ -19,11 +19,12 @@ STDDEV_SAMP(<expr>) | 参数 | 说明 | | -- | -- | -| `<expr>` | 需要被计算标准差的值 | +| `<expr>` | 需要被计算标准差的值，支持类型为 Double。 | ## 返回值 -返回参数 expr 的样本标准差 +返回 Double 类型的参数 expr 的样本标准差。 +当组内没有合法数据时，返回 NULL。 ## 举例 ```sql diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/stddev.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/stddev.md index 63e1581eded..73683dd77f9 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/stddev.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/stddev.md @@ -24,11 +24,12 @@ STDDEV(<expr>) | 参数 | 说明 | | -- | -- | -| `<expr>` | 需要被计算标准差的值, 支持所有的数值类型 | +| `<expr>` | 需要被计算标准差的值，支持类型为 Double。 | ## 返回值 -返回参数 expr 的标准差 +返回 Double 类型的参数 expr 的样本标准差。 +当组内没有合法数据时，返回 NULL。 ## 举例 ```sql diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sum.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sum.md index 49a77a75f2e..7f879cab3d2 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sum.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sum.md @@ -16,14 +16,14 @@ SUM(<expr>) ``` ## 参数 - | 参数 | 说明 | | --- | --- | -| `<expr>` | 要计算和的字段 | +| `<expr>` | 要计算和的字段，支持类型为 Double，Float，Decimal，LargeInt，BigInt，Integer，SmallInt，TinyInt。 | ## 返回值 返回选中字段所有值的和。 +当组内没有合法数据时，返回 NULL。 ## 举例 ```sql diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sum0.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sum0.md index a17df3c462d..650bd5afa86 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sum0.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/sum0.md @@ -19,7 +19,7 @@ SUM0(<expr>) | 参数 | 说明 | | -- | -- | -| `<expr>` | 要计算和的字段 | +| `<expr>` | 要计算和的字段，支持类型为 Double，Float，Decimal，LargeInt，BigInt，Integer，SmallInt，TinyInt。 | ## 返回值 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/var-samp.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/var-samp.md index 1d17f4b6cd2..aeaa632ddfa 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/var-samp.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/var-samp.md @@ -23,10 +23,11 @@ VAR_SAMP(<expr>) | 参数 | 描述 | | -- | -- | -| `<expr>` | 要计算样本方差的列或表达式 | +| `<expr>` | 要计算样本方差的列或表达式，支持类型为 Double。 | ## 返回值 -返回一个 DOUBLE 类型的值，表示计算得到的样本方差。 +返回一个 Double 类型的值，表示计算得到的样本方差。 +组内没有合法数据时，返回 NULL。 ## 举例 ```sql diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/variance.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/variance.md index 6f68e4f95f2..2d57b2a09b4 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/variance.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/variance.md @@ -23,10 +23,11 @@ VARIANCE(<expr>) ## 参数 | 参数 | 说明 | | -- | -- | -| `<expr>` | 要计算方差的列或表达式 | +| `<expr>` | 要计算方差的列或表达式，支持类型为 Double。 | ## 返回值 -返回一个 DOUBLE 类型的值，表示计算得到的方差。 +返回一个 Double 类型的值，表示计算得到的方差。 +组内没有合法数据时，返回 NULL。 ## 举例 ```sql diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/window-funnel.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/window-funnel.md index 0120b12e2a0..0ae520454f7 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/window-funnel.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/window-funnel.md @@ -25,10 +25,10 @@ WINDOW_FUNNEL(<window>, <mode>, <timestamp>, <event_1>[, event_2, ... , event_n] | 参数 | 说明 | | -- | -- | -| `<window>` | 滑动时间窗口大小，单位为秒 | -| `<mode>` | 模式，共有四种模式，分别为`default`, `deduplication`, `fixed`, `increase`，详细请参见下面的**模式** | -| `<timestamp>` | 指定时间列，类型为 DATETIME, 滑动窗口沿着此列工作 | -| `<event_n>` | 表示事件的布尔表达式。 | +| `<window>` | 滑动时间窗口大小，单位为秒，支持类型为Bigint。 | +| `<mode>` | 模式，共有四种模式，分别为`default`, `deduplication`, `fixed`, `increase`，详细请参见下面的**模式**，支持类型为String。 | +| `<timestamp>` | 指定时间列，支持类型为 DATETIME, 滑动窗口沿着此列工作。 | +| `<event_n>` | 表示事件的布尔表达式，支持类型为 Bool。 | **模式** @@ -42,7 +42,7 @@ WINDOW_FUNNEL(<window>, <mode>, <timestamp>, <event_1>[, event_2, ... , event_n] ## 返回值 -返回一个整数，表示在指定时间窗口内完成的最大连续步骤数。 +返回一个整数，表示在指定时间窗口内完成的最大连续步骤数，类型为Integer。 ## 举例 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
