This is an automated email from the ASF dual-hosted git repository.
w41ter 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 9410b4e5af Add clean_partitions/clean_tables for RESTORE stmt (#999)
9410b4e5af is described below
commit 9410b4e5af73785661b7f8a23b5bb21d4ef23ad5
Author: walter <[email protected]>
AuthorDate: Wed Aug 21 20:10:53 2024 +0800
Add clean_partitions/clean_tables for RESTORE stmt (#999)
---
.../Data-Definition-Statements/Backup-and-Restore/RESTORE.md | 2 ++
.../Data-Definition-Statements/Backup-and-Restore/RESTORE.md | 4 +++-
.../Data-Definition-Statements/Backup-and-Restore/RESTORE.md | 2 ++
.../Data-Definition-Statements/Backup-and-Restore/RESTORE.md | 2 ++
.../Data-Definition-Statements/Backup-and-Restore/RESTORE.md | 2 ++
.../Data-Definition-Statements/Backup-and-Restore/RESTORE.md | 2 ++
.../Data-Definition-Statements/Backup-and-Restore/RESTORE.md | 2 ++
7 files changed, 15 insertions(+), 1 deletion(-)
diff --git
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
index d176816a3c..12fa68ad39 100644
---
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
+++
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
@@ -61,6 +61,8 @@ illustrate:
- "reserve_dynamic_partition_enable" = "true": Default is false. When this
property is true, the restored table will have the same value of
'dynamic_partition_enable' as before the backup. if this property is not true,
the restored table will set 'dynamic_partition_enable=false'.
- "timeout" = "3600": The task timeout period, the default is one day. in
seconds.
- "meta_version" = 40: Use the specified meta_version to read the previously
backed up metadata. Note that this parameter is used as a temporary solution
and is only used to restore the data backed up by the old version of Doris. The
latest version of the backup data already contains the meta version, no need to
specify it.
+ - "clean_tables": Indicates whether to clean up tables that do not belong to
the restore target. For example, if the target db before the restore has tables
that are not present in the snapshot, specifying `clean_tables` can drop these
extra tables and move them into the recycle bin during the restore.
+ - "clean_partitions": Indicates whether to clean up partitions that do not
belong to the restore target. For example, if the target table before the
restore has partitions that are not present in the snapshot, specifying
`clean_partitions` can drop these extra partitions and move them into the
recycle bin during the restore.
### Example
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
index e863da31c4..6635f9213b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
@@ -59,7 +59,9 @@ PROPERTIES ("key"="value", ...);
- "reserve_replica" = "true"：默认为 false。当该属性为 true 时，会忽略 replication_num
属性，恢复的表或分区的副本数将与备份之前一样。支持多个表或表内多个分区有不同的副本数。
- "reserve_dynamic_partition_enable" = "true"：默认为 false。当该属性为 true
时，恢复的表会保留该表备份之前的'dynamic_partition_enable'属性值。该值不为 true
时，则恢复出来的表的'dynamic_partition_enable'属性值会设置为 false。
- "timeout" = "3600"：任务超时时间，默认为一天。单位秒。
- - "meta_version" = 40：使用指定的 meta_version 来读取之前备份的元数据。注意，该参数作为临时方案，仅用于恢复老版本
Doris 备份的数据。最新版本的备份数据中已经包含 meta version，无需再指定。
+ - "meta_version" = 40：使用指定的 meta_version 来读取之前备份的元数据。注意，该参数作为临时方案，仅用于恢复老版本
Doris 备份的数据。最新版本的备份数据中已经包含 meta version，无需再指定。
+ - "clean_tables": 表示是否清理不属于恢复目标的表。例如，如果恢复之前的目标数据库有备份中不存在的表，指定 `clean_tables`
就可以在恢复期间删除这些额外的表并将其移入回收站。
+ - "clean_partitions"：表示是否清理不属于恢复目标的分区。例如，如果恢复之前的目标表有备份中不存在的分区，指定
`clean_partitions` 就可以在恢复期间删除这些额外的分区并将其移入回收站。
### Example
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
index 8541500331..c0504724c1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
@@ -60,6 +60,8 @@ PROPERTIES ("key"="value", ...);
- <version since="1.2" type="inline"> "reserve_dynamic_partition_enable" =
"true"：默认为 false。当该属性为 true
时，恢复的表会保留该表备份之前的'dynamic_partition_enable'属性值。该值不为true时，则恢复出来的表的'dynamic_partition_enable'属性值会设置为false。</version>
- "timeout" = "3600"：任务超时时间，默认为一天。单位秒。
- "meta_version" = 40：使用指定的 meta_version 来读取之前备份的元数据。注意，该参数作为临时方案，仅用于恢复老版本
Doris 备份的数据。最新版本的备份数据中已经包含 meta version，无需再指定。
+ - <version since="2.0.15" type="inline"> "clean_tables" </version>:
表示是否清理不属于恢复目标的表。例如，如果恢复之前的目标数据库有备份中不存在的表，指定 `clean_tables`
就可以在恢复期间删除这些额外的表并将其移入回收站。
+ - <version since="2.0.15" type="inline"> "clean_partitions"
</version>：表示是否清理不属于恢复目标的分区。例如，如果恢复之前的目标表有备份中不存在的分区，指定 `clean_partitions`
就可以在恢复期间删除这些额外的分区并将其移入回收站。
### Example
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
index 8541500331..6696dd62e7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
@@ -60,6 +60,8 @@ PROPERTIES ("key"="value", ...);
- <version since="1.2" type="inline"> "reserve_dynamic_partition_enable" =
"true"：默认为 false。当该属性为 true
时，恢复的表会保留该表备份之前的'dynamic_partition_enable'属性值。该值不为true时，则恢复出来的表的'dynamic_partition_enable'属性值会设置为false。</version>
- "timeout" = "3600"：任务超时时间，默认为一天。单位秒。
- "meta_version" = 40：使用指定的 meta_version 来读取之前备份的元数据。注意，该参数作为临时方案，仅用于恢复老版本
Doris 备份的数据。最新版本的备份数据中已经包含 meta version，无需再指定。
+ - <version since="2.1.6" type="inline"> "clean_tables" </version>:
表示是否清理不属于恢复目标的表。例如，如果恢复之前的目标数据库有备份中不存在的表，指定 `clean_tables`
就可以在恢复期间删除这些额外的表并将其移入回收站。
+ - <version since="2.1.6" type="inline"> "clean_partitions
</version>"：表示是否清理不属于恢复目标的分区。例如，如果恢复之前的目标表有备份中不存在的分区，指定 `clean_partitions`
就可以在恢复期间删除这些额外的分区并将其移入回收站。
### Example
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
index d176816a3c..357fc40d60 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
@@ -61,6 +61,8 @@ illustrate:
- "reserve_dynamic_partition_enable" = "true": Default is false. When this
property is true, the restored table will have the same value of
'dynamic_partition_enable' as before the backup. if this property is not true,
the restored table will set 'dynamic_partition_enable=false'.
- "timeout" = "3600": The task timeout period, the default is one day. in
seconds.
- "meta_version" = 40: Use the specified meta_version to read the previously
backed up metadata. Note that this parameter is used as a temporary solution
and is only used to restore the data backed up by the old version of Doris. The
latest version of the backup data already contains the meta version, no need to
specify it.
+ - <version since="2.0.15" type="inline"> "clean_tables" </version>:
Indicates whether to clean up tables that do not belong to the restore target.
For example, if the target db before the restore has tables that are not
present in the snapshot, specifying `clean_tables` can drop these extra tables
and move them into the recycle bin during the restore.
+ - <version since="2.0.15" type="inline"> "clean_partitions" </version>:
Indicates whether to clean up partitions that do not belong to the restore
target. For example, if the target table before the restore has partitions that
are not present in the snapshot, specifying `clean_partitions` can drop these
extra partitions and move them into the recycle bin during the restore.
### Example
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
index d176816a3c..888c8bbfb6 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
@@ -61,6 +61,8 @@ illustrate:
- "reserve_dynamic_partition_enable" = "true": Default is false. When this
property is true, the restored table will have the same value of
'dynamic_partition_enable' as before the backup. if this property is not true,
the restored table will set 'dynamic_partition_enable=false'.
- "timeout" = "3600": The task timeout period, the default is one day. in
seconds.
- "meta_version" = 40: Use the specified meta_version to read the previously
backed up metadata. Note that this parameter is used as a temporary solution
and is only used to restore the data backed up by the old version of Doris. The
latest version of the backup data already contains the meta version, no need to
specify it.
+ - <version since="2.1.6" type="inline"> "clean_tables" </version>: Indicates
whether to clean up tables that do not belong to the restore target. For
example, if the target db before the restore has tables that are not present in
the snapshot, specifying `clean_tables` can drop these extra tables and move
them into the recycle bin during the restore.
+ - <version since="2.1.6" type="inline"> "clean_partitions" </version>:
Indicates whether to clean up partitions that do not belong to the restore
target. For example, if the target table before the restore has partitions that
are not present in the snapshot, specifying `clean_partitions` can drop these
extra partitions and move them into the recycle bin during the restore.
### Example
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
b/versioned_docs/version-3.0/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
index d176816a3c..12fa68ad39 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-statements/Data-Definition-Statements/Backup-and-Restore/RESTORE.md
@@ -61,6 +61,8 @@ illustrate:
- "reserve_dynamic_partition_enable" = "true": Default is false. When this
property is true, the restored table will have the same value of
'dynamic_partition_enable' as before the backup. if this property is not true,
the restored table will set 'dynamic_partition_enable=false'.
- "timeout" = "3600": The task timeout period, the default is one day. in
seconds.
- "meta_version" = 40: Use the specified meta_version to read the previously
backed up metadata. Note that this parameter is used as a temporary solution
and is only used to restore the data backed up by the old version of Doris. The
latest version of the backup data already contains the meta version, no need to
specify it.
+ - "clean_tables": Indicates whether to clean up tables that do not belong to
the restore target. For example, if the target db before the restore has tables
that are not present in the snapshot, specifying `clean_tables` can drop these
extra tables and move them into the recycle bin during the restore.
+ - "clean_partitions": Indicates whether to clean up partitions that do not
belong to the restore target. For example, if the target table before the
restore has partitions that are not present in the snapshot, specifying
`clean_partitions` can drop these extra partitions and move them into the
recycle bin during the restore.
### Example
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
