You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by yi...@apache.org on 2024/03/22 00:54:55 UTC
(doris) 13/24: [enhance](mtmv)refresh mtmv must add auto (#32522)
This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 60eeff8e187373acf3d0ed919aa3ca56bd340701
Author: zhangdong <49...@qq.com>
AuthorDate: Thu Mar 21 16:27:56 2024 +0800
[enhance](mtmv)refresh mtmv must add auto (#32522)
---
.../antlr4/org/apache/doris/nereids/DorisParser.g4 | 2 +-
.../suites/mtmv_p0/test_agg_table_mtmv.groovy | 2 +-
regression-test/suites/mtmv_p0/test_base_mtmv.groovy | 6 +++---
regression-test/suites/mtmv_p0/test_build_mtmv.groovy | 2 +-
regression-test/suites/mtmv_p0/test_hive_mtmv.groovy | 2 +-
.../suites/mtmv_p0/test_hive_olap_mtmv.groovy | 2 +-
.../suites/mtmv_p0/test_limit_partition_mtmv.groovy | 10 +++++-----
.../suites/mtmv_p0/test_mor_table_mtmv.groovy | 2 +-
.../suites/mtmv_p0/test_mow_table_mtmv.groovy | 2 +-
.../suites/mtmv_p0/test_partition_refresh_mtmv.groovy | 18 +++++++++---------
regression-test/suites/mtmv_p0/test_task_mtmv.groovy | 2 +-
.../suites/mtmv_p0/test_workload_group_mtmv.groovy | 2 +-
.../cross_join_list_str_increment_create.groovy | 2 +-
.../cross_join_range_date_increment_create.groovy | 2 +-
.../cross_join_range_number_increment_create.groovy | 2 +-
.../full_join_list_str_increment_create.groovy | 2 +-
.../full_join_range_date_increment_create.groovy | 2 +-
.../full_join_range_number_increment_create.groovy | 2 +-
.../inner_join_list_str_increment_create.groovy | 2 +-
.../inner_join_range_date_increment_create.groovy | 2 +-
.../inner_join_range_number_increment_create.groovy | 2 +-
.../left_anti_join_list_str_increment_create.groovy | 2 +-
.../left_anti_join_range_date_increment_create.groovy | 2 +-
...left_anti_join_range_number_increment_create.groovy | 2 +-
.../left_join_list_str_increment_create.groovy | 2 +-
.../left_join_range_date_increment_create.groovy | 2 +-
.../left_join_range_number_increment_create.groovy | 2 +-
.../left_semi_join_list_str_increment_create.groovy | 2 +-
.../left_semi_join_range_date_increment_create.groovy | 2 +-
...left_semi_join_range_number_increment_create.groovy | 2 +-
.../right_anti_join_list_str_increment_create.groovy | 2 +-
.../right_anti_join_range_date_increment_create.groovy | 2 +-
...ight_anti_join_range_number_increment_create.groovy | 2 +-
.../right_join_list_str_increment_create.groovy | 2 +-
.../right_join_range_date_increment_create.groovy | 2 +-
.../right_join_range_number_increment_create.groovy | 2 +-
.../right_semi_join_list_str_increment_create.groovy | 2 +-
.../right_semi_join_range_date_increment_create.groovy | 2 +-
...ight_semi_join_range_number_increment_create.groovy | 2 +-
.../self_conn_list_str_increment_create.groovy | 2 +-
.../self_conn_range_date_increment_create.groovy | 2 +-
.../self_conn_range_number_increment_create.groovy | 2 +-
.../suites/statistics/test_analyze_mtmv.groovy | 2 +-
43 files changed, 57 insertions(+), 57 deletions(-)
diff --git a/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4 b/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
index 1514ff5089f..089e5569e8d 100644
--- a/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
+++ b/fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4
@@ -97,7 +97,7 @@ statementBase
(DISTRIBUTED BY (HASH hashKeys=identifierList | RANDOM) (BUCKETS (INTEGER_VALUE | AUTO))?)?
propertyClause?
AS query #createMTMV
- | REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec | COMPLETE)? #refreshMTMV
+ | REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec | COMPLETE | AUTO) #refreshMTMV
| ALTER MATERIALIZED VIEW mvName=multipartIdentifier ((RENAME newName=identifier)
| (REFRESH (refreshMethod | refreshTrigger | refreshMethod refreshTrigger))
| (SET LEFT_PAREN fileProperties=propertyItemList RIGHT_PAREN)) #alterMTMV
diff --git a/regression-test/suites/mtmv_p0/test_agg_table_mtmv.groovy b/regression-test/suites/mtmv_p0/test_agg_table_mtmv.groovy
index 192a7f0cfea..00bf0098710 100644
--- a/regression-test/suites/mtmv_p0/test_agg_table_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_agg_table_mtmv.groovy
@@ -48,7 +48,7 @@ suite("test_agg_table_mtmv") {
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName};
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO;
"""
def jobName = getJobName(dbName, mvName);
diff --git a/regression-test/suites/mtmv_p0/test_base_mtmv.groovy b/regression-test/suites/mtmv_p0/test_base_mtmv.groovy
index 1111fdc0a11..f9bcaf2819d 100644
--- a/regression-test/suites/mtmv_p0/test_base_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_base_mtmv.groovy
@@ -50,7 +50,7 @@ suite("test_base_mtmv") {
def jobName = getJobName("regression_test_mtmv_p0", mvName);
order_qt_status "select Name,State,RefreshState from mv_infos('database'='${dbName}') where Name='${mvName}'"
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
waitingMTMVTaskFinished(jobName)
order_qt_status "select Name,State,RefreshState from mv_infos('database'='${dbName}') where Name='${mvName}'"
@@ -64,7 +64,7 @@ suite("test_base_mtmv") {
alter table ${tableName} drop COLUMN new_col;
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
waitingMTMVTaskFinished(jobName)
order_qt_status "select Name,State,RefreshState from mv_infos('database'='${dbName}') where Name='${mvName}'"
@@ -86,7 +86,7 @@ suite("test_base_mtmv") {
);
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
waitingMTMVTaskFinished(jobName)
order_qt_status "select Name,State,RefreshState from mv_infos('database'='${dbName}') where Name='${mvName}'"
diff --git a/regression-test/suites/mtmv_p0/test_build_mtmv.groovy b/regression-test/suites/mtmv_p0/test_build_mtmv.groovy
index fd6bec3fcb2..141a324e979 100644
--- a/regression-test/suites/mtmv_p0/test_build_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_build_mtmv.groovy
@@ -213,7 +213,7 @@ suite("test_build_mtmv") {
SELECT ${tableName}.username, ${tableNamePv}.pv FROM ${tableName}, ${tableNamePv} WHERE ${tableName}.id=${tableNamePv}.id;
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
jobName = getJobName("regression_test_mtmv_p0", mvName);
println jobName
diff --git a/regression-test/suites/mtmv_p0/test_hive_mtmv.groovy b/regression-test/suites/mtmv_p0/test_hive_mtmv.groovy
index 695cf0270b4..b8c0b293c21 100644
--- a/regression-test/suites/mtmv_p0/test_hive_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_hive_mtmv.groovy
@@ -59,7 +59,7 @@ suite("test_hive_mtmv", "p0,external,hive,external_docker,external_docker_hive")
//refresh other partitions
// current, for hive, auto refresh will not change data
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
waitingMTMVTaskFinished(jobName)
order_qt_refresh_other_partition "SELECT * FROM ${mvName} order by id"
diff --git a/regression-test/suites/mtmv_p0/test_hive_olap_mtmv.groovy b/regression-test/suites/mtmv_p0/test_hive_olap_mtmv.groovy
index de605f1a2b0..1d676753144 100644
--- a/regression-test/suites/mtmv_p0/test_hive_olap_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_hive_olap_mtmv.groovy
@@ -78,7 +78,7 @@ suite("test_hive_olap_mtmv", "p0,external,hive,external_docker,external_docker_h
INSERT INTO ${tableName} VALUES(3,"ff"),(4,"gg");
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
waitingMTMVTaskFinished(jobName)
order_qt_refresh_2 "SELECT * FROM ${mvName} order by id"
diff --git a/regression-test/suites/mtmv_p0/test_limit_partition_mtmv.groovy b/regression-test/suites/mtmv_p0/test_limit_partition_mtmv.groovy
index fd026a6c02e..19aa229743d 100644
--- a/regression-test/suites/mtmv_p0/test_limit_partition_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_limit_partition_mtmv.groovy
@@ -63,7 +63,7 @@ suite("test_limit_partition_mtmv") {
assertTrue(showPartitionsResult.toString().contains("p_20380101"))
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
def jobName = getJobName(dbName, mvName);
log.info(jobName)
@@ -114,7 +114,7 @@ suite("test_limit_partition_mtmv") {
assertTrue(showPartitionsResult.toString().contains("p_20380101"))
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
jobName = getJobName(dbName, mvName);
log.info(jobName)
@@ -164,7 +164,7 @@ suite("test_limit_partition_mtmv") {
assertTrue(showPartitionsResult.toString().contains("p_20380101"))
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
jobName = getJobName(dbName, mvName);
log.info(jobName)
@@ -213,7 +213,7 @@ suite("test_limit_partition_mtmv") {
assertTrue(showPartitionsResult.toString().contains("p_20380101_20380103"))
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
jobName = getJobName(dbName, mvName);
log.info(jobName)
@@ -226,7 +226,7 @@ suite("test_limit_partition_mtmv") {
alter Materialized View ${mvName} set("partition_sync_limit"="");
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
jobName = getJobName(dbName, mvName);
log.info(jobName)
diff --git a/regression-test/suites/mtmv_p0/test_mor_table_mtmv.groovy b/regression-test/suites/mtmv_p0/test_mor_table_mtmv.groovy
index 7795745c507..7ad4593ea10 100644
--- a/regression-test/suites/mtmv_p0/test_mor_table_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_mor_table_mtmv.groovy
@@ -48,7 +48,7 @@ suite("test_mor_table_mtmv") {
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName};
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO;
"""
def jobName = getJobName(dbName, mvName);
diff --git a/regression-test/suites/mtmv_p0/test_mow_table_mtmv.groovy b/regression-test/suites/mtmv_p0/test_mow_table_mtmv.groovy
index 954b03c402a..6a2aec59adc 100644
--- a/regression-test/suites/mtmv_p0/test_mow_table_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_mow_table_mtmv.groovy
@@ -48,7 +48,7 @@ suite("test_mow_table_mtmv") {
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName};
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO;
"""
def jobName = getJobName(dbName, mvName);
diff --git a/regression-test/suites/mtmv_p0/test_partition_refresh_mtmv.groovy b/regression-test/suites/mtmv_p0/test_partition_refresh_mtmv.groovy
index 82ca125104d..8e084091f4d 100644
--- a/regression-test/suites/mtmv_p0/test_partition_refresh_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_partition_refresh_mtmv.groovy
@@ -166,7 +166,7 @@ suite("test_partition_refresh_mtmv") {
assertTrue(showPartitionsResult.toString().contains("p_20170301_20170401"))
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
def jobName = getJobName(dbName, mvName);
log.info(jobName)
@@ -212,7 +212,7 @@ suite("test_partition_refresh_mtmv") {
assertTrue(showPartitionsResult.toString().contains("p_3_4"))
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
jobName = getJobName(dbName, mvName);
log.info(jobName)
@@ -259,7 +259,7 @@ suite("test_partition_refresh_mtmv") {
assertTrue(showPartitionsResult.toString().contains("_3"))
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
jobName = getJobName(dbName, mvName);
log.info(jobName)
@@ -324,7 +324,7 @@ suite("test_partition_refresh_mtmv") {
//refresh other partitions
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
waitingMTMVTaskFinished(jobName)
order_qt_refresh_other_partition "SELECT * FROM ${mvName} order by user_id,age,date,num"
@@ -361,7 +361,7 @@ suite("test_partition_refresh_mtmv") {
//refresh other partition ,data will be fresh
sql """
- REFRESH MATERIALIZED VIEW ${mvName};
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO;
"""
waitingMTMVTaskFinished(jobName)
order_qt_refresh_other_table_change_other "SELECT * FROM ${mvName} order by user_id,age,date,num"
@@ -369,7 +369,7 @@ suite("test_partition_refresh_mtmv") {
//test base table add partition
sql """alter table ${tableNameNum} ADD PARTITION p201704 VALUES [('2017-04-01'), ('2017-05-01'))"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName};
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO;
"""
waitingMTMVTaskFinished(jobName)
showPartitionsResult = sql """show partitions from ${mvName}"""
@@ -379,7 +379,7 @@ suite("test_partition_refresh_mtmv") {
//test base table drop partition
sql """alter table ${tableNameNum} drop PARTITION p201704"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName};
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO;
"""
waitingMTMVTaskFinished(jobName)
showPartitionsResult = sql """show partitions from ${mvName}"""
@@ -435,7 +435,7 @@ suite("test_partition_refresh_mtmv") {
select ${tableNameUser}.user_id,${tableNameUser}.age,${tableNameNum}.date,${tableNameNum}.num from ${tableNameUser} join ${tableNameNum} on ${tableNameUser}.user_id = ${tableNameNum}.user_id;
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName};
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO;
"""
jobName = getJobName(dbName, mvName);
log.info(jobName)
@@ -447,7 +447,7 @@ suite("test_partition_refresh_mtmv") {
insert into ${tableNameUser} values(1,9);
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName};
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO;
"""
waitingMTMVTaskFinished(jobName)
order_qt_exclude_will_not_change "SELECT * FROM ${mvName} order by user_id,age,date,num"
diff --git a/regression-test/suites/mtmv_p0/test_task_mtmv.groovy b/regression-test/suites/mtmv_p0/test_task_mtmv.groovy
index a3e59afd66c..72356b45a79 100644
--- a/regression-test/suites/mtmv_p0/test_task_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_task_mtmv.groovy
@@ -42,7 +42,7 @@ suite("test_task_mtmv") {
SELECT * FROM ${tableName};
"""
sql """
- REFRESH MATERIALIZED VIEW ${mvName}
+ REFRESH MATERIALIZED VIEW ${mvName} AUTO
"""
def jobName = getJobName(dbName, mvName);
waitingMTMVTaskFinished(jobName)
diff --git a/regression-test/suites/mtmv_p0/test_workload_group_mtmv.groovy b/regression-test/suites/mtmv_p0/test_workload_group_mtmv.groovy
index 4e95f6c258d..0ccbce3ff45 100644
--- a/regression-test/suites/mtmv_p0/test_workload_group_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_workload_group_mtmv.groovy
@@ -51,7 +51,7 @@ suite("test_workload_group_mtmv") {
"""
order_qt_alter "select MvProperties from mv_infos('database'='${dbName}') where Name='${mvName}'"
sql """
- refresh MATERIALIZED VIEW ${mvName};
+ refresh MATERIALIZED VIEW ${mvName} AUTO;
"""
def jobName = getJobName(dbName, mvName);
logger.info(jobName)
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 21475ce3886..d219fe2a67f 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
@@ -133,7 +133,7 @@ suite("cross_join_list_str_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 f89040f7f7b..56d8069b124 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
@@ -124,7 +124,7 @@ suite("cross_join_range_date_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 4e12b2eaa2c..6f8e5da1bac 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
@@ -133,7 +133,7 @@ suite("cross_join_range_number_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 0442f8cb218..8e467f01a08 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
@@ -133,7 +133,7 @@ suite("full_join_list_str_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 10f2cb087eb..7c9f6e4d58b 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
@@ -124,7 +124,7 @@ suite("full_join_range_date_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 dcfac6a8d38..f243a5620d0 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
@@ -133,7 +133,7 @@ suite("full_join_range_number_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 9605aa99b14..3579ddf472a 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
@@ -133,7 +133,7 @@ suite("inner_join_list_str_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 b8190e76c17..31b4d8ba9b3 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
@@ -124,7 +124,7 @@ suite("inner_join_range_date_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 4fb766cef77..0a8ba49a761 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
@@ -134,7 +134,7 @@ suite("inner_join_range_number_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 2c27c097f0c..930d85040b4 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
@@ -133,7 +133,7 @@ suite("left_anti_join_list_str_increment_create") {
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 47c2b2f38d3..0dbbe3abb57 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
@@ -124,7 +124,7 @@ suite("left_anti_join_range_date_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 3d9bac82eea..9dd6f75d947 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
@@ -132,7 +132,7 @@ suite("left_anti_join_range_number_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 4e973d88012..36b3e580f5a 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
@@ -133,7 +133,7 @@ suite("left_join_list_str_increment_create") {
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 18045c51043..a8eacdc4a69 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
@@ -124,7 +124,7 @@ suite("left_join_range_date_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 6f43675ba96..64bda473d88 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
@@ -132,7 +132,7 @@ suite("left_join_range_number_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 49989225de7..1b20f89ee0f 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
@@ -133,7 +133,7 @@ suite("left_semi_join_list_str_increment_create") {
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 26977398b28..a78ad12b3ff 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
@@ -124,7 +124,7 @@ suite("left_semi_join_range_date_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 6439d61b2de..398b883c6c4 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
@@ -132,7 +132,7 @@ suite("left_semi_join_range_number_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 f09c6565ea6..41feed21b67 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
@@ -133,7 +133,7 @@ suite("right_anti_join_list_str_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 4f8605fb3ea..7e9e00a6cdc 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
@@ -124,7 +124,7 @@ suite("right_anti_join_range_date_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 b878037f940..62f8c80ecb3 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
@@ -133,7 +133,7 @@ suite("right_anti_join_range_number_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 26a7a926011..937e8224f03 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
@@ -133,7 +133,7 @@ suite("right_join_list_str_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 1cc603a24f4..9c00f72a39d 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
@@ -124,7 +124,7 @@ suite("right_join_range_date_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 ca09fd1d6e7..31c69eb1059 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
@@ -133,7 +133,7 @@ suite("right_join_range_number_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 1b716e6af1c..f26a024b806 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
@@ -132,7 +132,7 @@ suite("right_semi_join_list_str_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 459c8c3f51c..cfc176f5471 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
@@ -124,7 +124,7 @@ suite("right_semi_join_range_date_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 fc34ba25f29..4d92b0a4b83 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
@@ -133,7 +133,7 @@ suite("right_semi_join_range_number_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 5548152f166..4facffbdecd 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
@@ -133,7 +133,7 @@ suite("self_conn_list_str_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 a586a38c4e9..23ca627e7ed 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
@@ -124,7 +124,7 @@ suite("self_conn_range_date_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
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 833942fb3a3..52a2741a107 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
@@ -134,7 +134,7 @@ suite("self_conn_range_number_increment_create") {
"""
}
def refresh_mv = {
- sql """refresh MATERIALIZED VIEW ${mv_name}"""
+ sql """refresh MATERIALIZED VIEW ${mv_name} AUTO"""
}
def delete_mv = {
sql """DROP MATERIALIZED VIEW ${mv_name};"""
diff --git a/regression-test/suites/statistics/test_analyze_mtmv.groovy b/regression-test/suites/statistics/test_analyze_mtmv.groovy
index a3b49154673..7662fd1fbbe 100644
--- a/regression-test/suites/statistics/test_analyze_mtmv.groovy
+++ b/regression-test/suites/statistics/test_analyze_mtmv.groovy
@@ -123,7 +123,7 @@ suite("test_analyze_mtmv") {
l_partkey,
l_suppkey;
"""
- sql """REFRESH MATERIALIZED VIEW mv1"""
+ sql """REFRESH MATERIALIZED VIEW mv1 AUTO"""
while(true) {
Thread.sleep(1000)
def result = sql """select * from mv_infos("database"="test_analyze_mtmv") where Name="mv1";"""
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org