This is an automated email from the ASF dual-hosted git repository.
kassiez 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 2423cc0202f [doc](trancate table) address comment and update english
doc by LLM (#1782)
2423cc0202f is described below
commit 2423cc0202fe6bd04b694a89f288cabd2b942caf
Author: zhannngchen <zhangc...@selectdb.com>
AuthorDate: Wed Jan 15 15:01:12 2025 +0800
[doc](trancate table) address comment and update english doc by LLM (#1782)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [x] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [x] Checked by AI
- [x] Test Cases Built
---
docs/data-operate/delete/truncate-manual.md | 32 ++++++++++++----------
.../current/data-operate/delete/truncate-manual.md | 18 ++++++------
.../data-operate/delete/truncate-manual.md | 18 ++++++------
.../data-operate/delete/truncate-manual.md | 18 ++++++------
.../data-operate/delete/truncate-manual.md | 32 ++++++++++++----------
.../data-operate/delete/truncate-manual.md | 32 ++++++++++++----------
6 files changed, 75 insertions(+), 75 deletions(-)
diff --git a/docs/data-operate/delete/truncate-manual.md
b/docs/data-operate/delete/truncate-manual.md
index c0fb7f8e26a..cf8b8ddb865 100644
--- a/docs/data-operate/delete/truncate-manual.md
+++ b/docs/data-operate/delete/truncate-manual.md
@@ -26,32 +26,34 @@ under the License.
# Truncate
-This statement is used to clear the data of a specified table or partition in
Doris
+Use this statement to clear data from a specified table and its partitions.
## Syntax
-```SQL
-TRUNCATE TABLE [db.]tbl[ PARTITION(p1, p2, ...)];
+```sql
+TRUNCATE TABLE [db.]tbl [PARTITION(p1, p2, ...)];
```
-- This statement only clears the data within a table or partition but
preserves the table or partition itself.
-- Unlike DELETE, this statement can only clear the specified table or
partition as a whole and cannot be added with filter conditions.
-- Unlike DELETE, truncating data will not affect query performance.
-- The data deleted by this operation is not recoverable.
-- When using this command, the table status must be NORMAL, which means that
tables undergoing SCHEMA CHANGE can not be truncated.
-- This command may cause ongoing imports to fail.
+- This statement clears the data but retains the table or partition structure.
-## Example
+- Unlike DELETE, TRUNCATE only performs metadata operations, making it faster
and not affecting query performance.
-1. Truncate the table `tbl` under `example_db`.
+- Data removed by this operation cannot be recovered.
-```SQL
+- The table status must be NORMAL, and there should be no ongoing SCHEMA
CHANGE operations.
+
+- This command may cause ongoing import tasks to fail.
+
+## Examples
+
+**1. Clear the table `tbl` in the `example_db` database**
+
+```sql
TRUNCATE TABLE example_db.tbl;
```
-2. Truncate partitions `p1` and `p2` of table `tbl`.
+**2. Clear the `p1` and `p2` partitions of the table `tbl`**
-```SQL
+```sql
TRUNCATE TABLE tbl PARTITION(p1, p2);
```
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/delete/truncate-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/delete/truncate-manual.md
index ed99627296e..50d4bf576d3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/delete/truncate-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/delete/truncate-manual.md
@@ -29,31 +29,29 @@ under the License.
## 语法
```sql
-TRUNCATE TABLE [db.]tbl[ PARTITION(p1, p2, ...)];
+TRUNCATE TABLE [db.]tbl [PARTITION(p1, p2, ...)];
```
-- 该语句清空数据，但保留表或分区。
+- 该语句清空数据，但保留表或分区结构。
-- 不同于 DELETE，该语句只能整体清空指定的表或分区，不能添加过滤条件。
-
-- 不同于 DELETE，使用该方式清空数据不会对查询性能造成影响。
+- 与 DELETE 不同，TRUNCATE 仅进行元数据操作，速度快且不会影响查询性能。
- 该操作删除的数据不可恢复。
-- 使用该命令时，表状态需为 NORMAL，即不允许正在进行 SCHEMA CHANGE 等操作。
+- 表状态需为 NORMAL，不能有正在进行的 SCHEMA CHANGE 等操作。
-- 该命令可能会导致正在进行的导入失败。
+- 该命令可能会导致正在进行的导入任务失败。
## 示例
**1. 清空 example_db 下的表 tbl**
-```SQL
+```sql
TRUNCATE TABLE example_db.tbl;
```
**2. 清空表 tbl 的 p1 和 p2 分区**
-```SQL
+```sql
TRUNCATE TABLE tbl PARTITION(p1, p2);
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/delete/truncate-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/delete/truncate-manual.md
index ed99627296e..50d4bf576d3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/delete/truncate-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/delete/truncate-manual.md
@@ -29,31 +29,29 @@ under the License.
## 语法
```sql
-TRUNCATE TABLE [db.]tbl[ PARTITION(p1, p2, ...)];
+TRUNCATE TABLE [db.]tbl [PARTITION(p1, p2, ...)];
```
-- 该语句清空数据，但保留表或分区。
+- 该语句清空数据，但保留表或分区结构。
-- 不同于 DELETE，该语句只能整体清空指定的表或分区，不能添加过滤条件。
-
-- 不同于 DELETE，使用该方式清空数据不会对查询性能造成影响。
+- 与 DELETE 不同，TRUNCATE 仅进行元数据操作，速度快且不会影响查询性能。
- 该操作删除的数据不可恢复。
-- 使用该命令时，表状态需为 NORMAL，即不允许正在进行 SCHEMA CHANGE 等操作。
+- 表状态需为 NORMAL，不能有正在进行的 SCHEMA CHANGE 等操作。
-- 该命令可能会导致正在进行的导入失败。
+- 该命令可能会导致正在进行的导入任务失败。
## 示例
**1. 清空 example_db 下的表 tbl**
-```SQL
+```sql
TRUNCATE TABLE example_db.tbl;
```
**2. 清空表 tbl 的 p1 和 p2 分区**
-```SQL
+```sql
TRUNCATE TABLE tbl PARTITION(p1, p2);
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/delete/truncate-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/delete/truncate-manual.md
index ed99627296e..50d4bf576d3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/delete/truncate-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/delete/truncate-manual.md
@@ -29,31 +29,29 @@ under the License.
## 语法
```sql
-TRUNCATE TABLE [db.]tbl[ PARTITION(p1, p2, ...)];
+TRUNCATE TABLE [db.]tbl [PARTITION(p1, p2, ...)];
```
-- 该语句清空数据，但保留表或分区。
+- 该语句清空数据，但保留表或分区结构。
-- 不同于 DELETE，该语句只能整体清空指定的表或分区，不能添加过滤条件。
-
-- 不同于 DELETE，使用该方式清空数据不会对查询性能造成影响。
+- 与 DELETE 不同，TRUNCATE 仅进行元数据操作，速度快且不会影响查询性能。
- 该操作删除的数据不可恢复。
-- 使用该命令时，表状态需为 NORMAL，即不允许正在进行 SCHEMA CHANGE 等操作。
+- 表状态需为 NORMAL，不能有正在进行的 SCHEMA CHANGE 等操作。
-- 该命令可能会导致正在进行的导入失败。
+- 该命令可能会导致正在进行的导入任务失败。
## 示例
**1. 清空 example_db 下的表 tbl**
-```SQL
+```sql
TRUNCATE TABLE example_db.tbl;
```
**2. 清空表 tbl 的 p1 和 p2 分区**
-```SQL
+```sql
TRUNCATE TABLE tbl PARTITION(p1, p2);
-```
\ No newline at end of file
+```
diff --git a/versioned_docs/version-2.1/data-operate/delete/truncate-manual.md
b/versioned_docs/version-2.1/data-operate/delete/truncate-manual.md
index 6f22761ed15..cf8b8ddb865 100644
--- a/versioned_docs/version-2.1/data-operate/delete/truncate-manual.md
+++ b/versioned_docs/version-2.1/data-operate/delete/truncate-manual.md
@@ -26,32 +26,34 @@ under the License.
# Truncate
-This statement is used to clear the data of a specified table or partition in
Doris
+Use this statement to clear data from a specified table and its partitions.
## Syntax
-```SQL
-TRUNCATE TABLE [db.]tbl[ PARTITION(p1, p2, ...)];
+```sql
+TRUNCATE TABLE [db.]tbl [PARTITION(p1, p2, ...)];
```
-- This statement only clears the data within a table or partition but
preserves the table or partition itself.
-- Unlike DELETE, this statement can only clear the specified table or
partition as a whole and cannot be added with filter conditions.
-- Unlike DELETE, truncating data will not affect query performance.
-- The data deleted by this operation can be recovered through the RECOVER
statement(for a period of time). See
[RECOVER](../../../../sql-manual/sql-statements/recycle/RECOVER) statement for
details. If you execute command with FORCE, the data will be deleted directly
and cannot be recovered, this operation is generally not recommended.
-- When using this command, the table status must be NORMAL, which means that
tables undergoing SCHEMA CHANGE can not be truncated.
-- This command may cause ongoing imports to fail.
+- This statement clears the data but retains the table or partition structure.
-## Example
+- Unlike DELETE, TRUNCATE only performs metadata operations, making it faster
and not affecting query performance.
-1. Truncate the table `tbl` under `example_db`.
+- Data removed by this operation cannot be recovered.
-```SQL
+- The table status must be NORMAL, and there should be no ongoing SCHEMA
CHANGE operations.
+
+- This command may cause ongoing import tasks to fail.
+
+## Examples
+
+**1. Clear the table `tbl` in the `example_db` database**
+
+```sql
TRUNCATE TABLE example_db.tbl;
```
-2. Truncate partitions `p1` and `p2` of table `tbl`.
+**2. Clear the `p1` and `p2` partitions of the table `tbl`**
-```SQL
+```sql
TRUNCATE TABLE tbl PARTITION(p1, p2);
```
-
diff --git a/versioned_docs/version-3.0/data-operate/delete/truncate-manual.md
b/versioned_docs/version-3.0/data-operate/delete/truncate-manual.md
index 6f22761ed15..cf8b8ddb865 100644
--- a/versioned_docs/version-3.0/data-operate/delete/truncate-manual.md
+++ b/versioned_docs/version-3.0/data-operate/delete/truncate-manual.md
@@ -26,32 +26,34 @@ under the License.
# Truncate
-This statement is used to clear the data of a specified table or partition in
Doris
+Use this statement to clear data from a specified table and its partitions.
## Syntax
-```SQL
-TRUNCATE TABLE [db.]tbl[ PARTITION(p1, p2, ...)];
+```sql
+TRUNCATE TABLE [db.]tbl [PARTITION(p1, p2, ...)];
```
-- This statement only clears the data within a table or partition but
preserves the table or partition itself.
-- Unlike DELETE, this statement can only clear the specified table or
partition as a whole and cannot be added with filter conditions.
-- Unlike DELETE, truncating data will not affect query performance.
-- The data deleted by this operation can be recovered through the RECOVER
statement(for a period of time). See
[RECOVER](../../../../sql-manual/sql-statements/recycle/RECOVER) statement for
details. If you execute command with FORCE, the data will be deleted directly
and cannot be recovered, this operation is generally not recommended.
-- When using this command, the table status must be NORMAL, which means that
tables undergoing SCHEMA CHANGE can not be truncated.
-- This command may cause ongoing imports to fail.
+- This statement clears the data but retains the table or partition structure.
-## Example
+- Unlike DELETE, TRUNCATE only performs metadata operations, making it faster
and not affecting query performance.
-1. Truncate the table `tbl` under `example_db`.
+- Data removed by this operation cannot be recovered.
-```SQL
+- The table status must be NORMAL, and there should be no ongoing SCHEMA
CHANGE operations.
+
+- This command may cause ongoing import tasks to fail.
+
+## Examples
+
+**1. Clear the table `tbl` in the `example_db` database**
+
+```sql
TRUNCATE TABLE example_db.tbl;
```
-2. Truncate partitions `p1` and `p2` of table `tbl`.
+**2. Clear the `p1` and `p2` partitions of the table `tbl`**
-```SQL
+```sql
TRUNCATE TABLE tbl PARTITION(p1, p2);
```
-
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
