This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 d560e7fe025 Update parallelism-tuning.md (#3379)
d560e7fe025 is described below
commit d560e7fe0255a45327a043f3f23fbe7547c8123f
Author: Yongqiang YANG <[email protected]>
AuthorDate: Tue Feb 10 12:39:37 2026 -0800
Update parallelism-tuning.md (#3379)
## Summary
- Recreate the `SET_VAR` SQL hint syntax fix from #2511 by removing
extra quotes around parameters.
- Apply this fix to `dev`, `3.x`, and `4.x` docs for both English and
Chinese.
## Versions
- [x] dev
- [x] 4.x
- [x] 3.x
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Reference
- Original PR: https://github.com/apache/doris-website/pull/2511
Co-authored-by: yuanyuan8983
<[email protected]>
---
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 4 ++--
.../current/query-acceleration/tuning/parallelism-tuning.md | 5 ++---
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 5 ++---
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 4 ++--
.../version-4.x/query-acceleration/tuning/parallelism-tuning.md | 4 ++--
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 4 ++--
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 5 ++---
.../query-acceleration/tuning/tuning-execution/parallelism-tuning.md | 4 ++--
8 files changed, 16 insertions(+), 19 deletions(-)
diff --git
a/docs/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/docs/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index ba820855984..50b832e6198 100644
--- a/docs/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++ b/docs/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -37,8 +37,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,runtime_filter_mode=global")*/
* 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/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 73a5527ed0e..328be0d656a 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
@@ -46,8 +46,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,runtime_filter_mode=global")*/
* 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
```
#### 会话级别调整：
@@ -65,4 +65,3 @@ set parallel_pipeline_task_num = 8;
```SQL
set global parallel_pipeline_task_num = 8;
```
-
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 1deb0d6c256..299af79a72b 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
@@ -46,8 +46,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,runtime_filter_mode=global")*/
* 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
```
### 会话级别调整
@@ -142,4 +142,3 @@ set parallel_pipeline_task_num = 16;
1. 建议从 CPU 利用率出发。通过 PROFILE 工具输出观察是否是 CPU 瓶颈，尝试进行并行度的合理修改
2. 单 SQL 调整比较安全，尽量不要全局做过于激进的修改
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index dfada3d3e2e..f3d0934c5f5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -43,8 +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,runtime_filter_mode=global")*/
* 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-4.x/query-acceleration/tuning/parallelism-tuning.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-acceleration/tuning/parallelism-tuning.md
index 3edd80faa3a..8c1f9431fb8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-acceleration/tuning/parallelism-tuning.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-acceleration/tuning/parallelism-tuning.md
@@ -45,8 +45,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,runtime_filter_mode=global")*/
* 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-4.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index 306b07901e6..be2aa95c2a6 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -37,8 +37,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,runtime_filter_mode=global")*/
* 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/versioned_docs/version-3.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/versioned_docs/version-3.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index d728563ffad..0e2093eff0c 100644
---
a/versioned_docs/version-3.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++
b/versioned_docs/version-3.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -46,8 +46,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,runtime_filter_mode=global")*/
* 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
@@ -142,4 +142,3 @@ Usually, users do not need to adjust the query parallelism.
If adjustment is req
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.
-
diff --git
a/versioned_docs/version-4.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
b/versioned_docs/version-4.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
index 5c63540fe3f..90a7dc46d39 100644
---
a/versioned_docs/version-4.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
+++
b/versioned_docs/version-4.x/query-acceleration/tuning/tuning-execution/parallelism-tuning.md
@@ -43,8 +43,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,runtime_filter_mode=global")*/
* 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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
