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 871ecf12f99 [fix](doc) content corrections in zh 2.1
function/reference docs (#3739)
871ecf12f99 is described below
commit 871ecf12f99c21a12fc98b816d9b261f9dd6e5b6
Author: boluor <[email protected]>
AuthorDate: Fri May 22 10:35:07 2026 -0700
[fix](doc) content corrections in zh 2.1 function/reference docs (#3739)
## Summary
Content fixes in the Chinese 2.1 docs (reader-reported):
| Issue | File | Fix |
| --- | --- | --- |
| #2531 | array-functions/array-enumerate-uniq | 3-array example result
`[1, 1, 2, 1, 3]` → `[1, 1, 2, 2, 3]` (position-3 tuple `(1,1,1)` is its
2nd occurrence) |
| #2523 | string-functions/elt | example repeated `ELT(2, ...)` twice →
use a 0/1/2 variety and realign the result table |
| #2518 | basic-element/nulls | truth-table header `**Value of A**` vs
variable `a` → lowercase to `a` |
| #2533 | json-functions/json-exists-path | both parameter descriptions
copied from an array function → correct JSON-string / path descriptions
|
| #2534 | json-functions/json-type | syntax + params listed only
`<json>` though examples pass two args → add the missing `<path>`
argument |
| #2477 | async-materialized-view/use-guide | claimed aggregation yields
~17,000,000 rows from a 1,000,000-row table (impossible) → reword
(aggregation cannot exceed the input row count) |
## Test plan
- [x] #2531 result verified by hand (tuple-position enumeration).
- [x] Dead-link check passes.
- [ ] CI build.
Closes #2531
Closes #2523
Closes #2518
Closes #2533
Closes #2534
Closes #2477
Co-authored-by: Claude Opus 4.7 (1M context) <[email protected]>
---
.../materialized-view/async-materialized-view/use-guide.md | 2 +-
.../version-2.1/sql-manual/basic-element/nulls.md | 2 +-
.../scalar-functions/array-functions/array-enumerate-uniq.md | 2 +-
.../scalar-functions/json-functions/json-exists-path.md | 4 ++--
.../scalar-functions/json-functions/json-type.md | 3 ++-
.../sql-functions/scalar-functions/string-functions/elt.md | 12 ++++++------
6 files changed, 13 insertions(+), 12 deletions(-)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/use-guide.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/use-guide.md
index 549868fd91c..29e33c700df 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/use-guide.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/use-guide.md
@@ -330,7 +330,7 @@ GROUP BY
比如表 t1，原表的数据量是 1000000，查询语句 SQL 中有 `group by a, b, c`。如果 a，b，c 的基数分别是
100，50，15，那么聚合后的数据大概在 75000 左右，说明此物化视图是有效的。如果 a，b，c 具有相关性，那么聚合后的数据量会进一步减少。
- 如果 a, b, c 的基数很高，会导致聚合后的数据急速膨胀。如果聚合后的数据比原表的数据还多，可能这样的场景不太适合构建物化视图。比如 c 的基数是
3500，那么聚合后的数据量在 17000000 左右，比原表数据量大的多，构建这样的物化视图性能加速收益低。
+ 如果 a, b, c 的基数很高，分组组合数（基数乘积）会接近甚至超过原表行数，此时聚合几乎不能减少行数（聚合后的行数最多等于原表行数）。比如 c
的基数是 3500，a、b、c 的基数乘积约为 17500000，已远超原表的 1000000 行，聚合后几乎无法减少行数，构建这样的物化视图性能加速收益低。
物化视图的聚合粒度要比查询细，即物化视图的聚合维度包含查询的聚合维度，这样才能提供查询所需的数据。查询可以不写 Group
By，同理，物化视图的聚合函数应该包含查询的聚合函数。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/nulls.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/nulls.md
index 389d34e1df3..ac3b30784bb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/nulls.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/nulls.md
@@ -28,7 +28,7 @@
下表显示了条件中涉及 NULL 的各种评估的示例。如果在 SELECT 语句的 WHERE 子句中使用计算结果为 UNKNOWN
的条件，那么该查询将不返回任何行。
-| **Condition** | **Value of A** | **Evaluation** |
+| **Condition** | **Value of a** | **Evaluation** |
| :-------------- | :------------- | :------------- |
| `a IS NULL` | `10` | `FALSE` |
| `a IS NOT NULL` | `10` | `TRUE` |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/array-functions/array-enumerate-uniq.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/array-functions/array-enumerate-uniq.md
index 1548a3c1590..df6791cb200 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/array-functions/array-enumerate-uniq.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/array-functions/array-enumerate-uniq.md
@@ -42,6 +42,6 @@ select array_enumerate_uniq([1, 1, 1, 1, 1], [2, 1, 2, 1, 2],
[3, 1, 3, 1, 3]);
+----------------------------------------------------------------------------------------+
| array_enumerate_uniq(ARRAY(1, 1, 1, 1, 1), ARRAY(2, 1, 2, 1, 2), ARRAY(3, 1,
3, 1, 3)) |
+----------------------------------------------------------------------------------------+
-| [1, 1, 2, 1, 3]
|
+| [1, 1, 2, 2, 3]
|
+----------------------------------------------------------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-exists-path.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-exists-path.md
index 96e4c43e1f3..cd22905ae0e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-exists-path.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-exists-path.md
@@ -23,8 +23,8 @@ JSON_EXISTS_PATH (<json_str>, <path>)
## 参数
| 参数 | 描述 |
|--------------|--------------------------------------------------------|
-| `<json_str>` | 要包含在 JSON 数组中的元素。可以是任意类型的值，包括`NULL`。如果没有指定元素，则返回一个空数组。
-| `<path>` | 要插入的 JSON 路径。如果是 `NULL` ，则返回 NULL |
+| `<json_str>` | 要检查的 JSON 字符串。如果是 `NULL`，则返回 NULL |
+| `<path>` | 要判断是否存在的 JSON 路径。如果是 `NULL`，则返回 NULL |
## 返回值
如果存在返回 TRUE，不存在返回 FALSE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-type.md
index 94ad0a97ecf..f5d7d519968 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-type.md
@@ -23,7 +23,7 @@
## 语法
```sql
-STRING JSON_TYPE( <json> )
+STRING JSON_TYPE( <json>, <path> )
```
## 别名
@@ -35,6 +35,7 @@ STRING JSON_TYPE( <json> )
| 参数 | 描述 |
|------|------|
| `<json>` | 需要检查类型的 JSON 字符串。 |
+| `<path>` | 要检查类型的字段的 JSON 路径。 |
## 返回值
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/elt.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/elt.md
index 58deaa4b401..1449155762e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/elt.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/elt.md
@@ -34,13 +34,13 @@ ELT ( <pos> , <str> [ , <str> ] )
## 举例
```sql
-SELECT ELT(1, 'aaa', 'bbb'),ELT(2, 'aaa', 'bbb'), ELT(0, 'aaa', 'bbb'),ELT(2,
'aaa', 'bbb')
+SELECT ELT(1, 'aaa', 'bbb'), ELT(2, 'aaa', 'bbb'), ELT(0, 'aaa', 'bbb')
```
```text
-+----------------------+----------------------+----------------------+----------------------+
-| elt(1, 'aaa', 'bbb') | elt(2, 'aaa', 'bbb') | elt(0, 'aaa', 'bbb') | elt(2,
'aaa', 'bbb') |
-+----------------------+----------------------+----------------------+----------------------+
-| aaa | bbb | NULL | bbb
|
-+----------------------+----------------------+----------------------+----------------------+
++----------------------+----------------------+----------------------+
+| elt(1, 'aaa', 'bbb') | elt(2, 'aaa', 'bbb') | elt(0, 'aaa', 'bbb') |
++----------------------+----------------------+----------------------+
+| aaa | bbb | NULL |
++----------------------+----------------------+----------------------+
```
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
