Copilot commented on code in PR #3465:
URL: https://github.com/apache/doris-website/pull/3465#discussion_r2937920498
##########
versioned_docs/version-4.x/data-operate/import/group-commit-manual.md:
##########
@@ -52,6 +52,66 @@ PROPERTIES (
);
```
+### Table Property Configuration
+
+you can set the default Group Commit mode at the table level. When Stream Load
does not set the `group_commit` HTTP Header, the mode from the table property
will be used.
Review Comment:
The sentence starts with a lowercase "you"; please capitalize it (and
consider capitalizing "HTTP header" consistently) to match the rest of the
doc’s style.
##########
versioned_docs/version-4.x/data-operate/import/group-commit-manual.md:
##########
@@ -52,6 +52,66 @@ PROPERTIES (
);
```
+### Table Property Configuration
+
+you can set the default Group Commit mode at the table level. When Stream Load
does not set the `group_commit` HTTP Header, the mode from the table property
will be used.
+
+**Configure during table creation:**
+
+```sql
+CREATE TABLE `dt` (
+ `id` int(11) NOT NULL,
+ `name` varchar(50) NULL,
+ `score` int(11) NULL
+) ENGINE=OLAP
+DUPLICATE KEY(`id`)
+DISTRIBUTED BY HASH(`id`) BUCKETS 1
+PROPERTIES (
+ "replication_num" = "1",
+ "group_commit_mode" = "async_mode"
+);
+```
+
+**Modify table property:**
+
+```sql
+# Modify to synchronous mode
+ALTER TABLE dt SET ("group_commit_mode" = "sync_mode");
+
+# Disable Group Commit
+ALTER TABLE dt SET ("group_commit_mode" = "off_mode");
+```
+
+**View table property:**
+
+`SHOW CREATE TABLE` displays the `group_commit_mode` property (unless the
value is `off_mode`):
+
+```sql
+mysql> SHOW CREATE TABLE dt;
++-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table | Create Table
|
++-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| dt | CREATE TABLE `dt` (
+ `id` int(11) NOT NULL,
+ `name` varchar(50) NULL,
+ `score` int(11) NULL
+) ENGINE=OLAP
+DUPLICATE KEY(`id`)
+DISTRIBUTED BY HASH(`id`) BUCKETS 1
+PROPERTIES (
+"replication_num" = "1",
+"group_commit_mode" = "async_mode",
+"store_row_to_col" = "true"
+) |
++-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Review Comment:
This `SHOW CREATE TABLE` example is formatted like MySQL’s tabular output,
but the multi-line `Create Table` value isn’t wrapped with `| ... |` on each
continued line, which makes the snippet look malformed. Consider switching to
`SHOW CREATE TABLE dt\G` (vertical output) or showing only the relevant
`PROPERTIES` portion to keep the example unambiguous.
##########
i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/group-commit-manual.md:
##########
@@ -52,6 +52,66 @@ PROPERTIES (
);
```
+### 表属性配置
+
+可以在表级别设置默认的 Group Commit 模式。当 Stream Load 未设置 `group_commit` HTTP Header
时,将使用表属性中的模式。
+
+**建表时配置:**
+
+```sql
+CREATE TABLE `dt` (
+ `id` int(11) NOT NULL,
+ `name` varchar(50) NULL,
+ `score` int(11) NULL
+) ENGINE=OLAP
+DUPLICATE KEY(`id`)
+DISTRIBUTED BY HASH(`id`) BUCKETS 1
+PROPERTIES (
+ "replication_num" = "1",
+ "group_commit_mode" = "async_mode"
+);
+```
+
+**修改表属性:**
+
+```sql
+# 修改为同步模式
+ALTER TABLE dt SET ("group_commit_mode" = "sync_mode");
+
+# 关闭 Group Commit
+ALTER TABLE dt SET ("group_commit_mode" = "off_mode");
+```
+
+**查看表属性:**
+
+`SHOW CREATE TABLE` 会显示 `group_commit_mode` 属性(除非值为 `off_mode`):
+
+```sql
+mysql> SHOW CREATE TABLE dt;
++-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table | Create Table
|
++-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| dt | CREATE TABLE `dt` (
Review Comment:
这个 `SHOW CREATE TABLE` 示例采用了 MySQL 的表格输出样式,但 `Create Table` 字段是多行内容,后续行没有继续用
`| ... |` 包裹,看起来像是输出被截断/格式错误。建议改用 `SHOW CREATE TABLE dt\G`(竖排输出),或仅展示包含
`group_commit_mode` 的 `PROPERTIES` 片段,避免歧义。
##########
i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/data-operate/import/group-commit-manual.md:
##########
@@ -52,6 +52,66 @@ PROPERTIES (
);
```
+### 表属性配置
+
+可以在表级别设置默认的 Group Commit 模式。当 Stream Load 未设置 `group_commit` HTTP Header
时,将使用表属性中的模式。
+
+**建表时配置:**
+
+```sql
+CREATE TABLE `dt` (
+ `id` int(11) NOT NULL,
+ `name` varchar(50) NULL,
+ `score` int(11) NULL
+) ENGINE=OLAP
+DUPLICATE KEY(`id`)
+DISTRIBUTED BY HASH(`id`) BUCKETS 1
+PROPERTIES (
+ "replication_num" = "1",
+ "group_commit_mode" = "async_mode"
+);
+```
+
+**修改表属性:**
+
+```sql
+# 修改为同步模式
+ALTER TABLE dt SET ("group_commit_mode" = "sync_mode");
+
+# 关闭 Group Commit
+ALTER TABLE dt SET ("group_commit_mode" = "off_mode");
+```
+
+**查看表属性:**
+
+`SHOW CREATE TABLE` 会显示 `group_commit_mode` 属性(除非值为 `off_mode`):
+
+```sql
+mysql> SHOW CREATE TABLE dt;
++-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table | Create Table
|
++-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| dt | CREATE TABLE `dt` (
Review Comment:
这个 `SHOW CREATE TABLE` 示例采用了 MySQL 的表格输出样式,但 `Create Table` 字段是多行内容,后续行没有继续用
`| ... |` 包裹,看起来像是输出被截断/格式错误。建议改用 `SHOW CREATE TABLE dt\G`(竖排输出),或仅展示包含
`group_commit_mode` 的 `PROPERTIES` 片段,避免歧义。
##########
docs/data-operate/import/group-commit-manual.md:
##########
@@ -52,6 +52,67 @@ PROPERTIES (
);
```
+### Table Property Configuration
+
+you can set the default Group Commit mode at the table level. When Stream Load
does not set the `group_commit` HTTP Header, the mode from the table property
will be used.
+
+**Configure during table creation:**
+
+```sql
+CREATE TABLE `dt` (
+ `id` int(11) NOT NULL,
+ `name` varchar(50) NULL,
+ `score` int(11) NULL
+) ENGINE=OLAP
+DUPLICATE KEY(`id`)
+DISTRIBUTED BY HASH(`id`) BUCKETS 1
+PROPERTIES (
+ "replication_num" = "1",
+ "group_commit_mode" = "async_mode"
+);
+```
+
+**Modify table property:**
+
+```sql
+# Modify to synchronous mode
+ALTER TABLE dt SET ("group_commit_mode" = "sync_mode");
+
+# Disable Group Commit
+ALTER TABLE dt SET ("group_commit_mode" = "off_mode");
+```
+
+**View table property:**
+
+`SHOW CREATE TABLE` displays the `group_commit_mode` property (unless the
value is `off_mode`):
+
+```sql
+mysql> SHOW CREATE TABLE dt;
++-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table | Create Table
|
++-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| dt | CREATE TABLE `dt` (
Review Comment:
This `SHOW CREATE TABLE` example is formatted like MySQL’s tabular output,
but the multi-line `Create Table` value isn’t wrapped with `| ... |` on each
continued line, which makes the snippet look malformed. Consider switching to
`SHOW CREATE TABLE dt\G` (vertical output) or showing only the relevant
`PROPERTIES` portion to keep the example unambiguous.
##########
docs/data-operate/import/group-commit-manual.md:
##########
@@ -52,6 +52,67 @@ PROPERTIES (
);
```
+### Table Property Configuration
+
+you can set the default Group Commit mode at the table level. When Stream Load
does not set the `group_commit` HTTP Header, the mode from the table property
will be used.
Review Comment:
The sentence starts with a lowercase "you"; please capitalize it (and
consider capitalizing "HTTP header" consistently) to match the rest of the
doc’s style.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]