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 <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
