This is an automated email from the ASF dual-hosted git repository.
gabriellee 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 038ccab3c4 [benchmark](rewrite) add hints for q20 (#13561)
038ccab3c4 is described below
commit 038ccab3c4ebca2542cc829f04d9aec06f654b1c
Author: Gabriel <gabrielleeb...@gmail.com>
AuthorDate: Fri Oct 21 22:35:50 2022 +0800
[benchmark](rewrite) add hints for q20 (#13561)
---
tools/tpch-tools/queries/q20.sql | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/tools/tpch-tools/queries/q20.sql b/tools/tpch-tools/queries/q20.sql
index 77a2b9de0a..e453717153 100644
--- a/tools/tpch-tools/queries/q20.sql
+++ b/tools/tpch-tools/queries/q20.sql
@@ -17,7 +17,7 @@
-- Modified
-select /*+SET_VAR(exec_mem_limit=8589934592,
parallel_fragment_exec_instance_num=16, enable_vectorized_engine=true,
batch_size=4096, disable_join_reorder=true,
enable_cost_based_join_reorder=true, enable_projection=true) */
+select /*+SET_VAR(exec_mem_limit=8589934592,
parallel_fragment_exec_instance_num=2, enable_vectorized_engine=true,
batch_size=4096, disable_join_reorder=true,
enable_cost_based_join_reorder=true, enable_projection=true,
runtime_bloom_filter_size=551943) */
s_name, s_address from
supplier left semi join
(
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
