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
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new 428f6ed4255 [test](mtmv) Modify un supported external table test case
in branch 2.1 (#48937)
428f6ed4255 is described below
commit 428f6ed4255b342d03955b8256d1c02e0d370f87
Author: seawinde <[email protected]>
AuthorDate: Wed Mar 12 16:13:54 2025 +0800
[test](mtmv) Modify un supported external table test case in branch 2.1
(#48937)
---
.../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]
