This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 e9229911c4 [doc]delete sql manual docs that mismatched of code in 2.0
(#707)
e9229911c4 is described below
commit e9229911c41864b2bf0bbfae4b57f01db93e9421
Author: wangqt <mongo3...@gmail.com>
AuthorDate: Fri Jun 21 16:46:28 2024 +0800
[doc]delete sql manual docs that mismatched of code in 2.0 (#707)
---
.../ADMIN-SET-PARTITION-VERSION.md | 67 -----------------
.../ADMIN-SET-REPLICA-VERSION.md | 85 ----------------------
.../ADMIN-SET-TABLE-STATUS.md | 84 ---------------------
.../ADMIN-SET-PARTITION-VERSION.md | 67 -----------------
.../ADMIN-SET-REPLICA-VERSION.md | 83 ---------------------
.../ADMIN-SET-TABLE-STATUS.md | 81 ---------------------
versioned_sidebars/version-2.0-sidebars.json | 5 +-
7 files changed, 1 insertion(+), 471 deletions(-)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-PARTITION-VERSION.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-PARTITION-VERSION.md
deleted file mode 100644
index 3ce8d43cd6..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-PARTITION-VERSION.md
+++ /dev/null
@@ -1,67 +0,0 @@
----
-{
- "title": "ADMIN-SET-PARTITION-VERSION",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ADMIN-SET-PARTITION-VERSION
-
-### Name
-
-ADMIN SET PARTITION VERSION
-
-### Description
-
-该语句用于手动改变指定分区的可见版本。
-
-在某些特殊情况下，元数据中分区的版本有可能和实际副本的版本不一致，该命令可手动改变元数据中分区的版本。
-
-语法：
-
-```sql
-ADMIN SET TABLE table_name PARTITION VERSION
- PROPERTIES ("key" = "value", ...);
-```
-
-目前支持如下属性：
-
-1. "partition_id"：必需。指定一个 Partition Id.
-2. "visible_version"：必需。指定 Version.
-
-> 注意：
->
-> 设置分区的版本需要先确认Be机器上实际副本的版本，此命令一般只用于紧急故障修复，请谨慎操作。
-
-### Example
-
-1. 设置 partition 1769152 在 FE 元数据上的版本为 100。
-
-```sql
-ADMIN SET TABLE tbl1 PARTITION VERSION PROPERTIES("partition_id" = "1769152",
"visible_version" = "100");
-```
-
-### Keywords
-
- ADMIN, SET, PARTITION, VERSION
-
-### Best Practice
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-REPLICA-VERSION.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-REPLICA-VERSION.md
deleted file mode 100644
index de318cabfc..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-REPLICA-VERSION.md
+++ /dev/null
@@ -1,85 +0,0 @@
----
-{
- "title": "ADMIN-SET-REPLICA-VERSION",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ADMIN-SET-REPLICA-VERSION
-
-### Name
-
-ADMIN SET REPLICA VERSION
-
-### Description
-
-该语句用于设置指定副本的版本、最大成功版本、最大失败版本。
-
-该命令目前仅用于在程序异常情况下，手动修复副本的版本，从而使得副本从异常状态恢复过来。
-
-语法：
-
-```sql
-ADMIN SET REPLICA VERSION
- PROPERTIES ("key" = "value", ...);
-```
-
- 目前支持如下属性：
-
-1. `tablet_id`：必需。指定一个 Tablet Id.
-2. `backend_id`：必需。指定 Backend Id.
-3. `version`：可选。设置副本的版本.
-4. `last_success_version`：可选。设置副本的最大成功版本.
-5. `last_failed_version`：可选。设置副本的最大失败版本。
-
-
-如果指定的副本不存在，则会被忽略。
-
-> 注意：
->
-> 修改这几个数值，可能会导致后面数据读写失败，造成数据不一致，请谨慎操作！
->
-> 修改之前先记录原来的值。修改完毕之后，对表进行读写验证，如果读写失败，请恢复原来的值！但可能会恢复失败！
->
-> 严禁对正在写入数据的tablet进行操作 ！
-
-
-### Example
-
- 1. 清除 tablet 10003 在 BE 10001 上的副本状态失败标志。
-
-```sql
-ADMIN SET REPLICA VERSION PROPERTIES("tablet_id" = "10003", "backend_id" =
"10001", "last_failed_version" = "-1");
-```
-
-2. 设置 tablet 10003 在 BE 10001 上的副本版本号为 1004。
-
-```sql
-ADMIN SET REPLICA VERSION PROPERTIES("tablet_id" = "10003", "backend_id" =
"10001", "version" = "1004");
-```
-
-### Keywords
-
- ADMIN, SET, REPLICA, VERSION
-
-### Best Practice
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-TABLE-STATUS.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-TABLE-STATUS.md
deleted file mode 100644
index 8a0d69503d..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-TABLE-STATUS.md
+++ /dev/null
@@ -1,84 +0,0 @@
----
-{
- "title": "ADMIN-SET-TABLE-STATUS",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ADMIN-SET-TABLE-STATUS
-
-### Name
-
-ADMIN SET TABLE STATUS
-
-### Description
-
-该语句用于设置指定表的状态，仅支持OLAP表。
-
-该命令目前仅用于手动将 OLAP 表状态设置为指定状态，从而使得某些由于表状态被阻碍的任务能够继续运行。
-
-语法：
-
-```sql
-ADMIN SET TABLE table_name STATUS
- PROPERTIES ("key" = "value", ...);
-```
-
-目前支持以下属性：
-
-1. "state"：必需。指定一个目标状态，将会修改 OLAP 表的状态至此状态。
-
-> 当前可修改的目标状态包括：
->
-> 1. NORMAL
-> 2. ROLLUP
-> 3. SCHEMA_CHANGE
-> 4. BACKUP
-> 5. RESTORE
-> 6. WAITING_STABLE
->
-> 如果表的状态已经是指定的状态，则会被忽略。
-
-**注意：此命令一般只用于紧急故障修复，请谨慎操作。**
-
-### Example
-
-1. 设置表 tbl1 的状态为 NORMAL。
-
-```sql
-admin set table tbl1 status properties("state" = "NORMAL");
-```
-
-2. 设置表 tbl2 的状态为 SCHEMA_CHANGE。
-
-```sql
-admin set table test_set_table_status status properties("state" =
"SCHEMA_CHANGE");
-```
-
-### Keywords
-
- ADMIN, SET, TABLE, STATUS
-
-### Best Practice
-
-
-
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-PARTITION-VERSION.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-PARTITION-VERSION.md
deleted file mode 100644
index 14e63036bd..0000000000
---
a/versioned_docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-PARTITION-VERSION.md
+++ /dev/null
@@ -1,67 +0,0 @@
----
-{
- "title": "ADMIN-SET-PARTITION-VERSION",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ADMIN-SET-PARTITION-VERSION
-
-### Name
-
-ADMIN SET PARTITION VERSION
-
-### Description
-
-This statement is used to set the version of the specified partition.
-
-In certain cases, the version of the partition in the metadata may not be
consistent with the version of the actual replica. This command can manually
set the version of the partition in the metadata.
-
-grammar:
-
-```sql
-ADMIN SET TABLE table_name PARTITION VERSION
- PROPERTIES ("key" = "value", ...);
-```
-
-The following properties are currently supported:
-
-1. "partition_id": Required. Specify a Partition Id.
-2. "visible_version": Required. Specify Version.
-
-> Note:
->
-> It is necessary to first confirm the version of the actual replica on the Be
before set the version of the partition. This command is generally only used
for emergency troubleshooting, please proceed with caution.
-
-### Example
-
-1. Set the version of partition 1769152 to 100.
-
-```sql
-ADMIN SET TABLE tbl1 PARTITION VERSION PROPERTIES("partition_id" = "1769152",
"visible_version" = "100");
-```
-
-### Keywords
-
- ADMIN, SET, PARTITION, VERSION
-
-### Best Practice
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-REPLICA-VERSION.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-REPLICA-VERSION.md
deleted file mode 100644
index aae7f93bbf..0000000000
---
a/versioned_docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-REPLICA-VERSION.md
+++ /dev/null
@@ -1,83 +0,0 @@
----
-{
- "title": "ADMIN-SET-REPLICA-VERSION",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ADMIN-SET-REPLICA-VERSION
-
-### Name
-
-ADMIN SET REPLICA VERSION
-
-### Description
-
-This statement is used to set the version, maximum success version, and
maximum failure version of the specified replica.
-
-This command is currently only used to manually repair the replica version
when the program is abnormal, so that the replica can recover from the abnormal
state.
-
-grammar:
-
-```sql
-ADMIN SET REPLICA VERSION
- PROPERTIES ("key" = "value", ...);
-```
-
-The following properties are currently supported:
-
-1. `tablet_id`: Required. Specify a Tablet Id.
-2. `backend_id`: Required. Specify Backend Id.
-3. `version`: Optional. Set the replica version.
-4. `last_success_version`: Optional. Set the replica max success version.
-5. `last_failed_version`: Optional. Set the replica max failed version.
-
-If the specified replica does not exist, it will be ignored.
-
-> Note:
->
-> Modifying these values may cause subsequent data reading and writing
failures, resulting in data inconsistency. Please operate with caution!
->
-> Record the original value before modifying it. After the modification is
completed, verify the read and write of the table. If the read and write fail,
please restore the original value! But recovery may fail!
->
-> It is strictly prohibited to operate the tablet that is writing data!
-
-### Example
-
- 1. Clear the replica failed version of tablet 10003 on BE 10001.
-
- ```sql
-ADMIN SET REPLICA VERSION PROPERTIES("tablet_id" = "10003", "backend_id" =
"10001", "last_failed_version" = "-1");
- ```
-
-2. Set the replica status of tablet 10003 on BE 10001 to ok.
-
-```sql
-ADMIN SET REPLICA VERSION PROPERTIES("tablet_id" = "10003", "backend_id" =
"10001", "version" = "1004");
-```
-
-### Keywords
-
- ADMIN, SET, REPLICA, VERSION
-
-### Best Practice
-
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-TABLE-STATUS.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-TABLE-STATUS.md
deleted file mode 100644
index fde3b5ed4b..0000000000
---
a/versioned_docs/version-2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-TABLE-STATUS.md
+++ /dev/null
@@ -1,81 +0,0 @@
----
-{
- "title": "ADMIN-SET-TABLE-STATUS",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ADMIN-SET-TABLE-STATUS
-
-### Name
-
-ADMIN SET TABLE STATUS
-
-### Description
-
-This statement is used to set the state of the specified table. Only supports
OLAP tables.
-
-This command is currently only used to manually set the OLAP table state to
the specified state, allowing some jobs that are stuck by the table state to
continue running.
-
-grammar:
-
-```sql
-ADMIN SET TABLE table_name STATUS
- PROPERTIES ("key" = "value", ...);
-```
-
-The following properties are currently supported:
-
-1. "state"：Required. Specifying a target state then the state of the OLAP
table will change to this state.
-
-> The current target states include:
->
-> 1. NORMAL
-> 2. ROLLUP
-> 3. SCHEMA_CHANGE
-> 4. BACKUP
-> 5. RESTORE
-> 6. WAITING_STABLE
->
-> If the current state of the table is already the specified state, it will be
ignored.
-
-**Note: This command is generally only used for emergency fault repair, please
proceed with caution.**
-
-### Example
-
-1. Set the state of table tbl1 to NORMAL.
-
-```sql
-admin set table tbl1 status properties("state" = "NORMAL");
-```
-
-2. Set the state of table tbl2 to SCHEMA_CHANGE
-
-```sql
-admin set table test_set_table_status status properties("state" =
"SCHEMA_CHANGE");
-```
-
-### Keywords
-
- ADMIN, SET, TABLE, STATUS
-
-### Best Practice
\ No newline at end of file
diff --git a/versioned_sidebars/version-2.0-sidebars.json
b/versioned_sidebars/version-2.0-sidebars.json
index cc467cd085..8130d8bcac 100644
--- a/versioned_sidebars/version-2.0-sidebars.json
+++ b/versioned_sidebars/version-2.0-sidebars.json
@@ -1098,9 +1098,6 @@
"sql-manual/sql-reference/Database-Administration-Statements/INSTALL-PLUGIN",
"sql-manual/sql-reference/Database-Administration-Statements/UNINSTALL-PLUGIN",
"sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-REPLICA-STATUS",
-
"sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-REPLICA-VERSION",
-
"sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-PARTITION-VERSION",
-
"sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SET-TABLE-STATUS",
"sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SHOW-REPLICA-DISTRIBUTION",
"sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SHOW-REPLICA-STATUS",
"sql-manual/sql-reference/Database-Administration-Statements/ADMIN-REPAIR-TABLE",
@@ -1417,4 +1414,4 @@
]
}
]
-}
\ No newline at end of file
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
