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 ffc80cf9312 [fix](mtmv) Fix get mv statistics plan wrong and optimize
code usage (#35623)
ffc80cf9312 is described below
commit ffc80cf93128ac6302563e8a4891aa1919e7d42d
Author: seawinde <149132972+seawi...@users.noreply.github.com>
AuthorDate: Thu May 30 15:44:25 2024 +0800
[fix](mtmv) Fix get mv statistics plan wrong and optimize code usage
(#35623)
1. get mv statistics, the relation id should be getted from scan plan,
fix it.
2. optimize the `isGroupEquals` method, add `MaterializationContext`
param which maybe used to control the decide group by equals logic.
3. remove `set enable_nereids_timeout = false;` setting in mv rewrite
regression test.
---
.../rules/exploration/mv/AbstractMaterializedViewAggregateRule.java | 5 +++--
.../nereids/rules/exploration/mv/AsyncMaterializationContext.java | 6 +++---
.../mv/agg_with_roll_up/aggregate_with_roll_up.groovy | 1 -
.../suites/nereids_rules_p0/mv/availability/grace_period.groovy | 1 -
.../suites/nereids_rules_p0/mv/dimension/dimension_1.groovy | 1 -
.../suites/nereids_rules_p0/mv/dimension/dimension_2_3.groovy | 1 -
.../suites/nereids_rules_p0/mv/dimension/dimension_2_4.groovy | 1 -
.../suites/nereids_rules_p0/mv/dimension/dimension_2_5.groovy | 1 -
.../suites/nereids_rules_p0/mv/dimension/dimension_2_6.groovy | 1 -
.../nereids_rules_p0/mv/dimension/dimension_2_full_join.groovy | 1 -
.../nereids_rules_p0/mv/dimension/dimension_2_inner_join.groovy | 1 -
.../nereids_rules_p0/mv/dimension/dimension_2_left_anti_join.groovy | 1 -
.../nereids_rules_p0/mv/dimension/dimension_2_left_join.groovy | 1 -
.../nereids_rules_p0/mv/dimension/dimension_2_left_semi_join.groovy | 1 -
.../mv/dimension/dimension_2_right_anti_join.groovy | 1 -
.../nereids_rules_p0/mv/dimension/dimension_2_right_join.groovy | 1 -
.../mv/dimension/dimension_2_right_semi_join.groovy | 1 -
.../suites/nereids_rules_p0/mv/dimension/dimension_self_conn.groovy | 1 -
.../mv/dimension_2_join_agg/dimension_2_join_agg.groovy | 1 -
.../mv/dimension_equal/filter_equal_or_notequal.groovy | 1 -
.../mv/external_table/mv_contain_external_table.groovy | 1 -
.../mv/increment_create/cross_join_list_str_increment_create.groovy | 1 -
.../increment_create/cross_join_range_date_increment_create.groovy | 1 -
.../cross_join_range_number_increment_create.groovy | 1 -
.../mv/increment_create/full_join_list_str_increment_create.groovy | 1 -
.../increment_create/full_join_range_date_increment_create.groovy | 1 -
.../increment_create/full_join_range_number_increment_create.groovy | 1 -
.../mv/increment_create/inner_join_list_str_increment_create.groovy | 1 -
.../increment_create/inner_join_range_date_increment_create.groovy | 1 -
.../inner_join_range_number_increment_create.groovy | 1 -
.../left_anti_join_list_str_increment_create.groovy | 1 -
.../left_anti_join_range_date_increment_create.groovy | 1 -
.../left_anti_join_range_number_increment_create.groovy | 1 -
.../mv/increment_create/left_join_list_str_increment_create.groovy | 1 -
.../increment_create/left_join_range_date_increment_create.groovy | 1 -
.../increment_create/left_join_range_number_increment_create.groovy | 1 -
.../left_semi_join_list_str_increment_create.groovy | 1 -
.../left_semi_join_range_date_increment_create.groovy | 1 -
.../left_semi_join_range_number_increment_create.groovy | 1 -
.../right_anti_join_list_str_increment_create.groovy | 1 -
.../right_anti_join_range_date_increment_create.groovy | 1 -
.../right_anti_join_range_number_increment_create.groovy | 1 -
.../mv/increment_create/right_join_list_str_increment_create.groovy | 1 -
.../increment_create/right_join_range_date_increment_create.groovy | 1 -
.../right_join_range_number_increment_create.groovy | 1 -
.../right_semi_join_list_str_increment_create.groovy | 1 -
.../right_semi_join_range_date_increment_create.groovy | 1 -
.../right_semi_join_range_number_increment_create.groovy | 1 -
.../mv/increment_create/self_conn_list_str_increment_create.groovy | 1 -
.../increment_create/self_conn_range_date_increment_create.groovy | 1 -
.../increment_create/self_conn_range_number_increment_create.groovy | 1 -
.../nereids_rules_p0/mv/join/dphyp_inner/inner_join_dphyp.groovy | 1 -
.../nereids_rules_p0/mv/join/dphyp_outer/outer_join_dphyp.groovy | 1 -
.../suites/nereids_rules_p0/mv/join/inner/inner_join.groovy | 1 -
.../suites/nereids_rules_p0/mv/join/left_outer/outer_join.groovy | 1 -
.../suites/nereids_rules_p0/mv/negative/negative_test.groovy | 1 -
.../nereids_rules_p0/mv/nested/nested_materialized_view.groovy | 1 -
.../suites/nereids_rules_p0/mv/nested_mtmv/nested_mtmv.groovy | 1 -
regression-test/suites/nereids_rules_p0/mv/scan/scan_table.groovy | 1 -
.../mv/union_rewrite/partition_curd_union_rewrite.groovy | 1 -
.../nereids_rules_p0/mv/union_rewrite/usercase_union_rewrite.groovy | 1 -
61 files changed, 6 insertions(+), 64 deletions(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AbstractMaterializedViewAggregateRule.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AbstractMaterializedViewAggregateRule.java
index 1e013498a12..9a8b2fd0243 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AbstractMaterializedViewAggregateRule.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AbstractMaterializedViewAggregateRule.java
@@ -94,7 +94,7 @@ public abstract class AbstractMaterializedViewAggregateRule
extends AbstractMate
// Firstly,if group by expression between query and view is equals,
try to rewrite expression directly
Plan queryTopPlan = queryTopPlanAndAggPair.key();
if (isGroupByEquals(queryTopPlanAndAggPair, viewTopPlanAndAggPair,
viewToQuerySlotMapping, queryStructInfo,
- viewStructInfo)) {
+ viewStructInfo, materializationContext)) {
List<Expression> rewrittenQueryExpressions =
rewriteExpression(queryTopPlan.getOutput(),
queryTopPlan,
materializationContext.getExprToScanExprMapping(),
@@ -253,7 +253,8 @@ public abstract class AbstractMaterializedViewAggregateRule
extends AbstractMate
Pair<Plan, LogicalAggregate<Plan>> viewTopPlanAndAggPair,
SlotMapping viewToQuerySlotMapping,
StructInfo queryStructInfo,
- StructInfo viewStructInfo) {
+ StructInfo viewStructInfo,
+ MaterializationContext materializationContext) {
Plan queryTopPlan = queryTopPlanAndAggPair.key();
Plan viewTopPlan = viewTopPlanAndAggPair.key();
LogicalAggregate<Plan> queryAggregate = queryTopPlanAndAggPair.value();
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AsyncMaterializationContext.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AsyncMaterializationContext.java
index f1c4372f104..dfb27eee9a6 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AsyncMaterializationContext.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AsyncMaterializationContext.java
@@ -103,9 +103,9 @@ public class AsyncMaterializationContext extends
MaterializationContext {
return Optional.empty();
}
RelationId relationId = null;
- List<Object> scanObjs = this.getPlan().collectFirst(plan -> plan
instanceof LogicalOlapScan);
- if (scanObjs != null && !scanObjs.isEmpty()) {
- relationId = ((LogicalOlapScan) scanObjs.get(0)).getRelationId();
+ List<LogicalOlapScan> logicalOlapScan =
this.getScanPlan().collectFirst(LogicalOlapScan.class::isInstance);
+ if (!logicalOlapScan.isEmpty()) {
+ relationId = logicalOlapScan.get(0).getRelationId();
}
return Optional.of(Pair.of(relationId, mtmvCache.getStatistics()));
}
diff --git
a/regression-test/suites/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.groovy
b/regression-test/suites/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.groovy
index 431b74ab745..ac1e806bd51 100644
---
a/regression-test/suites/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.groovy
@@ -23,7 +23,6 @@ suite("aggregate_with_roll_up") {
sql "SET ignore_shape_nodes='PhysicalDistribute,PhysicalProject'"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders
diff --git
a/regression-test/suites/nereids_rules_p0/mv/availability/grace_period.groovy
b/regression-test/suites/nereids_rules_p0/mv/availability/grace_period.groovy
index a67a7622b4b..c40997f8989 100644
---
a/regression-test/suites/nereids_rules_p0/mv/availability/grace_period.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/availability/grace_period.groovy
@@ -27,7 +27,6 @@ suite("grace_period") {
sql "set runtime_filter_mode=OFF"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_partition
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_1.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_1.groovy
index b02df2b9993..e7f4f92cd06 100644
--- a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_1.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_1.groovy
@@ -24,7 +24,6 @@ suite("partition_mv_rewrite_dimension_1") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_3.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_3.groovy
index 047779caa45..d261e7c4160 100644
--- a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_3.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_3.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_3") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_4.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_4.groovy
index 85679ac99ac..5215ab75d20 100644
--- a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_4.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_4.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_4") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_4
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_5.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_5.groovy
index 3efd9da11ea..e392a517801 100644
--- a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_5.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_5.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_5") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_5
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_6.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_6.groovy
index efa219bf7dc..12c7a23448b 100644
--- a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_6.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_6.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_6") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_6
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_full_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_full_join.groovy
index 496345eaa43..a4572bb5e99 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_full_join.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_full_join.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_full_join") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_full_join
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_inner_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_inner_join.groovy
index 58d550b45ba..97dcdc279e3 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_inner_join.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_inner_join.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_2") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_anti_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_anti_join.groovy
index 8eed21914af..f62d24db6a4 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_anti_join.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_anti_join.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_left_anti_join") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_left_anti_join
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_join.groovy
index 89a867013da..d5be7599d22 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_join.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_join.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_1") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_semi_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_semi_join.groovy
index 9b0abb43554..bb7841297e0 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_semi_join.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_left_semi_join.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_left_semi_join") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_left_semi_join
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_anti_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_anti_join.groovy
index 41701d9cc8c..2b60e58927c 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_anti_join.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_anti_join.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_right_anti_join") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_right_anti_join
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_join.groovy
index fb200034a99..ab12b4eb8c7 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_join.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_join.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_right_join") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_right_join
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_semi_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_semi_join.groovy
index fa2e0ace0f0..0d2a199356c 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_semi_join.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_right_semi_join.groovy
@@ -25,7 +25,6 @@ suite("partition_mv_rewrite_dimension_2_right_semi_join") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_2_right_semi_join
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_self_conn.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_self_conn.groovy
index 9a2e893f7e4..4812c98a4a3 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_self_conn.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_self_conn.groovy
@@ -24,7 +24,6 @@ suite("partition_mv_rewrite_dimension_self_conn") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_self_conn
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension_2_join_agg/dimension_2_join_agg.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension_2_join_agg/dimension_2_join_agg.groovy
index 3e083af5ab2..f1916220984 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension_2_join_agg/dimension_2_join_agg.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension_2_join_agg/dimension_2_join_agg.groovy
@@ -24,7 +24,6 @@ suite("dimension_2_join_agg_replenish") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders
diff --git
a/regression-test/suites/nereids_rules_p0/mv/dimension_equal/filter_equal_or_notequal.groovy
b/regression-test/suites/nereids_rules_p0/mv/dimension_equal/filter_equal_or_notequal.groovy
index b8fc1a347cb..bddf6c22d3b 100644
---
a/regression-test/suites/nereids_rules_p0/mv/dimension_equal/filter_equal_or_notequal.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/dimension_equal/filter_equal_or_notequal.groovy
@@ -22,7 +22,6 @@ suite("filter_equal_or_notequal_case") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/external_table/mv_contain_external_table.groovy
b/regression-test/suites/nereids_rules_p0/mv/external_table/mv_contain_external_table.groovy
index 614f147b387..64bd5d823e3 100644
---
a/regression-test/suites/nereids_rules_p0/mv/external_table/mv_contain_external_table.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/external_table/mv_contain_external_table.groovy
@@ -95,7 +95,6 @@ suite("mv_contain_external_table",
"p0,external,hive,external_docker,external_do
sql "SET ignore_shape_nodes='PhysicalDistribute,PhysicalProject'"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists lineitem
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_list_str_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_list_str_increment_create.groovy
index d219fe2a67f..7726d1ce4d1 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_list_str_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_list_str_increment_create.groovy
@@ -21,7 +21,6 @@ suite("cross_join_list_str_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_cross_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_range_date_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_range_date_increment_create.groovy
index 1cd76faef72..29864adfbc9 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_range_date_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_range_date_increment_create.groovy
@@ -21,7 +21,6 @@ suite("cross_join_range_date_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_cross_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_range_number_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_range_number_increment_create.groovy
index 6c5aa905a80..63ec6eec3fc 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_range_number_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/cross_join_range_number_increment_create.groovy
@@ -21,7 +21,6 @@ suite("cross_join_range_number_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_cross_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_list_str_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_list_str_increment_create.groovy
index 8e467f01a08..fe244c7ee09 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_list_str_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_list_str_increment_create.groovy
@@ -21,7 +21,6 @@ suite("full_join_list_str_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_full_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_range_date_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_range_date_increment_create.groovy
index 26a2c0bb567..f4a063e5a57 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_range_date_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_range_date_increment_create.groovy
@@ -21,7 +21,6 @@ suite("full_join_range_date_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_full_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_range_number_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_range_number_increment_create.groovy
index 7614842f368..5381bf3cf1b 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_range_number_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/full_join_range_number_increment_create.groovy
@@ -21,7 +21,6 @@ suite("full_join_range_number_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_full_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_list_str_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_list_str_increment_create.groovy
index 3579ddf472a..b8b7bd4ea8d 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_list_str_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_list_str_increment_create.groovy
@@ -21,7 +21,6 @@ suite("inner_join_list_str_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_inner_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_range_date_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_range_date_increment_create.groovy
index c1de9c7f09e..43330d2be97 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_range_date_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_range_date_increment_create.groovy
@@ -21,7 +21,6 @@ suite("inner_join_range_date_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_inner_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_range_number_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_range_number_increment_create.groovy
index d688556f4ca..20f5f356fb5 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_range_number_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/inner_join_range_number_increment_create.groovy
@@ -21,7 +21,6 @@ suite("inner_join_range_number_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_inner_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_list_str_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_list_str_increment_create.groovy
index 930d85040b4..781aa2de918 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_list_str_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_list_str_increment_create.groovy
@@ -21,7 +21,6 @@ suite("left_anti_join_list_str_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_left_anti_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_range_date_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_range_date_increment_create.groovy
index 436b574e7b9..9e327c7abef 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_range_date_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_range_date_increment_create.groovy
@@ -21,7 +21,6 @@ suite("left_anti_join_range_date_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_left_anti_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_range_number_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_range_number_increment_create.groovy
index 63d634f1e35..e5a2f490d3a 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_range_number_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_anti_join_range_number_increment_create.groovy
@@ -21,7 +21,6 @@ suite("left_anti_join_range_number_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_left_anti_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_list_str_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_list_str_increment_create.groovy
index 36b3e580f5a..6254656575f 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_list_str_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_list_str_increment_create.groovy
@@ -21,7 +21,6 @@ suite("left_join_list_str_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_left_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_range_date_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_range_date_increment_create.groovy
index a42a2e96372..e8e192bcd18 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_range_date_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_range_date_increment_create.groovy
@@ -21,7 +21,6 @@ suite("left_join_range_date_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_left_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_range_number_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_range_number_increment_create.groovy
index 7e604cba8bf..8b54ad10d8f 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_range_number_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_join_range_number_increment_create.groovy
@@ -21,7 +21,6 @@ suite("left_join_range_number_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_left_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_list_str_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_list_str_increment_create.groovy
index 1b20f89ee0f..14bb903ae91 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_list_str_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_list_str_increment_create.groovy
@@ -21,7 +21,6 @@ suite("left_semi_join_list_str_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_left_semi_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_range_date_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_range_date_increment_create.groovy
index 01dc2eda881..a9d2db4d5e7 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_range_date_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_range_date_increment_create.groovy
@@ -21,7 +21,6 @@ suite("left_semi_join_range_date_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_left_semi_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_range_number_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_range_number_increment_create.groovy
index c7ee6a7f221..c2dc643daab 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_range_number_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/left_semi_join_range_number_increment_create.groovy
@@ -21,7 +21,6 @@ suite("left_semi_join_range_number_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_left_semi_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_list_str_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_list_str_increment_create.groovy
index 41feed21b67..b1e688a3e71 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_list_str_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_list_str_increment_create.groovy
@@ -21,7 +21,6 @@ suite("right_anti_join_list_str_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_right_anti_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_range_date_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_range_date_increment_create.groovy
index c82579adbfc..97686c41923 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_range_date_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_range_date_increment_create.groovy
@@ -21,7 +21,6 @@ suite("right_anti_join_range_date_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_right_anti_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_range_number_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_range_number_increment_create.groovy
index 69080174a64..53131c5f61a 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_range_number_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_anti_join_range_number_increment_create.groovy
@@ -21,7 +21,6 @@ suite("right_anti_join_range_number_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_right_anti_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_list_str_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_list_str_increment_create.groovy
index 937e8224f03..1a7f6e570a6 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_list_str_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_list_str_increment_create.groovy
@@ -21,7 +21,6 @@ suite("right_join_list_str_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_right_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_range_date_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_range_date_increment_create.groovy
index 54f0d446d03..caec6cdef66 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_range_date_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_range_date_increment_create.groovy
@@ -21,7 +21,6 @@ suite("right_join_range_date_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_right_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_range_number_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_range_number_increment_create.groovy
index 513c09f57f4..fa1c2a9fd03 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_range_number_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_join_range_number_increment_create.groovy
@@ -21,7 +21,6 @@ suite("right_join_range_number_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_right_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_list_str_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_list_str_increment_create.groovy
index f26a024b806..47f17e74dcf 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_list_str_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_list_str_increment_create.groovy
@@ -21,7 +21,6 @@ suite("right_semi_join_list_str_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_right_semi_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_range_date_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_range_date_increment_create.groovy
index 77d09fadbe9..7be46585172 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_range_date_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_range_date_increment_create.groovy
@@ -21,7 +21,6 @@ suite("right_semi_join_range_date_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_right_semi_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_range_number_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_range_number_increment_create.groovy
index 480ba50624e..d4437ae7e97 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_range_number_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/right_semi_join_range_number_increment_create.groovy
@@ -21,7 +21,6 @@ suite("right_semi_join_range_number_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_right_semi_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_list_str_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_list_str_increment_create.groovy
index 4facffbdecd..4adc00ef3d7 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_list_str_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_list_str_increment_create.groovy
@@ -21,7 +21,6 @@ suite("self_conn_list_str_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_self_conn_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_range_date_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_range_date_increment_create.groovy
index 8537198f54a..295030d7004 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_range_date_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_range_date_increment_create.groovy
@@ -21,7 +21,6 @@ suite("self_conn_range_date_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_self_conn_2
diff --git
a/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_range_number_increment_create.groovy
b/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_range_number_increment_create.groovy
index 62130654d86..4114f75856a 100644
---
a/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_range_number_increment_create.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/increment_create/self_conn_range_number_increment_create.groovy
@@ -21,7 +21,6 @@ suite("self_conn_range_number_increment_create") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=false"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_self_conn_3
diff --git
a/regression-test/suites/nereids_rules_p0/mv/join/dphyp_inner/inner_join_dphyp.groovy
b/regression-test/suites/nereids_rules_p0/mv/join/dphyp_inner/inner_join_dphyp.groovy
index 95e5dbed7a7..2c3eb9fe3dd 100644
---
a/regression-test/suites/nereids_rules_p0/mv/join/dphyp_inner/inner_join_dphyp.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/join/dphyp_inner/inner_join_dphyp.groovy
@@ -22,7 +22,6 @@ suite("inner_join_dphyp") {
sql "set runtime_filter_mode=OFF"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql "SET enable_dphyp_optimizer = true"
sql """
diff --git
a/regression-test/suites/nereids_rules_p0/mv/join/dphyp_outer/outer_join_dphyp.groovy
b/regression-test/suites/nereids_rules_p0/mv/join/dphyp_outer/outer_join_dphyp.groovy
index 69ffd60485b..d56888e53a0 100644
---
a/regression-test/suites/nereids_rules_p0/mv/join/dphyp_outer/outer_join_dphyp.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/join/dphyp_outer/outer_join_dphyp.groovy
@@ -23,7 +23,6 @@ suite("outer_join_dphyp") {
sql "SET ignore_shape_nodes='PhysicalDistribute,PhysicalProject'"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql "SET enable_dphyp_optimizer = true"
sql """
drop table if exists orders
diff --git
a/regression-test/suites/nereids_rules_p0/mv/join/inner/inner_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/join/inner/inner_join.groovy
index 9f0b66fc66a..29392c4f5aa 100644
--- a/regression-test/suites/nereids_rules_p0/mv/join/inner/inner_join.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/join/inner/inner_join.groovy
@@ -22,7 +22,6 @@ suite("inner_join") {
sql "set runtime_filter_mode=OFF"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders
diff --git
a/regression-test/suites/nereids_rules_p0/mv/join/left_outer/outer_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/join/left_outer/outer_join.groovy
index e2b9a8297ee..0b48642097d 100644
---
a/regression-test/suites/nereids_rules_p0/mv/join/left_outer/outer_join.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/join/left_outer/outer_join.groovy
@@ -23,7 +23,6 @@ suite("outer_join") {
sql "SET ignore_shape_nodes='PhysicalDistribute,PhysicalProject'"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders
diff --git
a/regression-test/suites/nereids_rules_p0/mv/negative/negative_test.groovy
b/regression-test/suites/nereids_rules_p0/mv/negative/negative_test.groovy
index d9c61b989e1..4b60ee60ccd 100644
--- a/regression-test/suites/nereids_rules_p0/mv/negative/negative_test.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/negative/negative_test.groovy
@@ -24,7 +24,6 @@ suite("negative_partition_mv_rewrite") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/nested/nested_materialized_view.groovy
b/regression-test/suites/nereids_rules_p0/mv/nested/nested_materialized_view.groovy
index f7b47ef3959..235c6a246cf 100644
---
a/regression-test/suites/nereids_rules_p0/mv/nested/nested_materialized_view.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/nested/nested_materialized_view.groovy
@@ -101,7 +101,6 @@ suite("nested_materialized_view") {
sql "SET enable_nereids_planner=true"
sql "set runtime_filter_mode=OFF"
sql "SET enable_fallback_to_original_planner=false"
- sql "SET enable_nereids_timeout = false"
sql "SET enable_materialized_view_rewrite=true"
sql "SET enable_materialized_view_nest_rewrite = true"
diff --git
a/regression-test/suites/nereids_rules_p0/mv/nested_mtmv/nested_mtmv.groovy
b/regression-test/suites/nereids_rules_p0/mv/nested_mtmv/nested_mtmv.groovy
index ce64cc21bf1..8f39517966e 100644
--- a/regression-test/suites/nereids_rules_p0/mv/nested_mtmv/nested_mtmv.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/nested_mtmv/nested_mtmv.groovy
@@ -21,7 +21,6 @@ suite("nested_mtmv") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql "SET enable_materialized_view_nest_rewrite = true"
sql """
diff --git a/regression-test/suites/nereids_rules_p0/mv/scan/scan_table.groovy
b/regression-test/suites/nereids_rules_p0/mv/scan/scan_table.groovy
index b25e497379f..27a0292dfe0 100644
--- a/regression-test/suites/nereids_rules_p0/mv/scan/scan_table.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/scan/scan_table.groovy
@@ -22,7 +22,6 @@ suite("mv_scan_table") {
sql "set runtime_filter_mode=OFF"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders
diff --git
a/regression-test/suites/nereids_rules_p0/mv/union_rewrite/partition_curd_union_rewrite.groovy
b/regression-test/suites/nereids_rules_p0/mv/union_rewrite/partition_curd_union_rewrite.groovy
index cfdd327c0d2..90d326ed7ec 100644
---
a/regression-test/suites/nereids_rules_p0/mv/union_rewrite/partition_curd_union_rewrite.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/union_rewrite/partition_curd_union_rewrite.groovy
@@ -22,7 +22,6 @@ suite ("partition_curd_union_rewrite") {
sql "set runtime_filter_mode=OFF"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders
diff --git
a/regression-test/suites/nereids_rules_p0/mv/union_rewrite/usercase_union_rewrite.groovy
b/regression-test/suites/nereids_rules_p0/mv/union_rewrite/usercase_union_rewrite.groovy
index 1e474abc8ff..30597d57e1c 100644
---
a/regression-test/suites/nereids_rules_p0/mv/union_rewrite/usercase_union_rewrite.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/union_rewrite/usercase_union_rewrite.groovy
@@ -21,7 +21,6 @@ suite ("usercase_union_rewrite") {
sql "SET enable_nereids_planner=true"
sql "SET enable_fallback_to_original_planner=false"
sql "SET enable_materialized_view_rewrite=true"
- sql "SET enable_nereids_timeout = false"
sql """
drop table if exists orders_user
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
