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 ccb331f6340 [fix](execute) fix set var error (#2363)
ccb331f6340 is described below
commit ccb331f634007baa779fabf3c9f6a1366c4a8bfb
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Thu May 8 17:10:34 2025 +0800
[fix](execute) fix set var error (#2363)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 5 +++--
.../current/query-acceleration/tuning/parallelism-tuning.md | 3 ++-
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 5 +++--
.../version-2.1/query-acceleration/tuning/parallelism-tuning.md | 3 ++-
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 5 +++--
.../version-3.0/query-acceleration/tuning/parallelism-tuning.md | 3 ++-
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 5 +++--
.../version-2.1/query-acceleration/tuning/parallelism-tuning.md | 3 ++-
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 5 +++--
.../version-3.0/query-acceleration/tuning/parallelism-tuning.md | 3 ++-
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 5 +++--
11 files changed, 28 insertions(+), 17 deletions(-)
diff --git
a/docs/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/docs/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index 4aed179f8a8..436a2726e0f 100644
--- a/docs/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++ b/docs/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -33,7 +33,8 @@ Doris allows users to manually specify the parallelism of a
query to adjust the
Use SQL HINT to specify the parallelism of a single SQL statement. This allows
for flexible control of the parallelism of different SQL statements to achieve
the best execution results.
```sql
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
### Session Level Adjustment:
@@ -115,4 +116,4 @@ The query execution time is reduced from 28 seconds to 19
seconds, and the CPU u
Usually, users do not need to adjust the query parallelism. If adjustment is
required, the following points should be noted:
1. It is recommended to start from the CPU utilization. Observe whether it is
a CPU bottleneck through the PROFILE tool output and try to make reasonable
modifications to the parallelism.
-2. Adjusting a single SQL is relatively safe. Try not to make overly
aggressive global modifications.
\ No newline at end of file
+2. Adjusting a single SQL is relatively safe. Try not to make overly
aggressive global modifications.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/tuning/parallelism-tuning.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/tuning/parallelism-tuning.md
index e5b280d008f..1322eeb302e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/tuning/parallelism-tuning.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/tuning/parallelism-tuning.md
@@ -63,7 +63,8 @@ Doris 可以手动指定查询的并行度，以调整查询执行时并行执
通过 SQL HINT 来指定单个 SQL 的并行度，这样可以灵活控制不同 SQL 的并行度来取得最佳的执行效果
```SQL
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
#### 会话级别调整：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index 5adcadd2c4a..6e1ad1ba2e8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -43,7 +43,8 @@ Doris 可以手动指定查询的并行度，以调整查询执行时并行执
通过 SQL HINT 来指定单个 SQL 的并行度，这样可以灵活控制不同 SQL 的并行度来取得最佳的执行效果
```SQL
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
#### **会话级别调整：**
@@ -127,4 +128,4 @@ set parallel_pipeline_task_num = 16;
通常用户不需要介入调整查询并行度，如需要调整，需要注意以下事项：
1. 建议从 CPU 利用率出发。通过 PROFILE 工具输出观察是否是 CPU 瓶颈，尝试进行并行度的合理修改
-2. 单 SQL 调整比较安全，尽量不要全局做过于激进的修改
\ No newline at end of file
+2. 单 SQL 调整比较安全，尽量不要全局做过于激进的修改
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/parallelism-tuning.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/parallelism-tuning.md
index e5b280d008f..1322eeb302e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/parallelism-tuning.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/parallelism-tuning.md
@@ -63,7 +63,8 @@ Doris 可以手动指定查询的并行度，以调整查询执行时并行执
通过 SQL HINT 来指定单个 SQL 的并行度，这样可以灵活控制不同 SQL 的并行度来取得最佳的执行效果
```SQL
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
#### 会话级别调整：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index 8a34113fa9f..db4d2baf947 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -43,7 +43,8 @@ Doris 可以手动指定查询的并行度，以调整查询执行时并行执
通过 SQL HINT 来指定单个 SQL 的并行度，这样可以灵活控制不同 SQL 的并行度来取得最佳的执行效果
```SQL
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
#### **会话级别调整：**
@@ -127,4 +128,4 @@ set parallel_pipeline_task_num = 16;
通常用户不需要介入调整查询并行度，如需要调整，需要注意以下事项：
1. 建议从 CPU 利用率出发。通过 PROFILE 工具输出观察是否是 CPU 瓶颈，尝试进行并行度的合理修改
-2. 单 SQL 调整比较安全，尽量不要全局做过于激进的修改
\ No newline at end of file
+2. 单 SQL 调整比较安全，尽量不要全局做过于激进的修改
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-acceleration/tuning/parallelism-tuning.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-acceleration/tuning/parallelism-tuning.md
index 355fee1fa75..7d2765aa34d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-acceleration/tuning/parallelism-tuning.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-acceleration/tuning/parallelism-tuning.md
@@ -63,7 +63,8 @@ Doris 可以手动指定查询的并行度，以调整查询执行时并行执
通过 SQL HINT 来指定单个 SQL 的并行度，这样可以灵活控制不同 SQL 的并行度来取得最佳的执行效果
```SQL
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
#### 会话级别调整：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index 8a34113fa9f..db4d2baf947 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -43,7 +43,8 @@ Doris 可以手动指定查询的并行度，以调整查询执行时并行执
通过 SQL HINT 来指定单个 SQL 的并行度，这样可以灵活控制不同 SQL 的并行度来取得最佳的执行效果
```SQL
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
#### **会话级别调整：**
@@ -127,4 +128,4 @@ set parallel_pipeline_task_num = 16;
通常用户不需要介入调整查询并行度，如需要调整，需要注意以下事项：
1. 建议从 CPU 利用率出发。通过 PROFILE 工具输出观察是否是 CPU 瓶颈，尝试进行并行度的合理修改
-2. 单 SQL 调整比较安全，尽量不要全局做过于激进的修改
\ No newline at end of file
+2. 单 SQL 调整比较安全，尽量不要全局做过于激进的修改
diff --git
a/versioned_docs/version-2.1/query-acceleration/tuning/parallelism-tuning.md
b/versioned_docs/version-2.1/query-acceleration/tuning/parallelism-tuning.md
index 1c7d9153eab..16a4dadd0ad 100644
--- a/versioned_docs/version-2.1/query-acceleration/tuning/parallelism-tuning.md
+++ b/versioned_docs/version-2.1/query-acceleration/tuning/parallelism-tuning.md
@@ -57,7 +57,8 @@ Doris can manually specify the parallelism of a query to
adjust the parallel exe
Use SQL HINT to specify the parallelism of a single SQL, so that the
parallelism of different SQLs can be flexibly controlled to achieve the best
execution effect.
```SQL
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
### Session Level Adjustment:
diff --git
a/versioned_docs/version-2.1/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/versioned_docs/version-2.1/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index 4aed179f8a8..436a2726e0f 100644
---
a/versioned_docs/version-2.1/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++
b/versioned_docs/version-2.1/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -33,7 +33,8 @@ Doris allows users to manually specify the parallelism of a
query to adjust the
Use SQL HINT to specify the parallelism of a single SQL statement. This allows
for flexible control of the parallelism of different SQL statements to achieve
the best execution results.
```sql
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
### Session Level Adjustment:
@@ -115,4 +116,4 @@ The query execution time is reduced from 28 seconds to 19
seconds, and the CPU u
Usually, users do not need to adjust the query parallelism. If adjustment is
required, the following points should be noted:
1. It is recommended to start from the CPU utilization. Observe whether it is
a CPU bottleneck through the PROFILE tool output and try to make reasonable
modifications to the parallelism.
-2. Adjusting a single SQL is relatively safe. Try not to make overly
aggressive global modifications.
\ No newline at end of file
+2. Adjusting a single SQL is relatively safe. Try not to make overly
aggressive global modifications.
diff --git
a/versioned_docs/version-3.0/query-acceleration/tuning/parallelism-tuning.md
b/versioned_docs/version-3.0/query-acceleration/tuning/parallelism-tuning.md
index 1c7d9153eab..16a4dadd0ad 100644
--- a/versioned_docs/version-3.0/query-acceleration/tuning/parallelism-tuning.md
+++ b/versioned_docs/version-3.0/query-acceleration/tuning/parallelism-tuning.md
@@ -57,7 +57,8 @@ Doris can manually specify the parallelism of a query to
adjust the parallel exe
Use SQL HINT to specify the parallelism of a single SQL, so that the
parallelism of different SQLs can be flexibly controlled to achieve the best
execution effect.
```SQL
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
### Session Level Adjustment:
diff --git
a/versioned_docs/version-3.0/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/versioned_docs/version-3.0/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index 4aed179f8a8..436a2726e0f 100644
---
a/versioned_docs/version-3.0/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++
b/versioned_docs/version-3.0/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -33,7 +33,8 @@ Doris allows users to manually specify the parallelism of a
query to adjust the
Use SQL HINT to specify the parallelism of a single SQL statement. This allows
for flexible control of the parallelism of different SQL statements to achieve
the best execution results.
```sql
-select /*SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8")*/ * from nation, lineitem
where lineitem.l_suppkey = nation.n_nationkey
+select /*+SET_VAR("parallel_pipeline_task_num=8,runtime_filter_mode=global")*/
* from nation, lineitem where lineitem.l_suppkey = nation.n_nationkey
```
### Session Level Adjustment:
@@ -115,4 +116,4 @@ The query execution time is reduced from 28 seconds to 19
seconds, and the CPU u
Usually, users do not need to adjust the query parallelism. If adjustment is
required, the following points should be noted:
1. It is recommended to start from the CPU utilization. Observe whether it is
a CPU bottleneck through the PROFILE tool output and try to make reasonable
modifications to the parallelism.
-2. Adjusting a single SQL is relatively safe. Try not to make overly
aggressive global modifications.
\ No newline at end of file
+2. Adjusting a single SQL is relatively safe. Try not to make overly
aggressive global modifications.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
