This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new 6b3eae7c29c [test](mtmv) Remove un supported test case in branch 30
(#48936)
6b3eae7c29c is described below
commit 6b3eae7c29ca88f331912c7e41ba6cf323462235
Author: seawinde <[email protected]>
AuthorDate: Thu Mar 13 14:05:55 2025 +0800
[test](mtmv) Remove un supported test case in branch 30 (#48936)
Remove un supported test case in branch 30
---
.../mv/external_table/part_partition_invalid.out | Bin 1324 -> 436 bytes
.../external_table/part_partition_invalid.groovy | 46 ---------------------
2 files changed, 46 deletions(-)
diff --git
a/regression-test/data/nereids_rules_p0/mv/external_table/part_partition_invalid.out
b/regression-test/data/nereids_rules_p0/mv/external_table/part_partition_invalid.out
index eb3d49efc9b..ff179fe92a2 100644
Binary files
a/regression-test/data/nereids_rules_p0/mv/external_table/part_partition_invalid.out
and
b/regression-test/data/nereids_rules_p0/mv/external_table/part_partition_invalid.out
differ
diff --git
a/regression-test/suites/nereids_rules_p0/mv/external_table/part_partition_invalid.groovy
b/regression-test/suites/nereids_rules_p0/mv/external_table/part_partition_invalid.groovy
index 3c2ad76c81a..14ebc4049d8 100644
---
a/regression-test/suites/nereids_rules_p0/mv/external_table/part_partition_invalid.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/external_table/part_partition_invalid.groovy
@@ -154,52 +154,6 @@ suite("part_partition_invalid",
"p0,external,external_docker") {
mv_rewrite_success(query_sql, mv_name)
order_qt_after_modify_data_and_refresh_catalog """ ${query_sql}"""
- // query invalid partition data, should hit mv, because not check now.
- mv_rewrite_fail("""
- ${query_sql} where o_orderdate = '2023-10-19';
- """, mv_name)
- order_qt_after_modify_and_refresh_catalog_19 """ ${query_sql} where
o_orderdate = '2023-10-19';"""
-
- // query valid partition data, should hit mv
- mv_rewrite_success("""
- ${query_sql} where o_orderdate = '2023-10-18';
- """, mv_name)
- order_qt_after_modify_and_refresh_catalog_18 """ ${query_sql} where
o_orderdate = '2023-10-18';"""
-
- // refresh manually
- sql """ REFRESH CATALOG ${hive_catalog_name} PROPERTIES("invalid_cache" =
"true"); """
- sql """REFRESH MATERIALIZED VIEW ${mv_name} auto"""
- waitingMTMVTaskFinished(getJobName(olap_db, mv_name))
- mv_rewrite_success(query_sql, mv_name)
- order_qt_after_modify_data_and_refresh_catalog_and_mv """ ${query_sql}"""
-
- // test after hive add partition
- sql """insert into ${hive_catalog_name}.${hive_database}.${hive_table}
values(6, 7, 'ok', 29.5, 'x', 'y', 6, 'ss', '2023-10-20');"""
-
- // refresh catalog cache
- sql """ REFRESH CATALOG ${hive_catalog_name} PROPERTIES("invalid_cache" =
"true"); """
- mv_rewrite_success(query_sql, mv_name)
- order_qt_after_add_data_with_refresh_catalog """ ${query_sql}"""
-
- // query invalid partition data, should hit mv, because not check now.
- mv_rewrite_success("""
- ${query_sql} where o_orderdate = '2023-10-19';
- """, mv_name)
-
- order_qt_after_add_and_refresh_catalog_19 """ ${query_sql} where
o_orderdate = '2023-10-19';"""
-
- // query valid partition data, should hit mv
- mv_rewrite_fail("""
- ${query_sql} where o_orderdate = '2023-10-20';
- """, mv_name)
- order_qt_after_add_and_refresh_catalog_20 """ ${query_sql} where
o_orderdate = '2023-10-20';"""
-
- // refresh manually
- sql """ REFRESH CATALOG ${hive_catalog_name} PROPERTIES("invalid_cache" =
"true"); """
- sql """REFRESH MATERIALIZED VIEW ${mv_name} auto"""
- waitingMTMVTaskFinished(getJobName(olap_db, mv_name))
- mv_rewrite_success(query_sql, mv_name)
- order_qt_after_add_data_and_refresh_catalog_and_mv """ ${query_sql}"""
sql """drop table if exists
${hive_catalog_name}.${hive_database}.${hive_table}"""
sql """drop table if exists ${internal_catalog}.${olap_db}.${olap_table}"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
