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 be05553b4fc [fix] correct column names in aggregate model doc examples
(#3670)
be05553b4fc is described below
commit be05553b4fce639fed688cd8f236592bfb5d53e9
Author: boluor <[email protected]>
AuthorDate: Wed May 20 00:21:13 2026 -0700
[fix] correct column names in aggregate model doc examples (#3670)
## Summary
Fixes two code-example errors in the aggregate data model doc
(`table-design/data-model/aggregate.md`):
1. **`example_tbl_agg` output mismatch** — the `SELECT * FROM
example_tbl_agg` result header showed `last_visit_date` /
`max_dwell_time`, but the table DDL defines those columns as
`last_visit_dt` / `max_dwell`. Corrected the output header to match the
DDL.
2. **`aggstate` non-existent columns** — the table `aggstate` is defined
with columns `k1, v1, v2`, but the "retain intermediate results" section
used non-existent `k2` / `k3` in `sum_union` / `sum_merge` /
`group_concat_union` / `group_concat_merge`. Corrected to `v1` / `v2`
(the earlier `merge` example already correctly uses `v2`).
Applied across all affected versions (EN: next + 2.0/2.1/3.x/4.x; ZH:
next + 2.1/3.x/4.x).
## Test plan
- [x] Verified `example_tbl_agg` DDL column names vs the `SELECT *`
output header
- [x] Verified `aggstate` DDL columns (`k1, v1, v2`) vs the queries;
`sum_*` maps to the `SUM` column `v1`, `group_concat_*` maps to the
`agg_state<group_concat>` column `v2`
- [x] Verified ASCII output-table alignment after the rename
---------
Co-authored-by: Claude Opus 4.7 (1M context) <[email protected]>
---
docs/table-design/data-model/aggregate.md | 12 ++++++------
.../current/table-design/data-model/aggregate.md | 12 ++++++------
.../version-2.1/table-design/data-model/aggregate.md | 10 +++++-----
.../version-3.x/table-design/data-model/aggregate.md | 12 ++++++------
.../version-4.x/table-design/data-model/aggregate.md | 12 ++++++------
.../version-2.1/table-design/data-model/aggregate.md | 12 ++++++------
.../version-3.x/table-design/data-model/aggregate.md | 12 ++++++------
.../version-4.x/table-design/data-model/aggregate.md | 12 ++++++------
8 files changed, 47 insertions(+), 47 deletions(-)
diff --git a/docs/table-design/data-model/aggregate.md
b/docs/table-design/data-model/aggregate.md
index f973b869338..8fa6c29fdcf 100644
--- a/docs/table-design/data-model/aggregate.md
+++ b/docs/table-design/data-model/aggregate.md
@@ -88,7 +88,7 @@ INSERT INTO example_tbl_agg VALUES
-- check the rows of table
SELECT * FROM example_tbl_agg;
+---------+------------+------+---------------------+------+----------------+
-| user_id | load_date | city | last_visit_date | cost | max_dwell_time |
+| user_id | load_date | city | last_visit_dt | cost | max_dwell |
+---------+------------+------+---------------------+------+----------------+
| 102 | 2024-10-30 | BJ | 2024-10-29 00:00:00 | 20 | 20 |
| 102 | 2024-11-01 | BJ | 2024-10-30 00:00:00 | 10 | 30 |
@@ -161,7 +161,7 @@ If you do not need the final aggregated result and instead
want to retain the in
```sql
INSERT INTO aggstate
-SELECT 3, sum_union(k2), group_concat_union(k3) FROM aggstate;
+SELECT 3, sum_union(v1), group_concat_union(v2) FROM aggstate;
```
The computation in the table at this point is shown in the following figure:
@@ -171,16 +171,16 @@ The computation in the table at this point is shown in
the following figure:
The query results are as follows:
```sql
-mysql> SELECT sum_merge(k2), group_concat_merge(k3) FROM aggstate;
+mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 20 | c,b,a,d,c,b,a,d |
+---------------+------------------------+
-mysql> SELECT sum_merge(k2), group_concat_merge(k3) FROM aggstate WHERE k1 !=
2;
+mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate WHERE k1 !=
2;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 16 | c,b,a,d,c,b,a |
+---------------+------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
index c8121f7450e..736bf1251c3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
@@ -88,7 +88,7 @@ INSERT INTO example_tbl_agg VALUES
-- check the rows of table
SELECT * FROM example_tbl_agg;
+---------+------------+------+---------------------+------+----------------+
-| user_id | load_date | city | last_visit_date | cost | max_dwell_time |
+| user_id | load_date | city | last_visit_dt | cost | max_dwell |
+---------+------------+------+---------------------+------+----------------+
| 102 | 2024-10-30 | BJ | 2024-10-29 00:00:00 | 20 | 20 |
| 102 | 2024-11-01 | BJ | 2024-10-30 00:00:00 | 10 | 30 |
@@ -161,7 +161,7 @@ SELECT group_concat_merge(v2) FROM aggstate;
```sql
INSERT INTO aggstate
-SELECT 3, sum_union(k2), group_concat_union(k3) FROM aggstate;
+SELECT 3, sum_union(v1), group_concat_union(v2) FROM aggstate;
```
此时表内计算方式如下图所示：
@@ -171,16 +171,16 @@ SELECT 3, sum_union(k2), group_concat_union(k3) FROM
aggstate;
查询结果如下：
```sql
-mysql> SELECT sum_merge(k2), group_concat_merge(k3) FROM aggstate;
+mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 20 | c,b,a,d,c,b,a,d |
+---------------+------------------------+
-mysql> SELECT sum_merge(k2), group_concat_merge(k3) FROM aggstate WHERE k1 !=
2;
+mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate WHERE k1 !=
2;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 16 | c,b,a,d,c,b,a |
+---------------+------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-model/aggregate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-model/aggregate.md
index 9f000a5eb69..f0ce70dd330 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-model/aggregate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-model/aggregate.md
@@ -86,7 +86,7 @@ INSERT INTO example_tbl_agg VALUES
-- check the rows of table
SELECT * FROM example_tbl_agg;
+---------+------------+------+---------------------+------+----------------+
-| user_id | load_date | city | last_visit_date | cost | max_dwell_time |
+| user_id | load_date | city | last_visit_dt | cost | max_dwell |
+---------+------------+------+---------------------+------+----------------+
| 102 | 2024-10-30 | BJ | 2024-10-29 00:00:00 | 20 | 20 |
| 102 | 2024-11-01 | BJ | 2024-10-30 00:00:00 | 10 | 30 |
@@ -161,16 +161,16 @@ select sum(v1), group_concat_merge(v2) from aggstate
where k1 != 2;
查询结果如下：
```sql
-mysql> select sum_merge(k2) , group_concat_merge(k3)from aggstate;
+mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 20 | c,b,a,d,c,b,a,d |
+---------------+------------------------+
-mysql> select sum_merge(k2) , group_concat_merge(k3)from aggstate where k1 !=
2;
+mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate where k1 !=
2;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 16 | c,b,a,d,c,b,a |
+---------------+------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/table-design/data-model/aggregate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/table-design/data-model/aggregate.md
index 4a49bd07892..af0fe0bbe2c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/table-design/data-model/aggregate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/table-design/data-model/aggregate.md
@@ -88,7 +88,7 @@ INSERT INTO example_tbl_agg VALUES
-- check the rows of table
SELECT * FROM example_tbl_agg;
+---------+------------+------+---------------------+------+----------------+
-| user_id | load_date | city | last_visit_date | cost | max_dwell_time |
+| user_id | load_date | city | last_visit_dt | cost | max_dwell |
+---------+------------+------+---------------------+------+----------------+
| 102 | 2024-10-30 | BJ | 2024-10-29 00:00:00 | 20 | 20 |
| 102 | 2024-11-01 | BJ | 2024-10-30 00:00:00 | 10 | 30 |
@@ -148,7 +148,7 @@ select group_concat_merge(v2) from aggstate;
如果不想要最终的聚合结果，而希望保留中间结果，可以使用 `union` 操作：
```sql
-insert into aggstate select 3,sum_union(k2),group_concat_union(k3) from
aggstate;
+insert into aggstate select 3,sum_union(v1),group_concat_union(v2) from
aggstate;
```
此时表中计算如下：
@@ -158,16 +158,16 @@ insert into aggstate select
3,sum_union(k2),group_concat_union(k3) from aggstate
查询结果如下：
```sql
-mysql> select sum_merge(k2) , group_concat_merge(k3)from aggstate;
+mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 20 | c,b,a,d,c,b,a,d |
+---------------+------------------------+
-mysql> select sum_merge(k2) , group_concat_merge(k3)from aggstate where k1 !=
2;
+mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate where k1 !=
2;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 16 | c,b,a,d,c,b,a |
+---------------+------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
index c8121f7450e..736bf1251c3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
@@ -88,7 +88,7 @@ INSERT INTO example_tbl_agg VALUES
-- check the rows of table
SELECT * FROM example_tbl_agg;
+---------+------------+------+---------------------+------+----------------+
-| user_id | load_date | city | last_visit_date | cost | max_dwell_time |
+| user_id | load_date | city | last_visit_dt | cost | max_dwell |
+---------+------------+------+---------------------+------+----------------+
| 102 | 2024-10-30 | BJ | 2024-10-29 00:00:00 | 20 | 20 |
| 102 | 2024-11-01 | BJ | 2024-10-30 00:00:00 | 10 | 30 |
@@ -161,7 +161,7 @@ SELECT group_concat_merge(v2) FROM aggstate;
```sql
INSERT INTO aggstate
-SELECT 3, sum_union(k2), group_concat_union(k3) FROM aggstate;
+SELECT 3, sum_union(v1), group_concat_union(v2) FROM aggstate;
```
此时表内计算方式如下图所示：
@@ -171,16 +171,16 @@ SELECT 3, sum_union(k2), group_concat_union(k3) FROM
aggstate;
查询结果如下：
```sql
-mysql> SELECT sum_merge(k2), group_concat_merge(k3) FROM aggstate;
+mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 20 | c,b,a,d,c,b,a,d |
+---------------+------------------------+
-mysql> SELECT sum_merge(k2), group_concat_merge(k3) FROM aggstate WHERE k1 !=
2;
+mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate WHERE k1 !=
2;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 16 | c,b,a,d,c,b,a |
+---------------+------------------------+
diff --git a/versioned_docs/version-2.1/table-design/data-model/aggregate.md
b/versioned_docs/version-2.1/table-design/data-model/aggregate.md
index 3bbbe3732d5..6423133d4e9 100644
--- a/versioned_docs/version-2.1/table-design/data-model/aggregate.md
+++ b/versioned_docs/version-2.1/table-design/data-model/aggregate.md
@@ -103,7 +103,7 @@ INSERT INTO example_tbl_agg VALUES
-- check the rows of table
SELECT * FROM example_tbl_agg;
+---------+------------+------+---------------------+------+----------------+
-| user_id | load_date | city | last_visit_date | cost | max_dwell_time |
+| user_id | load_date | city | last_visit_dt | cost | max_dwell |
+---------+------------+------+---------------------+------+----------------+
| 102 | 2024-10-30 | BJ | 2024-10-29 00:00:00 | 20 | 20 |
| 102 | 2024-11-01 | BJ | 2024-10-30 00:00:00 | 10 | 30 |
@@ -161,7 +161,7 @@ select group_concat_merge(v2) from aggstate;
If you do not want the final aggregation result, you can use `union` to
combine multiple intermediate aggregation results and generate a new
intermediate result.
```sql
-insert into aggstate select 3,sum_union(k2),group_concat_union(k3) from
aggstate;
+insert into aggstate select 3,sum_union(v1),group_concat_union(v2) from
aggstate;
```
The calculations in the table are as follows:
@@ -171,16 +171,16 @@ The calculations in the table are as follows:
The query result is as follows:
```sql
-mysql> select sum_merge(k2) , group_concat_merge(k3)from aggstate;
+mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 20 | c,b,a,d,c,b,a,d |
+---------------+------------------------+
-mysql> select sum_merge(k2) , group_concat_merge(k3)from aggstate where k1 !=
2;
+mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate where k1 !=
2;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 16 | c,b,a,d,c,b,a |
+---------------+------------------------+
diff --git a/versioned_docs/version-3.x/table-design/data-model/aggregate.md
b/versioned_docs/version-3.x/table-design/data-model/aggregate.md
index afaa978ad73..07326304075 100644
--- a/versioned_docs/version-3.x/table-design/data-model/aggregate.md
+++ b/versioned_docs/version-3.x/table-design/data-model/aggregate.md
@@ -102,7 +102,7 @@ INSERT INTO example_tbl_agg VALUES
-- check the rows of table
SELECT * FROM example_tbl_agg;
+---------+------------+------+---------------------+------+----------------+
-| user_id | load_date | city | last_visit_date | cost | max_dwell_time |
+| user_id | load_date | city | last_visit_dt | cost | max_dwell |
+---------+------------+------+---------------------+------+----------------+
| 102 | 2024-10-30 | BJ | 2024-10-29 00:00:00 | 20 | 20 |
| 102 | 2024-11-01 | BJ | 2024-10-30 00:00:00 | 10 | 30 |
@@ -160,7 +160,7 @@ select group_concat_merge(v2) from aggstate;
If you do not want the final aggregation result, you can use `union` to
combine multiple intermediate aggregation results and generate a new
intermediate result.
```sql
-insert into aggstate select 3,sum_union(k2),group_concat_union(k3) from
aggstate;
+insert into aggstate select 3,sum_union(v1),group_concat_union(v2) from
aggstate;
```
The calculations in the table are as follows:
@@ -170,16 +170,16 @@ The calculations in the table are as follows:
The query result is as follows:
```sql
-mysql> select sum_merge(k2) , group_concat_merge(k3)from aggstate;
+mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 20 | c,b,a,d,c,b,a,d |
+---------------+------------------------+
-mysql> select sum_merge(k2) , group_concat_merge(k3)from aggstate where k1 !=
2;
+mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate where k1 !=
2;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 16 | c,b,a,d,c,b,a |
+---------------+------------------------+
diff --git a/versioned_docs/version-4.x/table-design/data-model/aggregate.md
b/versioned_docs/version-4.x/table-design/data-model/aggregate.md
index f973b869338..8fa6c29fdcf 100644
--- a/versioned_docs/version-4.x/table-design/data-model/aggregate.md
+++ b/versioned_docs/version-4.x/table-design/data-model/aggregate.md
@@ -88,7 +88,7 @@ INSERT INTO example_tbl_agg VALUES
-- check the rows of table
SELECT * FROM example_tbl_agg;
+---------+------------+------+---------------------+------+----------------+
-| user_id | load_date | city | last_visit_date | cost | max_dwell_time |
+| user_id | load_date | city | last_visit_dt | cost | max_dwell |
+---------+------------+------+---------------------+------+----------------+
| 102 | 2024-10-30 | BJ | 2024-10-29 00:00:00 | 20 | 20 |
| 102 | 2024-11-01 | BJ | 2024-10-30 00:00:00 | 10 | 30 |
@@ -161,7 +161,7 @@ If you do not need the final aggregated result and instead
want to retain the in
```sql
INSERT INTO aggstate
-SELECT 3, sum_union(k2), group_concat_union(k3) FROM aggstate;
+SELECT 3, sum_union(v1), group_concat_union(v2) FROM aggstate;
```
The computation in the table at this point is shown in the following figure:
@@ -171,16 +171,16 @@ The computation in the table at this point is shown in
the following figure:
The query results are as follows:
```sql
-mysql> SELECT sum_merge(k2), group_concat_merge(k3) FROM aggstate;
+mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 20 | c,b,a,d,c,b,a,d |
+---------------+------------------------+
-mysql> SELECT sum_merge(k2), group_concat_merge(k3) FROM aggstate WHERE k1 !=
2;
+mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate WHERE k1 !=
2;
+---------------+------------------------+
-| sum_merge(k2) | group_concat_merge(k3) |
+| sum_merge(v1) | group_concat_merge(v2) |
+---------------+------------------------+
| 16 | c,b,a,d,c,b,a |
+---------------+------------------------+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
