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 1fb7a6bddad fix dead link, remove wrong function in wrong version
(#1943)
1fb7a6bddad is described below
commit 1fb7a6bddada43eb1c1648ad92c23b4de2fd70b1
Author: yagagagaga <[email protected]>
AuthorDate: Tue Feb 25 17:48:09 2025 +0800
fix dead link, remove wrong function in wrong version (#1943)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
Co-authored-by: yagagagaga <[email protected]>
---
.../scalar-functions/string-functions/left.md | 60 ---------------------
.../scalar-functions/string-functions/left.md | 61 ----------------------
.../scalar-functions/string-functions/left.md | 61 ----------------------
.../instance-management/DECOMMISSION-BACKEND.md | 2 +-
.../scalar-functions/string-functions/left.md | 61 ----------------------
sidebars.json | 1 -
.../scalar-functions/string-functions/left.md | 60 ---------------------
.../instance-management/DECOMMISSION-BACKEND.md | 2 +-
.../scalar-functions/string-functions/left.md | 60 ---------------------
versioned_sidebars/version-2.1-sidebars.json | 1 -
versioned_sidebars/version-3.0-sidebars.json | 1 -
11 files changed, 2 insertions(+), 368 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/left.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/left.md
deleted file mode 100644
index b1345a5482d..00000000000
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/left.md
+++ /dev/null
@@ -1,60 +0,0 @@
----
-{
- "title": "LEFT",
- "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.
--->
-
-## Description
-
-Returns the substring starting at the specified offset from the left side of
string s.
-
-## Syntax
-
-```sql
-LEFT ( <str> , <offset> )
-```
-
-## Parameters
-
-| Parameter | Description |
-|------------|---------------|
-| `<str>` | String to search for |
-| `<offset>` | Offset to calculate from the left side |
-
-## Return Value
-
-The substring starting at the specified offset from the left side of string
`<str>`.
-
-## Example
-
-```sql
-SELECT LEFT('Hello', 3)
-```
-
-```text
-+------------------+
-| left('Hello', 3) |
-+------------------+
-| Hel |
-+------------------+
-```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/left.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/left.md
deleted file mode 100644
index 09dd984329a..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/left.md
+++ /dev/null
@@ -1,61 +0,0 @@
----
-{
- "title": "LEFT",
- "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.
--->
-
-## 描述
-
-返回字符串 s 中从左侧开始具有指定偏移量的子字符串。
-
-## 语法
-
-```sql
-LEFT ( <str> , <offset> )
-```
-
-## 参数
-
-| 参数 | 说明 |
-|------------|---------------|
-| `<str>` | 需要查找的字符串 |
-| `<offset>` | 需要从左侧开始计算的偏移量 |
-
-
-## 返回值
-
-字符串 `<str>` 中从左侧开始具有指定偏移量的子字符串。
-
-## 举例
-
-```sql
-SELECT LEFT('Hello', 3)
-```
-
-```text
-+------------------+
-| left('Hello', 3) |
-+------------------+
-| Hel |
-+------------------+
-```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/left.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/left.md
deleted file mode 100644
index 09dd984329a..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/left.md
+++ /dev/null
@@ -1,61 +0,0 @@
----
-{
- "title": "LEFT",
- "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.
--->
-
-## 描述
-
-返回字符串 s 中从左侧开始具有指定偏移量的子字符串。
-
-## 语法
-
-```sql
-LEFT ( <str> , <offset> )
-```
-
-## 参数
-
-| 参数 | 说明 |
-|------------|---------------|
-| `<str>` | 需要查找的字符串 |
-| `<offset>` | 需要从左侧开始计算的偏移量 |
-
-
-## 返回值
-
-字符串 `<str>` 中从左侧开始具有指定偏移量的子字符串。
-
-## 举例
-
-```sql
-SELECT LEFT('Hello', 3)
-```
-
-```text
-+------------------+
-| left('Hello', 3) |
-+------------------+
-| Hel |
-+------------------+
-```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/DECOMMISSION-BACKEND.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/DECOMMISSION-BACKEND.md
index dd2833fe01e..4a0ba99c55c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/DECOMMISSION-BACKEND.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/DECOMMISSION-BACKEND.md
@@ -75,7 +75,7 @@ be_identifier
3. 当前 BE 如果存储的数据量比较大,那么 DECOMMISSION 操作可能持续几个小时甚至是几天
4. 如果 DECOMMISSION 操作的进度卡住不动,具体表现为[SHOW
BACKENDS](./SHOW-BACKENDS.md)语句中的`TabletNum`列一直固定在某个值,那么可能是以下的一些情况:
- 当前 BE 上的 tablet 找不到合适的其他 BE 去迁移,比如在一个 3 节点的集群有一张 3
副本的表,要下线其中一个节点,那么该节点找不到其他 BE 可用来迁移数据(其他两个 BE 已经各有一个副本了)
- - 当前 BE 上的 tablet
还在[回收站](../../recycle/SHOW-CATALOG-RECYCLE-BIN.md)中,可以[清空回收站](../../recycle/DROP-CATALOG-RECYCLE-BIN.md)后,再等待
+ - 当前 BE 上的 tablet
还在[回收站](../../recycle/SHOW-CATALOG-RECYCLE-BIN.md)中,可以清空回收站后,再等待
- 当前 BE 上的 tablet 太大,导致在迁移单个 tablet 时,一直因为超时而无法将这个 tablet 迁移走,可以调整 FE
Master 的配置`max_clone_task_timeout_sec`为一个更大的值(默认为 7200 秒)
- 当前 BE 上的 tablet 存在未完成的事务,可以等事务完成或手动中止事务
- 其他情况可以在 FE Master 的日志过滤`replicas to decommission`关键字,找出异常的 tablet,使用[SHOW
TABLET](../../table-and-view/data-and-status-management/SHOW-TABLET.md)语句找到该
tablet 所属的表,然后重新建一张新的表,将数据从旧表迁移至新表,最后使用[DROP TABLE
FORCE](../../table-and-view/table/DROP-TABLE.md)的方式将旧表删除掉
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/left.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/left.md
deleted file mode 100644
index 09dd984329a..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/left.md
+++ /dev/null
@@ -1,61 +0,0 @@
----
-{
- "title": "LEFT",
- "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.
--->
-
-## 描述
-
-返回字符串 s 中从左侧开始具有指定偏移量的子字符串。
-
-## 语法
-
-```sql
-LEFT ( <str> , <offset> )
-```
-
-## 参数
-
-| 参数 | 说明 |
-|------------|---------------|
-| `<str>` | 需要查找的字符串 |
-| `<offset>` | 需要从左侧开始计算的偏移量 |
-
-
-## 返回值
-
-字符串 `<str>` 中从左侧开始具有指定偏移量的子字符串。
-
-## 举例
-
-```sql
-SELECT LEFT('Hello', 3)
-```
-
-```text
-+------------------+
-| left('Hello', 3) |
-+------------------+
-| Hel |
-+------------------+
-```
diff --git a/sidebars.json b/sidebars.json
index 77249e3386a..cf70740d738 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -971,7 +971,6 @@
"sql-manual/sql-functions/scalar-functions/string-functions/instr",
"sql-manual/sql-functions/scalar-functions/string-functions/int-to-uuid",
"sql-manual/sql-functions/scalar-functions/string-functions/locate",
-
"sql-manual/sql-functions/scalar-functions/string-functions/left",
"sql-manual/sql-functions/scalar-functions/string-functions/overlay",
"sql-manual/sql-functions/scalar-functions/string-functions/find-in-set",
"sql-manual/sql-functions/scalar-functions/string-functions/replace",
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/left.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/left.md
deleted file mode 100644
index b1345a5482d..00000000000
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/left.md
+++ /dev/null
@@ -1,60 +0,0 @@
----
-{
- "title": "LEFT",
- "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.
--->
-
-## Description
-
-Returns the substring starting at the specified offset from the left side of
string s.
-
-## Syntax
-
-```sql
-LEFT ( <str> , <offset> )
-```
-
-## Parameters
-
-| Parameter | Description |
-|------------|---------------|
-| `<str>` | String to search for |
-| `<offset>` | Offset to calculate from the left side |
-
-## Return Value
-
-The substring starting at the specified offset from the left side of string
`<str>`.
-
-## Example
-
-```sql
-SELECT LEFT('Hello', 3)
-```
-
-```text
-+------------------+
-| left('Hello', 3) |
-+------------------+
-| Hel |
-+------------------+
-```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/DECOMMISSION-BACKEND.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/DECOMMISSION-BACKEND.md
index f33136e8da5..c0fba44efe5 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/DECOMMISSION-BACKEND.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/DECOMMISSION-BACKEND.md
@@ -75,7 +75,7 @@ The user who executes this SQL must have at least the
following permissions:
3. If the current BE stores a relatively large amount of data, the
DECOMMISSION operation may last for several hours or even days.
4. If the progress of the DECOMMISSION operation gets stuck, specifically, the
`TabletNum` column in the [SHOW BACKENDS](./SHOW-BACKENDS.md) statement remains
fixed at a certain value, it may be due to the following situations:
- There is no suitable other BE to migrate the tablets on the current BE.
For example, in a 3-node cluster with a table having 3 replicas, if one of the
nodes is to be decommissioned, this node cannot find other BEs to migrate the
data (the other two BEs already have one replica each).
- - The tablets on the current BE are still in the [Recycle
Bin](../../recycle/SHOW-CATALOG-RECYCLE-BIN.md). You can [empty the recycle
bin](../../recycle/DROP-CATALOG-RECYCLE-BIN.md) and then wait for decommission.
+ - The tablets on the current BE are still in the [Recycle
Bin](../../recycle/SHOW-CATALOG-RECYCLE-BIN.md). You can empty the recycle bin
and then wait for decommission.
- The tablet on the current BE is too large, causing the migration of a
single tablet to always timeout and unable to migrate this tablet away. You can
adjust the configuration `max_clone_task_timeout_sec` of the FE Master to a
larger value (the default is 7200 seconds).
- There are unfinished transactions on the tablets of the current BE. You
can wait for the transactions to complete or manually abort the transactions.
- In other cases, you can filter the keyword `replicas to decommission` in
the logs of the FE Master to find the abnormal tablet, use the [SHOW
TABLET](../../table-and-view/data-and-status-management/SHOW-TABLET.md)
statement to find the table to which this tablet belongs, then create a new
table, migrate the data from the old table to the new table, and finally use
the [DROP TABLE FORCE](../../table-and-view/table/DROP-TABLE.md) to delete the
old table.
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/left.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/left.md
deleted file mode 100644
index b1345a5482d..00000000000
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/left.md
+++ /dev/null
@@ -1,60 +0,0 @@
----
-{
- "title": "LEFT",
- "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.
--->
-
-## Description
-
-Returns the substring starting at the specified offset from the left side of
string s.
-
-## Syntax
-
-```sql
-LEFT ( <str> , <offset> )
-```
-
-## Parameters
-
-| Parameter | Description |
-|------------|---------------|
-| `<str>` | String to search for |
-| `<offset>` | Offset to calculate from the left side |
-
-## Return Value
-
-The substring starting at the specified offset from the left side of string
`<str>`.
-
-## Example
-
-```sql
-SELECT LEFT('Hello', 3)
-```
-
-```text
-+------------------+
-| left('Hello', 3) |
-+------------------+
-| Hel |
-+------------------+
-```
diff --git a/versioned_sidebars/version-2.1-sidebars.json
b/versioned_sidebars/version-2.1-sidebars.json
index d5a1a38cd39..a84c4bc8dd8 100644
--- a/versioned_sidebars/version-2.1-sidebars.json
+++ b/versioned_sidebars/version-2.1-sidebars.json
@@ -981,7 +981,6 @@
"sql-manual/sql-functions/scalar-functions/string-functions/instr",
"sql-manual/sql-functions/scalar-functions/string-functions/int-to-uuid",
"sql-manual/sql-functions/scalar-functions/string-functions/locate",
-
"sql-manual/sql-functions/scalar-functions/string-functions/left",
"sql-manual/sql-functions/scalar-functions/string-functions/find-in-set",
"sql-manual/sql-functions/scalar-functions/string-functions/replace",
"sql-manual/sql-functions/scalar-functions/string-functions/replace-empty",
diff --git a/versioned_sidebars/version-3.0-sidebars.json
b/versioned_sidebars/version-3.0-sidebars.json
index 95ddb8f5e3d..c9bbfec97af 100644
--- a/versioned_sidebars/version-3.0-sidebars.json
+++ b/versioned_sidebars/version-3.0-sidebars.json
@@ -1028,7 +1028,6 @@
"sql-manual/sql-functions/scalar-functions/string-functions/instr",
"sql-manual/sql-functions/scalar-functions/string-functions/int-to-uuid",
"sql-manual/sql-functions/scalar-functions/string-functions/locate",
-
"sql-manual/sql-functions/scalar-functions/string-functions/left",
"sql-manual/sql-functions/scalar-functions/string-functions/overlay",
"sql-manual/sql-functions/scalar-functions/string-functions/find-in-set",
"sql-manual/sql-functions/scalar-functions/string-functions/replace",
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]