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 378b0010212 [fix] correct typos / wrong examples / mislabeled params
in aggregate, AI, and array function docs (#3706)
378b0010212 is described below
commit 378b0010212668c90117142cc7cab1430a6c294c
Author: boluor <[email protected]>
AuthorDate: Wed May 20 09:00:22 2026 -0700
[fix] correct typos / wrong examples / mislabeled params in aggregate, AI,
and array function docs (#3706)
## Summary
Fixes 13 small documentation issues across the aggregate, AI, and array
function references. Each item below is independent.
- **stddev.md** — Return Value said *"sample standard deviation"*, but
`STDDEV` / `STDDEV_POP` compute the **population** standard deviation
(`STDDEV_SAMP` is the sample variant). Corrected the English and Chinese
copies.
- **inner-product-approximate.md / inner-product.md /
array-cross-product.md** — the Parameters table labeled the second-row
parameter as `\`<array1>\``. Changed to `\`<array2>\`` to match the
function signature.
- **inner-product-approximate.md** — the example query called
`L2_distance_approximate(embedding, ...)` (the function being documented
is `INNER_PRODUCT_APPROXIMATE`). Changed the call to
`inner_product_approximate(...)`.
- **ai-summarize.md / ai-translate.md** — typo `'resourse_name'` →
`'resource_name'`.
- **ai-classify.md** — sample label `'useage'` → `'usage'`.
- **array-avg.md** — the *"Array is NULL"* example called
`array_max(NULL)` (looked like a copy-paste from `array-max.md`).
Changed to `array_avg(NULL)`.
- **array-product.md** — example `array_product([1.1, 2.2, 3.3, 4.4,
5.5])` showed a result of `190.8`. The actual product is `193.2612`.
- **array-reverse-split.md / array-split.md** — result string
`[[1,[NULL,3]]` had mismatched brackets; corrected to `[[1, NULL, 3]]`.
- **array-union.md** — the result-table header for a 3-element query
(`ARRAY('hello', 'world', 'hello')`) showed only 2 elements. Header now
matches the query; ruler and right-edge padding widened to keep the
table aligned.
## Test plan
- [ ] CI doc build passes
- [ ] Spot-check that the affected function pages render correctly
(parameter tables in inner-product / inner-product-approximate /
array-cross-product, the corrected query in inner-product-approximate,
the fixed value in array-product, the corrected result strings in
array-reverse-split / array-split, and the realigned table in
array-union)
---
docs/sql-manual/sql-functions/aggregate-functions/stddev.md | 2 +-
docs/sql-manual/sql-functions/ai-functions/ai-classify.md | 2 +-
docs/sql-manual/sql-functions/ai-functions/ai-summarize.md | 2 +-
docs/sql-manual/sql-functions/ai-functions/ai-translate.md | 2 +-
.../distance-functions/inner-product-approximate.md | 4 ++--
.../ai-functions/distance-functions/inner-product.md | 2 +-
.../scalar-functions/array-functions/array-avg.md | 2 +-
.../scalar-functions/array-functions/array-cross-product.md | 2 +-
.../scalar-functions/array-functions/array-product.md | 2 +-
.../scalar-functions/array-functions/array-reverse-split.md | 2 +-
.../scalar-functions/array-functions/array-split.md | 2 +-
.../scalar-functions/array-functions/array-union.md | 10 +++++-----
.../sql-manual/sql-functions/aggregate-functions/stddev.md | 2 +-
.../sql-manual/sql-functions/ai-functions/ai-classify.md | 2 +-
.../sql-manual/sql-functions/ai-functions/ai-summarize.md | 2 +-
.../sql-manual/sql-functions/ai-functions/ai-translate.md | 2 +-
.../distance-functions/inner-product-approximate.md | 2 +-
.../scalar-functions/array-functions/array-product.md | 2 +-
.../scalar-functions/array-functions/array-reverse-split.md | 2 +-
.../scalar-functions/array-functions/array-split.md | 2 +-
.../scalar-functions/array-functions/array-union.md | 10 +++++-----
.../sql-manual/sql-functions/aggregate-functions/stddev.md | 2 +-
.../sql-manual/sql-functions/ai-functions/ai-classify.md | 2 +-
.../sql-manual/sql-functions/ai-functions/ai-summarize.md | 2 +-
.../sql-manual/sql-functions/ai-functions/ai-translate.md | 2 +-
.../distance-functions/inner-product-approximate.md | 2 +-
.../scalar-functions/array-functions/array-product.md | 2 +-
.../scalar-functions/array-functions/array-reverse-split.md | 2 +-
.../scalar-functions/array-functions/array-split.md | 2 +-
.../scalar-functions/array-functions/array-union.md | 10 +++++-----
.../sql-manual/sql-functions/aggregate-functions/stddev.md | 2 +-
.../sql-manual/sql-functions/ai-functions/ai-classify.md | 2 +-
.../sql-manual/sql-functions/ai-functions/ai-summarize.md | 2 +-
.../sql-manual/sql-functions/ai-functions/ai-translate.md | 2 +-
.../distance-functions/inner-product-approximate.md | 4 ++--
.../ai-functions/distance-functions/inner-product.md | 2 +-
.../scalar-functions/array-functions/array-avg.md | 2 +-
.../scalar-functions/array-functions/array-cross-product.md | 2 +-
.../scalar-functions/array-functions/array-product.md | 2 +-
.../scalar-functions/array-functions/array-reverse-split.md | 2 +-
.../scalar-functions/array-functions/array-split.md | 2 +-
.../scalar-functions/array-functions/array-union.md | 10 +++++-----
42 files changed, 60 insertions(+), 60 deletions(-)
diff --git a/docs/sql-manual/sql-functions/aggregate-functions/stddev.md
b/docs/sql-manual/sql-functions/aggregate-functions/stddev.md
index dfd98194d82..b5974776ec5 100644
--- a/docs/sql-manual/sql-functions/aggregate-functions/stddev.md
+++ b/docs/sql-manual/sql-functions/aggregate-functions/stddev.md
@@ -29,7 +29,7 @@ STDDEV(<expr>)
## Return Value
-Return the sample standard deviation of the expr expression as Double type.
+Return the population standard deviation of the expr expression as Double type.
If there is no valid data in the group, returns NULL.
## Examples
diff --git a/docs/sql-manual/sql-functions/ai-functions/ai-classify.md
b/docs/sql-manual/sql-functions/ai-functions/ai-classify.md
index 4afdfae9049..fda900d4c52 100644
--- a/docs/sql-manual/sql-functions/ai-functions/ai-classify.md
+++ b/docs/sql-manual/sql-functions/ai-functions/ai-classify.md
@@ -55,7 +55,7 @@ The result is generated by a large language model, so the
output may vary.
```sql
SET default_ai_resource = 'resource_name';
-SELECT AI_CLASSIFY('Apache Doris is a databases system.', ['useage',
'introduce']) AS Result;
+SELECT AI_CLASSIFY('Apache Doris is a databases system.', ['usage',
'introduce']) AS Result;
```
```text
+-----------+
diff --git a/docs/sql-manual/sql-functions/ai-functions/ai-summarize.md
b/docs/sql-manual/sql-functions/ai-functions/ai-summarize.md
index ddd7d6ca685..b1aee1a7fa0 100644
--- a/docs/sql-manual/sql-functions/ai-functions/ai-summarize.md
+++ b/docs/sql-manual/sql-functions/ai-functions/ai-summarize.md
@@ -65,7 +65,7 @@ SELECT AI_SUMMARIZE('Apache Doris is an MPP-based real-time
data warehouse known
```
```sql
-SELECT AI_SUMMARIZE('resourse_name','Doris supports high-concurrency,
real-time analytics and is widely used in business intelligence scenarios.') AS
Result;
+SELECT AI_SUMMARIZE('resource_name','Doris supports high-concurrency,
real-time analytics and is widely used in business intelligence scenarios.') AS
Result;
```
```text
diff --git a/docs/sql-manual/sql-functions/ai-functions/ai-translate.md
b/docs/sql-manual/sql-functions/ai-functions/ai-translate.md
index 5b46ccf4605..c179898836f 100644
--- a/docs/sql-manual/sql-functions/ai-functions/ai-translate.md
+++ b/docs/sql-manual/sql-functions/ai-functions/ai-translate.md
@@ -54,7 +54,7 @@ The result is generated by a large language model, so the
output may vary.
## Examples
```sql
-SET default_ai_resource = 'resourse_name';
+SET default_ai_resource = 'resource_name';
SELECT AI_TRANSLATE('In my mind, doris is the best databases management
system.', 'zh-CN') AS Result;
```
```text
diff --git
a/docs/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
b/docs/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
index 9ae7e84d3d2..df889406d07 100644
---
a/docs/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
+++
b/docs/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
@@ -21,7 +21,7 @@ INNER_PRODUCT_APPROXIMATE(<array1>, <array2>)
| Parameter | Description |
| -- |--|
| `<array1>` | The first vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array2 |
-| `<array1>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1 |
+| `<array2>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1 |
## Return Value
@@ -59,7 +59,7 @@ Do ann topn search that can be accelerated by ann index:
```sql
SELECT id,
- L2_distance_approximate(embedding,
+ inner_product_approximate(embedding,
[0,11,77,24,3,0,0,0,28,70,125,8,0,0,0,0,44,35,50,45,9,0,0,0,4,0,4,56,18,0,3,9,16,17,59,10,10,8,57,57,100,105,125,41,1,0,6,92,8,14,73,125,29,7,0,5,0,0,8,124,66,6,3,1,63,5,0,1,49,32,17,35,125,21,0,3,2,12,6,109,21,0,0,35,74,125,14,23,0,0,6,50,25,70,64,7,59,18,7,16,22,5,0,1,125,23,1,0,7,30,14,32,4,0,2,2,59,125,19,4,0,0,2,1,6,53,33,2]
) AS distance
FROM sift_1M
diff --git
a/docs/sql-manual/sql-functions/ai-functions/distance-functions/inner-product.md
b/docs/sql-manual/sql-functions/ai-functions/distance-functions/inner-product.md
index 8c31a76a799..1036da01320 100644
---
a/docs/sql-manual/sql-functions/ai-functions/distance-functions/inner-product.md
+++
b/docs/sql-manual/sql-functions/ai-functions/distance-functions/inner-product.md
@@ -21,7 +21,7 @@ INNER_PRODUCT(<array1>, <array2>)
| Parameter | Description |
| -- |--|
| `<array1>` | The first vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array2 |
-| `<array1>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1 |
+| `<array2>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1 |
## Return Value
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-avg.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-avg.md
index c4698b02e74..a532caee904 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-avg.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-avg.md
@@ -153,7 +153,7 @@ ERROR 1105 (HY000): errCode = 2, detailMessage = Can not
find the compatibility
Array is NULL, will return type conversion error
```
-mysql> SELECT array_max(NULL);
+mysql> SELECT array_avg(NULL);
ERROR 1105 (HY000): errCode = 2, detailMessage = class
org.apache.doris.nereids.types.NullType cannot be cast to class
org.apache.doris.nereids.types.ArrayType
(org.apache.doris.nereids.types.NullType and
org.apache.doris.nereids.types.ArrayType are in unnamed module of loader 'app')
```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-cross-product.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-cross-product.md
index ca12ebda714..b6640c9492e 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-cross-product.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-cross-product.md
@@ -20,7 +20,7 @@ CROSS_PRODUCT(<array1>, <array2>)
| Parameter | Description |
| -- |--|
| `<array1>` | The first vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array2. Neither the array itself nor any of its
elements can be NULL.|
-| `<array1>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1. Neither the array itself nor any of its
elements can be NULL.|
+| `<array2>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1. Neither the array itself nor any of its
elements can be NULL.|
## Return Value
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
index 9aed022dc73..62fe81ae6b4 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
@@ -63,7 +63,7 @@ SELECT array_product([1.1, 2.2, 3.3, 4.4, 5.5]);
+------------------------------------------+
| array_product([1.1, 2.2, 3.3, 4.4, 5.5]) |
+------------------------------------------+
-| 190.8 |
+| 193.2612 |
+------------------------------------------+
```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
index efcb4241a9b..accc8a6f343 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
@@ -44,7 +44,7 @@ Split the input array into multiple subarrays according to
given boolean flags.
- `ARRAY_REVERSE_SPLIT(['a','b','c'], [false,false,false])` ->
`[['a','b','c']]`
- With `NULL` in `flags`: `NULL` is treated the same as `false` (no split).
- - `ARRAY_REVERSE_SPLIT([1,NULL,3], [false,null,false])` -> `[[1,[NULL,3]]`
+ - `ARRAY_REVERSE_SPLIT([1,NULL,3], [false,null,false])` -> `[[1, NULL, 3]]`
- `lambda= x -> x-1` applied to `arr=[1, 2, 3]` produces `flags=[0,1,2]`,
equivalent to `flags=[false,true,true]`
- `ARRAY_REVERSE_SPLIT(x->x-1, [1, 2, 3])` is equivalent to
`ARRAY_REVERSE_SPLIT([1, 2, 3], [false,true,true])` -> `[[1, 2], [3]]`
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
index 829fea03a01..e2136bb4e78 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
@@ -44,7 +44,7 @@ Split the input array into multiple subarrays according to
given boolean flags.
- `ARRAY_SPLIT(['a','b','c'], [false,false,false])` -> `[['a','b','c']]`
- With `NULL` in `flags`: `NULL` is treated the same as `false` (no split).
- - `ARRAY_SPLIT([1,NULL,3], [false,null,false])` -> `[[1,[NULL,3]]`
+ - `ARRAY_SPLIT([1,NULL,3], [false,null,false])` -> `[[1, NULL, 3]]`
- `lambda= x -> x-1` applied to `arr0=[1, 2, 3]` produces `flags=[0,1,2]`,
equivalent to `flags=[false,true,true]`
- `ARRAY_SPLIT(x->x-1, [1, 2, 3])` is equivalent to `ARRAY_SPLIT([1, 2, 3],
[false,true,true])` -> `[[1], [2], [3]]`
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
index f912fd5b985..0feca1b41bb 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
@@ -69,11 +69,11 @@ ARRAY_UNION(arr1, arr2, ..., arrN)
```SQL
SELECT ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', NULL));
- +------------------------------------------------------------+
- | ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', NULL)) |
- +------------------------------------------------------------+
- | [null, "world", "hello"] |
- +------------------------------------------------------------+
+ +---------------------------------------------------------------------+
+ | ARRAY_UNION(ARRAY('hello', 'world', 'hello'), ARRAY('hello', NULL)) |
+ +---------------------------------------------------------------------+
+ | [null, "world", "hello"] |
+ +---------------------------------------------------------------------+
SELECT ARRAY_UNION(ARRAY(NULL, 'world'), ARRAY('hello', NULL));
+---------------------------------------------------------+
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 ab87235c748..bb36347ec31 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
@@ -29,7 +29,7 @@ STDDEV(<expr>)
## 返回值
-返回 Double 类型的参数 expr 的样本标准差。
+返回 Double 类型的参数 expr 的总体标准差。
当组内没有合法数据时，返回 NULL。
## 举例
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-classify.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-classify.md
index 9c8dc06d85f..3b23f70a59b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-classify.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-classify.md
@@ -56,7 +56,7 @@ AI_CLASSIFY([<resource_name>], <text>, <labels>)
```sql
SET default_ai_resource = 'resource_name';
-SELECT AI_CLASSIFY('Apache Doris is a databases system.', ['useage',
'introduce']) AS Result;
+SELECT AI_CLASSIFY('Apache Doris is a databases system.', ['usage',
'introduce']) AS Result;
```
```text
+-----------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-summarize.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-summarize.md
index 029491df18c..f34965b4cc2 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-summarize.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-summarize.md
@@ -66,7 +66,7 @@ SELECT AI_SUMMARIZE('Apache Doris is an MPP-based real-time
data warehouse known
```
```sql
-SELECT AI_SUMMARIZE('resourse_name','Doris supports high-concurrency,
real-time analytics and is widely used in business intelligence scenarios.') AS
Result;
+SELECT AI_SUMMARIZE('resource_name','Doris supports high-concurrency,
real-time analytics and is widely used in business intelligence scenarios.') AS
Result;
```
```text
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-translate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-translate.md
index 808745513d5..57bd7150c14 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-translate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/ai-translate.md
@@ -55,7 +55,7 @@ AI_TRANSLATE([<resource_name>], <text>, <target_language>)
## 示例
```sql
-SET default_ai_resource = 'resourse_name';
+SET default_ai_resource = 'resource_name';
SELECT AI_TRANSLATE('In my mind, doris is the best databases management
system.', 'zh-CN') AS Result;
```
```text
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
index 57e93ff36e1..98d68848565 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
@@ -59,7 +59,7 @@ FROM S3(
```sql
SELECT id,
- L2_distance_approximate(embedding,
+ inner_product_approximate(embedding,
[0,11,77,24,3,0,0,0,28,70,125,8,0,0,0,0,44,35,50,45,9,0,0,0,4,0,4,56,18,0,3,9,16,17,59,10,10,8,57,57,100,105,125,41,1,0,6,92,8,14,73,125,29,7,0,5,0,0,8,124,66,6,3,1,63,5,0,1,49,32,17,35,125,21,0,3,2,12,6,109,21,0,0,35,74,125,14,23,0,0,6,50,25,70,64,7,59,18,7,16,22,5,0,1,125,23,1,0,7,30,14,32,4,0,2,2,59,125,19,4,0,0,2,1,6,53,33,2]
) AS distance
FROM sift_1M
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
index 760858f7aeb..c98eaebd49d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
@@ -62,7 +62,7 @@ SELECT array_product([1.1, 2.2, 3.3, 4.4, 5.5]);
+------------------------------------------+
| array_product([1.1, 2.2, 3.3, 4.4, 5.5]) |
+------------------------------------------+
-| 190.8 |
+| 193.2612 |
+------------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
index 3dfb00a998e..795448fdf36 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
@@ -44,7 +44,7 @@
- `ARRAY_REVERSE_SPLIT(['a','b','c'], [false,false,false])` ->
`[['a','b','c']]`
- `flags` 中包含 `NULL`， `NULL` 被认为和 `false` 一样，不切分。
- - `ARRAY_REVERSE_SPLIT([1,NULL,3], [false,null,false])` -> `[[1,[NULL,3]]`
+ - `ARRAY_REVERSE_SPLIT([1,NULL,3], [false,null,false])` -> `[[1, NULL, 3]]`
- `lambda= x -> x-1` 作用于 `arr=[1, 2, 3]` 产生 `flags=[0,1,2]`，相当于
`flags=[false,true,true]`
- `ARRAY_REVERSE_SPLIT(x->x-1, [1, 2, 3])` 相当于 `ARRAY_REVERSE_SPLIT([1, 2,
3], [false,true,true])` -> `[[1, 2], [3]]`
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
index e0bcd5a93df..88b3a883bdb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
@@ -44,7 +44,7 @@
- `ARRAY_SPLIT(['a','b','c'], [false,false,false])` -> `[['a','b','c']]`
- `flags` 中包含 `NULL`， `NULL` 被认为和 `false` 一样，不切分。
- - `ARRAY_SPLIT([1,NULL,3], [false,null,false])` -> `[[1,[NULL,3]]`
+ - `ARRAY_SPLIT([1,NULL,3], [false,null,false])` -> `[[1, NULL, 3]]`
- `lambda= x -> x-1` 作用于 `arr0=[1, 2, 3]` 产生 `flags=[0,1,2]`，相当于
`flags=[false,true,true]`
- `ARRAY_SPLIT(x->x-1, [1, 2, 3])` 相当于 `ARRAY_SPLIT([1, 2, 3],
[false,true,true])` -> `[[1], [2], [3]]`
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
index bf48e11e6bd..76693a00587 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
@@ -69,11 +69,11 @@ ARRAY_UNION(arr1, arr2， ..., arrN)
```SQL
SELECT ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', NULL));
- +------------------------------------------------------------+
- | ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', NULL)) |
- +------------------------------------------------------------+
- | [null, "world", "hello"] |
- +------------------------------------------------------------+
+ +---------------------------------------------------------------------+
+ | ARRAY_UNION(ARRAY('hello', 'world', 'hello'), ARRAY('hello', NULL)) |
+ +---------------------------------------------------------------------+
+ | [null, "world", "hello"] |
+ +---------------------------------------------------------------------+
SELECT ARRAY_UNION(ARRAY(NULL, 'world'), ARRAY('hello', NULL));
+---------------------------------------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/aggregate-functions/stddev.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/aggregate-functions/stddev.md
index ab87235c748..bb36347ec31 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/aggregate-functions/stddev.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/aggregate-functions/stddev.md
@@ -29,7 +29,7 @@ STDDEV(<expr>)
## 返回值
-返回 Double 类型的参数 expr 的样本标准差。
+返回 Double 类型的参数 expr 的总体标准差。
当组内没有合法数据时，返回 NULL。
## 举例
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-classify.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-classify.md
index 9c8dc06d85f..3b23f70a59b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-classify.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-classify.md
@@ -56,7 +56,7 @@ AI_CLASSIFY([<resource_name>], <text>, <labels>)
```sql
SET default_ai_resource = 'resource_name';
-SELECT AI_CLASSIFY('Apache Doris is a databases system.', ['useage',
'introduce']) AS Result;
+SELECT AI_CLASSIFY('Apache Doris is a databases system.', ['usage',
'introduce']) AS Result;
```
```text
+-----------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-summarize.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-summarize.md
index 029491df18c..f34965b4cc2 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-summarize.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-summarize.md
@@ -66,7 +66,7 @@ SELECT AI_SUMMARIZE('Apache Doris is an MPP-based real-time
data warehouse known
```
```sql
-SELECT AI_SUMMARIZE('resourse_name','Doris supports high-concurrency,
real-time analytics and is widely used in business intelligence scenarios.') AS
Result;
+SELECT AI_SUMMARIZE('resource_name','Doris supports high-concurrency,
real-time analytics and is widely used in business intelligence scenarios.') AS
Result;
```
```text
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-translate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-translate.md
index 808745513d5..57bd7150c14 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-translate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-translate.md
@@ -55,7 +55,7 @@ AI_TRANSLATE([<resource_name>], <text>, <target_language>)
## 示例
```sql
-SET default_ai_resource = 'resourse_name';
+SET default_ai_resource = 'resource_name';
SELECT AI_TRANSLATE('In my mind, doris is the best databases management
system.', 'zh-CN') AS Result;
```
```text
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
index 57e93ff36e1..98d68848565 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
@@ -59,7 +59,7 @@ FROM S3(
```sql
SELECT id,
- L2_distance_approximate(embedding,
+ inner_product_approximate(embedding,
[0,11,77,24,3,0,0,0,28,70,125,8,0,0,0,0,44,35,50,45,9,0,0,0,4,0,4,56,18,0,3,9,16,17,59,10,10,8,57,57,100,105,125,41,1,0,6,92,8,14,73,125,29,7,0,5,0,0,8,124,66,6,3,1,63,5,0,1,49,32,17,35,125,21,0,3,2,12,6,109,21,0,0,35,74,125,14,23,0,0,6,50,25,70,64,7,59,18,7,16,22,5,0,1,125,23,1,0,7,30,14,32,4,0,2,2,59,125,19,4,0,0,2,1,6,53,33,2]
) AS distance
FROM sift_1M
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
index 760858f7aeb..c98eaebd49d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
@@ -62,7 +62,7 @@ SELECT array_product([1.1, 2.2, 3.3, 4.4, 5.5]);
+------------------------------------------+
| array_product([1.1, 2.2, 3.3, 4.4, 5.5]) |
+------------------------------------------+
-| 190.8 |
+| 193.2612 |
+------------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
index 3dfb00a998e..795448fdf36 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
@@ -44,7 +44,7 @@
- `ARRAY_REVERSE_SPLIT(['a','b','c'], [false,false,false])` ->
`[['a','b','c']]`
- `flags` 中包含 `NULL`， `NULL` 被认为和 `false` 一样，不切分。
- - `ARRAY_REVERSE_SPLIT([1,NULL,3], [false,null,false])` -> `[[1,[NULL,3]]`
+ - `ARRAY_REVERSE_SPLIT([1,NULL,3], [false,null,false])` -> `[[1, NULL, 3]]`
- `lambda= x -> x-1` 作用于 `arr=[1, 2, 3]` 产生 `flags=[0,1,2]`，相当于
`flags=[false,true,true]`
- `ARRAY_REVERSE_SPLIT(x->x-1, [1, 2, 3])` 相当于 `ARRAY_REVERSE_SPLIT([1, 2,
3], [false,true,true])` -> `[[1, 2], [3]]`
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
index e0bcd5a93df..88b3a883bdb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
@@ -44,7 +44,7 @@
- `ARRAY_SPLIT(['a','b','c'], [false,false,false])` -> `[['a','b','c']]`
- `flags` 中包含 `NULL`， `NULL` 被认为和 `false` 一样，不切分。
- - `ARRAY_SPLIT([1,NULL,3], [false,null,false])` -> `[[1,[NULL,3]]`
+ - `ARRAY_SPLIT([1,NULL,3], [false,null,false])` -> `[[1, NULL, 3]]`
- `lambda= x -> x-1` 作用于 `arr0=[1, 2, 3]` 产生 `flags=[0,1,2]`，相当于
`flags=[false,true,true]`
- `ARRAY_SPLIT(x->x-1, [1, 2, 3])` 相当于 `ARRAY_SPLIT([1, 2, 3],
[false,true,true])` -> `[[1], [2], [3]]`
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
index bf48e11e6bd..76693a00587 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
@@ -69,11 +69,11 @@ ARRAY_UNION(arr1, arr2， ..., arrN)
```SQL
SELECT ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', NULL));
- +------------------------------------------------------------+
- | ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', NULL)) |
- +------------------------------------------------------------+
- | [null, "world", "hello"] |
- +------------------------------------------------------------+
+ +---------------------------------------------------------------------+
+ | ARRAY_UNION(ARRAY('hello', 'world', 'hello'), ARRAY('hello', NULL)) |
+ +---------------------------------------------------------------------+
+ | [null, "world", "hello"] |
+ +---------------------------------------------------------------------+
SELECT ARRAY_UNION(ARRAY(NULL, 'world'), ARRAY('hello', NULL));
+---------------------------------------------------------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/aggregate-functions/stddev.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/aggregate-functions/stddev.md
index dfd98194d82..b5974776ec5 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/aggregate-functions/stddev.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/aggregate-functions/stddev.md
@@ -29,7 +29,7 @@ STDDEV(<expr>)
## Return Value
-Return the sample standard deviation of the expr expression as Double type.
+Return the population standard deviation of the expr expression as Double type.
If there is no valid data in the group, returns NULL.
## Examples
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-classify.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-classify.md
index 4afdfae9049..fda900d4c52 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-classify.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-classify.md
@@ -55,7 +55,7 @@ The result is generated by a large language model, so the
output may vary.
```sql
SET default_ai_resource = 'resource_name';
-SELECT AI_CLASSIFY('Apache Doris is a databases system.', ['useage',
'introduce']) AS Result;
+SELECT AI_CLASSIFY('Apache Doris is a databases system.', ['usage',
'introduce']) AS Result;
```
```text
+-----------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-summarize.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-summarize.md
index ddd7d6ca685..b1aee1a7fa0 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-summarize.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-summarize.md
@@ -65,7 +65,7 @@ SELECT AI_SUMMARIZE('Apache Doris is an MPP-based real-time
data warehouse known
```
```sql
-SELECT AI_SUMMARIZE('resourse_name','Doris supports high-concurrency,
real-time analytics and is widely used in business intelligence scenarios.') AS
Result;
+SELECT AI_SUMMARIZE('resource_name','Doris supports high-concurrency,
real-time analytics and is widely used in business intelligence scenarios.') AS
Result;
```
```text
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-translate.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-translate.md
index 5b46ccf4605..c179898836f 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-translate.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/ai-translate.md
@@ -54,7 +54,7 @@ The result is generated by a large language model, so the
output may vary.
## Examples
```sql
-SET default_ai_resource = 'resourse_name';
+SET default_ai_resource = 'resource_name';
SELECT AI_TRANSLATE('In my mind, doris is the best databases management
system.', 'zh-CN') AS Result;
```
```text
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
index 9ae7e84d3d2..df889406d07 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product-approximate.md
@@ -21,7 +21,7 @@ INNER_PRODUCT_APPROXIMATE(<array1>, <array2>)
| Parameter | Description |
| -- |--|
| `<array1>` | The first vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array2 |
-| `<array1>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1 |
+| `<array2>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1 |
## Return Value
@@ -59,7 +59,7 @@ Do ann topn search that can be accelerated by ann index:
```sql
SELECT id,
- L2_distance_approximate(embedding,
+ inner_product_approximate(embedding,
[0,11,77,24,3,0,0,0,28,70,125,8,0,0,0,0,44,35,50,45,9,0,0,0,4,0,4,56,18,0,3,9,16,17,59,10,10,8,57,57,100,105,125,41,1,0,6,92,8,14,73,125,29,7,0,5,0,0,8,124,66,6,3,1,63,5,0,1,49,32,17,35,125,21,0,3,2,12,6,109,21,0,0,35,74,125,14,23,0,0,6,50,25,70,64,7,59,18,7,16,22,5,0,1,125,23,1,0,7,30,14,32,4,0,2,2,59,125,19,4,0,0,2,1,6,53,33,2]
) AS distance
FROM sift_1M
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product.md
index 8c31a76a799..1036da01320 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/inner-product.md
@@ -21,7 +21,7 @@ INNER_PRODUCT(<array1>, <array2>)
| Parameter | Description |
| -- |--|
| `<array1>` | The first vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array2 |
-| `<array1>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1 |
+| `<array2>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1 |
## Return Value
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-avg.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-avg.md
index c4698b02e74..a532caee904 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-avg.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-avg.md
@@ -153,7 +153,7 @@ ERROR 1105 (HY000): errCode = 2, detailMessage = Can not
find the compatibility
Array is NULL, will return type conversion error
```
-mysql> SELECT array_max(NULL);
+mysql> SELECT array_avg(NULL);
ERROR 1105 (HY000): errCode = 2, detailMessage = class
org.apache.doris.nereids.types.NullType cannot be cast to class
org.apache.doris.nereids.types.ArrayType
(org.apache.doris.nereids.types.NullType and
org.apache.doris.nereids.types.ArrayType are in unnamed module of loader 'app')
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cross-product.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cross-product.md
index ca12ebda714..b6640c9492e 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cross-product.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cross-product.md
@@ -20,7 +20,7 @@ CROSS_PRODUCT(<array1>, <array2>)
| Parameter | Description |
| -- |--|
| `<array1>` | The first vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array2. Neither the array itself nor any of its
elements can be NULL.|
-| `<array1>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1. Neither the array itself nor any of its
elements can be NULL.|
+| `<array2>` | The second vector, the subtype of the input array supports:
TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, the number of elements
must be consistent with array1. Neither the array itself nor any of its
elements can be NULL.|
## Return Value
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
index 9aed022dc73..62fe81ae6b4 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md
@@ -63,7 +63,7 @@ SELECT array_product([1.1, 2.2, 3.3, 4.4, 5.5]);
+------------------------------------------+
| array_product([1.1, 2.2, 3.3, 4.4, 5.5]) |
+------------------------------------------+
-| 190.8 |
+| 193.2612 |
+------------------------------------------+
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
index efcb4241a9b..accc8a6f343 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split.md
@@ -44,7 +44,7 @@ Split the input array into multiple subarrays according to
given boolean flags.
- `ARRAY_REVERSE_SPLIT(['a','b','c'], [false,false,false])` ->
`[['a','b','c']]`
- With `NULL` in `flags`: `NULL` is treated the same as `false` (no split).
- - `ARRAY_REVERSE_SPLIT([1,NULL,3], [false,null,false])` -> `[[1,[NULL,3]]`
+ - `ARRAY_REVERSE_SPLIT([1,NULL,3], [false,null,false])` -> `[[1, NULL, 3]]`
- `lambda= x -> x-1` applied to `arr=[1, 2, 3]` produces `flags=[0,1,2]`,
equivalent to `flags=[false,true,true]`
- `ARRAY_REVERSE_SPLIT(x->x-1, [1, 2, 3])` is equivalent to
`ARRAY_REVERSE_SPLIT([1, 2, 3], [false,true,true])` -> `[[1, 2], [3]]`
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
index 829fea03a01..e2136bb4e78 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
@@ -44,7 +44,7 @@ Split the input array into multiple subarrays according to
given boolean flags.
- `ARRAY_SPLIT(['a','b','c'], [false,false,false])` -> `[['a','b','c']]`
- With `NULL` in `flags`: `NULL` is treated the same as `false` (no split).
- - `ARRAY_SPLIT([1,NULL,3], [false,null,false])` -> `[[1,[NULL,3]]`
+ - `ARRAY_SPLIT([1,NULL,3], [false,null,false])` -> `[[1, NULL, 3]]`
- `lambda= x -> x-1` applied to `arr0=[1, 2, 3]` produces `flags=[0,1,2]`,
equivalent to `flags=[false,true,true]`
- `ARRAY_SPLIT(x->x-1, [1, 2, 3])` is equivalent to `ARRAY_SPLIT([1, 2, 3],
[false,true,true])` -> `[[1], [2], [3]]`
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
index f912fd5b985..0feca1b41bb 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-union.md
@@ -69,11 +69,11 @@ ARRAY_UNION(arr1, arr2, ..., arrN)
```SQL
SELECT ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', NULL));
- +------------------------------------------------------------+
- | ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', NULL)) |
- +------------------------------------------------------------+
- | [null, "world", "hello"] |
- +------------------------------------------------------------+
+ +---------------------------------------------------------------------+
+ | ARRAY_UNION(ARRAY('hello', 'world', 'hello'), ARRAY('hello', NULL)) |
+ +---------------------------------------------------------------------+
+ | [null, "world", "hello"] |
+ +---------------------------------------------------------------------+
SELECT ARRAY_UNION(ARRAY(NULL, 'world'), ARRAY('hello', NULL));
+---------------------------------------------------------+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
