This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 46158a6555a [tpcds-tools](nereids) remove cascades specific control
for global config (#25595)
46158a6555a is described below
commit 46158a6555aeea72a8ccf27031334769259e0516
Author: xzj7019 <[email protected]>
AuthorDate: Wed Oct 18 19:47:19 2023 +0800
[tpcds-tools](nereids) remove cascades specific control for global config
(#25595)
remove sf100 cascades specific control for global config, which is only for
q72
---
tools/tpcds-tools/conf/opt/opt_sf100.sql | 2 --
tools/tpcds-tools/queries/sf100/query72.sql | 2 ++
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/tools/tpcds-tools/conf/opt/opt_sf100.sql
b/tools/tpcds-tools/conf/opt/opt_sf100.sql
index cd2c64d0247..0ffcfb7ce7c 100644
--- a/tools/tpcds-tools/conf/opt/opt_sf100.sql
+++ b/tools/tpcds-tools/conf/opt/opt_sf100.sql
@@ -4,5 +4,3 @@ set global enable_runtime_filter_prune=false;
set global runtime_filter_wait_time_ms=10000;
set global enable_fallback_to_original_planner=false;
set global forbid_unknown_col_stats=true;
-set global max_join_number_bushy_tree=10;
-set global memo_max_group_expression_size=15000;
diff --git a/tools/tpcds-tools/queries/sf100/query72.sql
b/tools/tpcds-tools/queries/sf100/query72.sql
index 6fcbb02fc8c..29cec192623 100644
--- a/tools/tpcds-tools/queries/sf100/query72.sql
+++ b/tools/tpcds-tools/queries/sf100/query72.sql
@@ -1,3 +1,5 @@
+set max_join_number_bushy_tree=10;
+set memo_max_group_expression_size=15000;
select i_item_desc
,w_warehouse_name
,d1.d_week_seq
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
