This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 2a29723ad6c [typo](docs) Aggregate Mode: Keep the sample code and
documentation consistent (#3374)
2a29723ad6c is described below
commit 2a29723ad6c0feea771ac7f7f2edc55f559a03ff
Author: Yongqiang YANG <[email protected]>
AuthorDate: Tue Feb 10 13:16:27 2026 -0800
[typo](docs) Aggregate Mode: Keep the sample code and documentation
consistent (#3374)
## Summary
- Keep aggregate model sample column names consistent by replacing
`load_dt` with `load_date` in SQL examples and key definitions.
- Sync the related explanatory text with the corrected key column name.
- Scope this recreation to `dev`, `3.x`, and `4.x` only (both English
and Chinese docs).
## Versions
- [x] dev
- [x] 4.x
- [x] 3.x
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
Signed-off-by: daveyyan <[email protected]>
Signed-off-by: daveyyan <[email protected]>
Co-authored-by: daveyyan <[email protected]>
---
docs/table-design/data-model/aggregate.md | 7 +++----
.../current/table-design/data-model/aggregate.md | 7 +++----
.../version-3.x/table-design/data-model/aggregate.md | 7 +++----
.../version-4.x/table-design/data-model/aggregate.md | 7 +++----
versioned_docs/version-3.x/table-design/data-model/aggregate.md | 7 +++----
versioned_docs/version-4.x/table-design/data-model/aggregate.md | 7 +++----
6 files changed, 18 insertions(+), 24 deletions(-)
diff --git a/docs/table-design/data-model/aggregate.md
b/docs/table-design/data-model/aggregate.md
index 9aab23e7d9a..3021e190a30 100644
--- a/docs/table-design/data-model/aggregate.md
+++ b/docs/table-design/data-model/aggregate.md
@@ -45,17 +45,17 @@ When creating a table, the **AGGREGATE KEY** keyword can be
used to specify the
CREATE TABLE IF NOT EXISTS example_tbl_agg
(
user_id LARGEINT NOT NULL,
- load_dt DATE NOT NULL,
+ load_date DATE NOT NULL,
city VARCHAR(20),
last_visit_dt DATETIME REPLACE DEFAULT "1970-01-01 00:00:00",
cost BIGINT SUM DEFAULT "0",
max_dwell INT MAX DEFAULT "0",
)
-AGGREGATE KEY(user_id, load_dt, city)
+AGGREGATE KEY(user_id, load_date, city)
DISTRIBUTED BY HASH(user_id) BUCKETS 10;
```
-In the example above, a fact table for user information and access behavior is
defined, where `user_id`, `load_dt`, and `city` are used as Key columns for
aggregation. During data import, the Key columns are aggregated into one row,
and the Value columns are aggregated according to the specified aggregation
types.
+In the example above, a fact table for user information and access behavior is
defined, where `user_id`, `load_date`, and `city` are used as Key columns for
aggregation. During data import, the Key columns are aggregated into one row,
and the Value columns are aggregated according to the specified aggregation
types.
The following types of dimension aggregation are supported in the Aggregate
Key Table:
@@ -185,4 +185,3 @@ mysql> select sum_merge(k2) , group_concat_merge(k3)from
aggstate where k1 != 2;
| 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 f5e88841f73..1b4bf70febd 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
@@ -32,17 +32,17 @@ Doris 的聚合模型专为高效处理大规模数据查询中的聚合操作
CREATE TABLE IF NOT EXISTS example_tbl_agg
(
user_id LARGEINT NOT NULL,
- load_dt DATE NOT NULL,
+ load_date DATE NOT NULL,
city VARCHAR(20),
last_visit_dt DATETIME REPLACE DEFAULT "1970-01-01 00:00:00",
cost BIGINT SUM DEFAULT "0",
max_dwell INT MAX DEFAULT "0",
)
-AGGREGATE KEY(user_id, load_dt, city)
+AGGREGATE KEY(user_id, load_date, city)
DISTRIBUTED BY HASH(user_id) BUCKETS 10;
```
-上例中定义了用户信息和访问行为表，将 `user_id`、`load_dt` 及 `city` 作为 Key 列进行聚合。数据导入时，Key
列会聚合成一行，Value 列会按照指定的聚合类型进行维度聚合。
+上例中定义了用户信息和访问行为表，将 `user_id`、`load_date` 及 `city` 作为 Key 列进行聚合。数据导入时，Key
列会聚合成一行，Value 列会按照指定的聚合类型进行维度聚合。
在聚合表中支持以下类型的维度聚合：
@@ -170,4 +170,3 @@ mysql> select sum_merge(k2) , group_concat_merge(k3)from
aggstate where k1 != 2;
| 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 5c12d1c991f..4a49bd07892 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
@@ -32,18 +32,18 @@ Doris 的聚合表专为高效处理大规模数据查询中的聚合操作设
CREATE TABLE IF NOT EXISTS example_tbl_agg
(
user_id LARGEINT NOT NULL,
- load_dt DATE NOT NULL,
+ load_date DATE NOT NULL,
city VARCHAR(20),
last_visit_dt DATETIME REPLACE DEFAULT "1970-01-01 00:00:00",
cost BIGINT SUM DEFAULT "0",
max_dwell INT MAX DEFAULT "0",
)
-AGGREGATE KEY(user_id, load_dt, city)
+AGGREGATE KEY(user_id, load_date, city)
DISTRIBUTED BY HASH(user_id) BUCKETS 10;
```
-上例中定义了用户信息和访问的行为事实表，将 `user_id`、`load_dt` 及 `city` 作为 Key 列进行聚合操作。数据导入时，Key
列会聚合成一行，Value 列会按照指定的聚合类型进行维度聚合。
+上例中定义了用户信息和访问的行为事实表，将 `user_id`、`load_date` 及 `city` 作为 Key 列进行聚合操作。数据导入时，Key
列会聚合成一行，Value 列会按照指定的聚合类型进行维度聚合。
在聚合表中支持以下类型的维度聚合：
@@ -172,4 +172,3 @@ mysql> select sum_merge(k2) , group_concat_merge(k3)from
aggstate where k1 != 2;
| 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 f5e88841f73..1b4bf70febd 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
@@ -32,17 +32,17 @@ Doris 的聚合模型专为高效处理大规模数据查询中的聚合操作
CREATE TABLE IF NOT EXISTS example_tbl_agg
(
user_id LARGEINT NOT NULL,
- load_dt DATE NOT NULL,
+ load_date DATE NOT NULL,
city VARCHAR(20),
last_visit_dt DATETIME REPLACE DEFAULT "1970-01-01 00:00:00",
cost BIGINT SUM DEFAULT "0",
max_dwell INT MAX DEFAULT "0",
)
-AGGREGATE KEY(user_id, load_dt, city)
+AGGREGATE KEY(user_id, load_date, city)
DISTRIBUTED BY HASH(user_id) BUCKETS 10;
```
-上例中定义了用户信息和访问行为表，将 `user_id`、`load_dt` 及 `city` 作为 Key 列进行聚合。数据导入时，Key
列会聚合成一行，Value 列会按照指定的聚合类型进行维度聚合。
+上例中定义了用户信息和访问行为表，将 `user_id`、`load_date` 及 `city` 作为 Key 列进行聚合。数据导入时，Key
列会聚合成一行，Value 列会按照指定的聚合类型进行维度聚合。
在聚合表中支持以下类型的维度聚合：
@@ -170,4 +170,3 @@ mysql> select sum_merge(k2) , group_concat_merge(k3)from
aggstate where k1 != 2;
| 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 8f6e987f5cf..afaa978ad73 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
@@ -45,17 +45,17 @@ When creating a table, the **AGGREGATE KEY** keyword can be
used to specify the
CREATE TABLE IF NOT EXISTS example_tbl_agg
(
user_id LARGEINT NOT NULL,
- load_dt DATE NOT NULL,
+ load_date DATE NOT NULL,
city VARCHAR(20),
last_visit_dt DATETIME REPLACE DEFAULT "1970-01-01 00:00:00",
cost BIGINT SUM DEFAULT "0",
max_dwell INT MAX DEFAULT "0",
)
-AGGREGATE KEY(user_id, load_dt, city)
+AGGREGATE KEY(user_id, load_date, city)
DISTRIBUTED BY HASH(user_id) BUCKETS 10;
```
-In the example above, a fact table for user information and access behavior is
defined, where `user_id`, `load_dt`, and `city` are used as Key columns for
aggregation. During data import, the Key columns are aggregated into one row,
and the Value columns are aggregated according to the specified aggregation
types.
+In the example above, a fact table for user information and access behavior is
defined, where `user_id`, `load_date`, and `city` are used as Key columns for
aggregation. During data import, the Key columns are aggregated into one row,
and the Value columns are aggregated according to the specified aggregation
types.
The following types of dimension aggregation are supported in the Aggregate
Key Table:
@@ -184,4 +184,3 @@ mysql> select sum_merge(k2) , group_concat_merge(k3)from
aggstate where k1 != 2;
| 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 9aab23e7d9a..3021e190a30 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
@@ -45,17 +45,17 @@ When creating a table, the **AGGREGATE KEY** keyword can be
used to specify the
CREATE TABLE IF NOT EXISTS example_tbl_agg
(
user_id LARGEINT NOT NULL,
- load_dt DATE NOT NULL,
+ load_date DATE NOT NULL,
city VARCHAR(20),
last_visit_dt DATETIME REPLACE DEFAULT "1970-01-01 00:00:00",
cost BIGINT SUM DEFAULT "0",
max_dwell INT MAX DEFAULT "0",
)
-AGGREGATE KEY(user_id, load_dt, city)
+AGGREGATE KEY(user_id, load_date, city)
DISTRIBUTED BY HASH(user_id) BUCKETS 10;
```
-In the example above, a fact table for user information and access behavior is
defined, where `user_id`, `load_dt`, and `city` are used as Key columns for
aggregation. During data import, the Key columns are aggregated into one row,
and the Value columns are aggregated according to the specified aggregation
types.
+In the example above, a fact table for user information and access behavior is
defined, where `user_id`, `load_date`, and `city` are used as Key columns for
aggregation. During data import, the Key columns are aggregated into one row,
and the Value columns are aggregated according to the specified aggregation
types.
The following types of dimension aggregation are supported in the Aggregate
Key Table:
@@ -185,4 +185,3 @@ mysql> select sum_merge(k2) , group_concat_merge(k3)from
aggstate where k1 != 2;
| 16 | c,b,a,d,c,b,a |
+---------------+------------------------+
```
-
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
