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 <zhangminkefromflyd...@gmail.com> 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 <zhangminke@zhangminkedeMacBook-Pro.local> --- .../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: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org