This is an automated email from the ASF dual-hosted git repository.
hello-stephen pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 2eb8addef2c [fix](regression) stabilize clickbench query10 shape
(#65193)
2eb8addef2c is described below
commit 2eb8addef2cc9b998963d93c8acb1506838df414
Author: shuke <[email protected]>
AuthorDate: Wed Jul 8 16:54:15 2026 +0800
[fix](regression) stabilize clickbench query10 shape (#65193)
## Proposed changes
Stabilize `shape_check/clickbench/query10.groovy` by pinning:
```groovy
sql "set parallel_pipeline_task_num=2"
```
This matches the neighboring ClickBench shape cases that need a
deterministic aggregate shape.
## Root cause
`query10` checks the Nereids physical `EXPLAIN SHAPE PLAN` for a mixed
aggregate query with `COUNT(DISTINCT UserID)`.
The golden expects a lower `hashAgg[LOCAL]` below the hash distribute.
When `parallel_pipeline_task_num` is left at its default `0`, the
effective parallelism is derived from the current cluster executor size,
and the optimizer may cost-select the alternate aggregate split shape
without that local aggregate:
```text
Expect cell is: --------------hashAgg[LOCAL]
But real is : --------------PhysicalProject
```
This is a case stability issue rather than a product correctness
failure; the query result is not being checked here, only plan shape.
## Validation
- `git diff --check`
- Not run locally: no local Doris listener was present on
`127.0.0.1:9030` / `127.0.0.1:8030`, and no prebuilt regression-test jar
was available in `output/regression-test/lib`.
---
regression-test/suites/shape_check/clickbench/query10.groovy | 1 +
1 file changed, 1 insertion(+)
diff --git a/regression-test/suites/shape_check/clickbench/query10.groovy
b/regression-test/suites/shape_check/clickbench/query10.groovy
index 738c4e55e91..eeb19f280d2 100644
--- a/regression-test/suites/shape_check/clickbench/query10.groovy
+++ b/regression-test/suites/shape_check/clickbench/query10.groovy
@@ -18,6 +18,7 @@
*/
suite("query10") {
+ sql "set parallel_pipeline_task_num=2"
sql 'set enable_nereids_planner=true'
sql 'set enable_nereids_distribute_planner=false'
sql 'set enable_fallback_to_original_planner=false'
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
