This is an automated email from the ASF dual-hosted git repository. morningman 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 0931ccf2764 [docs](delete) Update delete timeout related docs (#1195) 0931ccf2764 is described below commit 0931ccf2764fa86aa4204c3386b9ac666ae70726 Author: Siyang Tang <82279870+tangsiyang2...@users.noreply.github.com> AuthorDate: Mon Oct 21 12:02:16 2024 +0800 [docs](delete) Update delete timeout related docs (#1195) # Versions - [x] dev - [x] 3.0 - [x] 2.1 - [ ] 2.0 # Languages - [x] Chinese - [x] English --- docs/data-operate/delete/delete-manual.md | 20 +++----------------- .../current/data-operate/delete/delete-manual.md | 18 +++--------------- .../version-2.1/data-operate/delete/delete-manual.md | 18 +++--------------- .../version-2.1/data-operate/delete/delete-manual.md | 20 +++----------------- 4 files changed, 12 insertions(+), 64 deletions(-) diff --git a/docs/data-operate/delete/delete-manual.md b/docs/data-operate/delete/delete-manual.md index 2327c4bb171..facf3f3f1e8 100644 --- a/docs/data-operate/delete/delete-manual.md +++ b/docs/data-operate/delete/delete-manual.md @@ -244,27 +244,13 @@ The correct logic for handling the results returned by Delete is: - If `STATUS` is `VISIBLE`, the deletion is successful. -## FE Configurations +## Configurations **TIMEOUT Configurations** -总体来说,Doris 的删除作业的超时时间计算规则为如下(单位:秒): +- `insert_timeout` -Overall, the timeout calculation rules for Doris Delete jobs are as follows (in seconds): - -```Plain -TIMEOUT = MIN(delete_job_max_timeout_second, MAX(30, tablet_delete_timeout_second * tablet_num)) -``` - -- `tablet_delete_timeout_second` - -The delete timeout time is elastically changed by the number of tablets under the specified partition. This item is configured so that the default value of the timeout time contributed by one tablet on average is 2. - -Assuming that there are 5 tablets under the partition specified for this deletion, the timeout time available for delete is 10 seconds, and since it is less than the minimum timeout time of 30 seconds, the final timeout time is 30 seconds. - -- `query_timeout` - -Because delete itself is a SQL command, the delete statement is also subject to session limitations. Timeout is also affected by the `query_timeout` value in the session, which can be increased in seconds by `SET query_timeout = xxx`. +Because delete itself is a SQL command and treated as a special kind of insert, the delete statement also subject to session limitations. Timeout is determined by the `insert_timeout` value in the session, which can be increased in seconds by `SET insert_timeout = xxx`. **IN Predicate Configuration** diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/delete/delete-manual.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/delete/delete-manual.md index ef6ca320725..b448eca0c58 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/delete/delete-manual.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/delete/delete-manual.md @@ -235,25 +235,13 @@ ERROR 1064 (HY000): errCode = 2, detailMessage = failed to delete replicas from - 如果`status`为`VISIBLE`,表示数据删除成功。 -## 相关 FE 配置 +## 相关配置 **TIMEOUT 配置** -总体来说,Doris 的删除作业的超时时间计算规则为如下(单位:秒): +- insert_timeout -```Plain -TIMEOUT = MIN(delete_job_max_timeout_second, MAX(30, tablet_delete_timeout_second * tablet_num)) -``` - -- tablet_delete_timeout_second - - Delete 自身的超时时间是受指定分区下 Tablet 的数量弹性改变的,此项配置为平均一个 Tablet 所贡献的 `timeout` 时间,默认值为 2。 - - 假设此次删除所指定分区下有 5 个 tablet,那么可提供给 delete 的 timeout 时间为 10 秒,由于低于最低超时时间 30 秒,因此最终超时时间为 30 秒。 - -- query_timeout - - 因为 Delete 本身是一个 SQL 命令,因此删除语句也会受 Session 限制,`timeout` 还受 Session 中的`query_timeout`值影响,可以通过`SET query_timeout = xxx`来增加超时时间,单位是秒。 + 因为 Delete 本身是一个 SQL 命令且被视为一种特殊的导入,因此删除语句会受 Session 中的`insert_timeout`值影响,可以通过`SET insert_timeout = xxx`来增加超时时间,单位是秒。 **IN 谓词配置** diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/delete/delete-manual.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/delete/delete-manual.md index ef6ca320725..b448eca0c58 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/delete/delete-manual.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/delete/delete-manual.md @@ -235,25 +235,13 @@ ERROR 1064 (HY000): errCode = 2, detailMessage = failed to delete replicas from - 如果`status`为`VISIBLE`,表示数据删除成功。 -## 相关 FE 配置 +## 相关配置 **TIMEOUT 配置** -总体来说,Doris 的删除作业的超时时间计算规则为如下(单位:秒): +- insert_timeout -```Plain -TIMEOUT = MIN(delete_job_max_timeout_second, MAX(30, tablet_delete_timeout_second * tablet_num)) -``` - -- tablet_delete_timeout_second - - Delete 自身的超时时间是受指定分区下 Tablet 的数量弹性改变的,此项配置为平均一个 Tablet 所贡献的 `timeout` 时间,默认值为 2。 - - 假设此次删除所指定分区下有 5 个 tablet,那么可提供给 delete 的 timeout 时间为 10 秒,由于低于最低超时时间 30 秒,因此最终超时时间为 30 秒。 - -- query_timeout - - 因为 Delete 本身是一个 SQL 命令,因此删除语句也会受 Session 限制,`timeout` 还受 Session 中的`query_timeout`值影响,可以通过`SET query_timeout = xxx`来增加超时时间,单位是秒。 + 因为 Delete 本身是一个 SQL 命令且被视为一种特殊的导入,因此删除语句会受 Session 中的`insert_timeout`值影响,可以通过`SET insert_timeout = xxx`来增加超时时间,单位是秒。 **IN 谓词配置** diff --git a/versioned_docs/version-2.1/data-operate/delete/delete-manual.md b/versioned_docs/version-2.1/data-operate/delete/delete-manual.md index 2327c4bb171..facf3f3f1e8 100644 --- a/versioned_docs/version-2.1/data-operate/delete/delete-manual.md +++ b/versioned_docs/version-2.1/data-operate/delete/delete-manual.md @@ -244,27 +244,13 @@ The correct logic for handling the results returned by Delete is: - If `STATUS` is `VISIBLE`, the deletion is successful. -## FE Configurations +## Configurations **TIMEOUT Configurations** -总体来说,Doris 的删除作业的超时时间计算规则为如下(单位:秒): +- `insert_timeout` -Overall, the timeout calculation rules for Doris Delete jobs are as follows (in seconds): - -```Plain -TIMEOUT = MIN(delete_job_max_timeout_second, MAX(30, tablet_delete_timeout_second * tablet_num)) -``` - -- `tablet_delete_timeout_second` - -The delete timeout time is elastically changed by the number of tablets under the specified partition. This item is configured so that the default value of the timeout time contributed by one tablet on average is 2. - -Assuming that there are 5 tablets under the partition specified for this deletion, the timeout time available for delete is 10 seconds, and since it is less than the minimum timeout time of 30 seconds, the final timeout time is 30 seconds. - -- `query_timeout` - -Because delete itself is a SQL command, the delete statement is also subject to session limitations. Timeout is also affected by the `query_timeout` value in the session, which can be increased in seconds by `SET query_timeout = xxx`. +Because delete itself is a SQL command and treated as a special kind of insert, the delete statement also subject to session limitations. Timeout is determined by the `insert_timeout` value in the session, which can be increased in seconds by `SET insert_timeout = xxx`. **IN Predicate Configuration** --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org