This is an automated email from the ASF dual-hosted git repository.
gavinchou pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 767850d1cb1 [fix](doc) adjust doc case for duplicated table. (#43264)
767850d1cb1 is described below
commit 767850d1cb1db2b5ccad191c85c7c4efc6d14d2f
Author: Yongqiang YANG <yangyongqi...@selectdb.com>
AuthorDate: Mon Nov 18 09:56:06 2024 +0800
[fix](doc) adjust doc case for duplicated table. (#43264)
Co-authored-by: Yongqiang YANG <yangyogqi...@selectdb.com>
---
.../table-design/data-model/aggregate.md.groovy | 4 ++--
.../table-design/data-model/duplicate.md.groovy | 25 +++++++++++-----------
2 files changed, 15 insertions(+), 14 deletions(-)
diff --git
a/regression-test/suites/doc/table-design/data-model/aggregate.md.groovy
b/regression-test/suites/doc/table-design/data-model/aggregate.md.groovy
index cc6cc576e97..f3c5a0ab26f 100644
--- a/regression-test/suites/doc/table-design/data-model/aggregate.md.groovy
+++ b/regression-test/suites/doc/table-design/data-model/aggregate.md.groovy
@@ -33,9 +33,9 @@ suite("docs/table-design/data-model/aggregate.md") {
`min_dwell_time` INT MIN DEFAULT "99999" COMMENT "用户最小停留时间"
)
AGGREGATE KEY(`user_id`, `date`, `city`, `age`, `sex`)
- DISTRIBUTED BY HASH(`user_id`) BUCKETS 1
+ DISTRIBUTED BY HASH(`user_id`) BUCKETS 10
PROPERTIES (
- "replication_allocation" = "tag.location.default: 1"
+ "replication_allocation" = "tag.location.default: 3"
);
"""
diff --git
a/regression-test/suites/doc/table-design/data-model/duplicate.md.groovy
b/regression-test/suites/doc/table-design/data-model/duplicate.md.groovy
index e8360f480f2..e75b3837fab 100644
--- a/regression-test/suites/doc/table-design/data-model/duplicate.md.groovy
+++ b/regression-test/suites/doc/table-design/data-model/duplicate.md.groovy
@@ -29,15 +29,15 @@ suite("docs/table-design/data-model/duplicate.md") {
`op_id` BIGINT COMMENT "负责人id",
`op_time` DATETIME COMMENT "处理时间"
)
- DISTRIBUTED BY HASH(`type`) BUCKETS 1
+ DISTRIBUTED BY HASH(`type`) BUCKETS 10
PROPERTIES (
- "replication_allocation" = "tag.location.default: 1"
+ "replication_allocation" = "tag.location.default: 3"
);
desc example_tbl_by_default;
"""
multi_sql """
- CREATE TABLE IF NOT EXISTS
example_tbl_duplicate_without_keys_by_default
+ CREATE TABLE IF NOT EXISTS example_tbl_duplicate
(
`timestamp` DATETIME NOT NULL COMMENT "日志时间",
`type` INT NOT NULL COMMENT "日志类型",
@@ -46,16 +46,16 @@ suite("docs/table-design/data-model/duplicate.md") {
`op_id` BIGINT COMMENT "负责人id",
`op_time` DATETIME COMMENT "处理时间"
)
- DISTRIBUTED BY HASH(`type`) BUCKETS 1
+ DUPLICATE KEY(`timestamp`, `type`, `error_code`)
+ DISTRIBUTED BY HASH(`type`) BUCKETS 10
PROPERTIES (
- "replication_allocation" = "tag.location.default: 1",
- "enable_duplicate_without_keys_by_default" = "true"
+ "replication_allocation" = "tag.location.default: 3"
);
- desc example_tbl_duplicate_without_keys_by_default;
+ desc example_tbl_duplicate;
"""
multi_sql """
- CREATE TABLE IF NOT EXISTS example_tbl_duplicate
+ CREATE TABLE IF NOT EXISTS
example_tbl_duplicate_without_keys_by_default
(
`timestamp` DATETIME NOT NULL COMMENT "日志时间",
`type` INT NOT NULL COMMENT "日志类型",
@@ -64,13 +64,14 @@ suite("docs/table-design/data-model/duplicate.md") {
`op_id` BIGINT COMMENT "负责人id",
`op_time` DATETIME COMMENT "处理时间"
)
- DUPLICATE KEY(`timestamp`, `type`, `error_code`)
- DISTRIBUTED BY HASH(`type`) BUCKETS 1
+ DISTRIBUTED BY HASH(`type`) BUCKETS 10
PROPERTIES (
- "replication_allocation" = "tag.location.default: 1"
+ "replication_allocation" = "tag.location.default: 3",
+ "enable_duplicate_without_keys_by_default" = "true"
);
- desc example_tbl_duplicate;
+ desc example_tbl_duplicate_without_keys_by_default;
"""
+
} catch (Throwable t) {
Assertions.fail("examples in docs/table-design/data-model/duplicate.md
failed to exec, please fix it", t)
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
