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 5ca6596ca3 [fix](tpch-tools) disable join reorder for Q12 in TPC-H
tools (#14728)
5ca6596ca3 is described below
commit 5ca6596ca35c8042467ed2d481d5ed0838fd755c
Author: minghong <[email protected]>
AuthorDate: Thu Dec 1 20:55:17 2022 +0800
[fix](tpch-tools) disable join reorder for Q12 in TPC-H tools (#14728)
---
tools/tpch-tools/queries/q12.sql | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/tools/tpch-tools/queries/q12.sql b/tools/tpch-tools/queries/q12.sql
index 5fcd65c635..3ab14e2ff2 100644
--- a/tools/tpch-tools/queries/q12.sql
+++ b/tools/tpch-tools/queries/q12.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(exec_mem_limit=8589934592,
parallel_fragment_exec_instance_num=2, enable_vectorized_engine=true,
batch_size=4096, disable_join_reorder=false,
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) */
l_shipmode,
sum(case
when o_orderpriority = '1-URGENT'
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
