You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by ga...@apache.org on 2022/10/21 14:35:58 UTC

[doris] branch master updated: [benchmark](rewrite) add hints for q20 (#13561)

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 <ga...@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-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org