This is an automated email from the ASF dual-hosted git repository.
zclll 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 e344c67f2c2 [fix](cases) Remove badcase
test_auto_partition_with_single_replica_insert (#58259)
e344c67f2c2 is described below
commit e344c67f2c2aafe035d74008bc534de27977b407
Author: zclllyybb <[email protected]>
AuthorDate: Mon Nov 24 19:31:21 2025 +0800
[fix](cases) Remove badcase test_auto_partition_with_single_replica_insert
(#58259)
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: https://github.com/apache/doris/pull/48101
Problem Summary:
for branch-3.1 and branch-4.0
---
...t_auto_partition_with_single_replica_insert.csv | 78 ----------
...t_auto_partition_with_single_replica_insert.out | 161 ---------------------
...uto_partition_with_single_replica_insert.groovy | 78 ----------
3 files changed, 317 deletions(-)
diff --git
a/regression-test/data/partition_p0/auto_partition/test_auto_partition_with_single_replica_insert.csv
b/regression-test/data/partition_p0/auto_partition/test_auto_partition_with_single_replica_insert.csv
deleted file mode 100644
index 747ac6788be..00000000000
---
a/regression-test/data/partition_p0/auto_partition/test_auto_partition_with_single_replica_insert.csv
+++ /dev/null
@@ -1,78 +0,0 @@
--3590935922607536626,-,2025-02-16,星辰医疗科技有限公司
--3590935906895636626,-,2025-02-16,未来健康产业
-123,-,2025-02-16,蓝海生物有限公司
-100000048812501,-,2025-02-16,阳光医疗集团
-1000000076784258,-,2025-02-16,华夏健康科技
-1000022060522735,-,2025-02-16,瑞丰生物医药
-1000022193719484,-,2025-02-16,盛世医疗服务
-1000031422678924,-,2025-02-16,康宁健康有限公司
-1000085651028900,-,2025-02-16,史前生物科技
-1000093620518989,-,2025-02-16,健康之路公司
-1000103471774704,-,2025-02-16,安康医疗科技
-1000138777615262,-,2025-02-16,福瑞堂生物
-1000156823071129,-,2025-02-16,优质生活科技
-1000191711015262,-,2025-02-16,健康未来企业
-1000633041475486,-,2025-02-16,天使医疗集团
-1000681518627336,-,2025-02-16,百年健康公司
-1002458253925730,-,2025-02-16,康乐园生物科技
-1008126191610424,-,2025-02-16,华康医药有限公司
-1071904784424147,-,2025-02-16,金桥健康产业
-1076564522324147,-,2025-02-16,乐活医疗科技
-1202217708798485,-,2025-02-16,健康家园公司
-1224474148903456,-,2025-02-16,康泰生物科技
-2043829367811999,-,2025-02-16,未来医疗集团
-2191851926844270,-,2025-02-16,健康之源公司
-2232379824950609,-,2025-02-16,安宁医药有限公司
-2350341369782152,-,2025-02-16,和谐生物科技
-2548383917911403,-,2025-02-16,康健医疗服务
-2640774381717600,-,2025-02-16,瑞康医药有限公司
-2754625269782961,-,2025-02-16,乐享健康产业
-3064667398063809,-,2025-02-16,健康先锋公司
-3102689636972458,-,2025-02-16,安康生物科技
-3291916164371209,-,2025-02-16,未来之星医疗
-3946909802002976,-,2025-02-16,健康梦想公司
-3965513055005942,-,2025-02-16,康乐生物科技
-4143117309325214,-,2025-02-16,安宁健康产业
-4175970196426577,-,2025-02-16,乐活医疗集团
-4294566787233969,-,2025-02-16,健康之道公司
-4610682351457207,-,2025-02-16,瑞丰医疗科技
-4674640812462217,-,2025-02-16,未来健康企业
-4676494238858307,-,2025-02-16,安康医药有限公司
-4937264996861701,-,2025-02-16,乐享健康公司
-4947288173569190,-,2025-02-16,康宁医疗集团
-5115179098054305,-,2025-02-16,健康家园科技
-10000000430024147,-,2025-02-16,阳光医疗有限公司
-10000021073673208,-,2025-02-16,未来生物科技
-10000130032642122,-,2025-02-16,和谐健康产业
-10000365660973707,-,2025-02-16,安宁医药公司
-10000453096993544,-,2025-02-16,傻乐生物科技
-10000789012345678,-,2025-02-16,星辉医疗科技
-10000890123456789,-,2025-02-16,未来健康服务
-10000901234567890,-,2025-02-16,蓝天生物科技
-10001012345678901,-,2025-02-16,阳光健康产业
-10001123456789012,-,2025-02-16,华康医疗集团
-10001234567890123,-,2025-02-16,易丰生物医药
-10001345678901234,-,2025-02-16,盛世健康科技
-10001456789012345,-,2025-02-16,康宁医疗服务
-10001567890123456,-,2025-02-16,和谐生物公司
-10001678901234567,-,2025-02-16,健康之路科技
-10001789012345678,-,2025-02-16,安康生物产业
-10001890123456789,-,2025-02-16,福瑞堂医疗
-10001901234567890,-,2025-02-16,未来生活科技
-10002012345678901,-,2025-02-16,美好未来企业
-10002123456789012,-,2025-02-16,金地医疗集团
-10002234567890123,-,2025-02-16,老头健康公司
-10002345678901234,-,2025-02-16,平安园生物科技
-10002456789012345,-,2025-02-16,闪电医药有限公司
-10002567890123456,-,2025-02-16,铜桥健康产业
-10002678901234567,-,2025-02-16,乐天医疗科技
-10002789012345678,-,2025-02-16,健康成长公司
-10002890123456789,-,2025-02-16,尖端生物科技
-10002901234567890,-,2025-02-16,保护伞医疗集团
-10003012345678901,-,2025-02-16,青春之源公司
-10003123456789012,-,2025-02-16,大森林医药有限公司
-10003234567890123,-,2025-02-16,毒蛇生物科技
-10003345678901234,-,2025-02-16,金地医疗服务
-10003456789012345,-,2025-02-16,瑞丰医药有限公司
-10003567890123456,-,2025-02-16,乐游娱乐产业
-10003678901234567,-,2025-02-16,康岩先锋公司
diff --git
a/regression-test/data/partition_p0/auto_partition/test_auto_partition_with_single_replica_insert.out
b/regression-test/data/partition_p0/auto_partition/test_auto_partition_with_single_replica_insert.out
deleted file mode 100644
index e565de71e73..00000000000
---
a/regression-test/data/partition_p0/auto_partition/test_auto_partition_with_single_replica_insert.out
+++ /dev/null
@@ -1,161 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !select1 --
--3590935906895636626 - 2025-02-16 未来健康产业
--3590935922607536626 - 2025-02-16 星辰医疗科技有限公司
-10000000430024147 - 2025-02-16 阳光医疗有限公司
-1000000076784258 - 2025-02-16 华夏健康科技
-100000048812501 - 2025-02-16 阳光医疗集团
-10000021073673208 - 2025-02-16 未来生物科技
-10000130032642122 - 2025-02-16 和谐健康产业
-1000022060522735 - 2025-02-16 瑞丰生物医药
-1000022193719484 - 2025-02-16 盛世医疗服务
-1000031422678924 - 2025-02-16 康宁健康有限公司
-10000365660973707 - 2025-02-16 安宁医药公司
-10000453096993544 - 2025-02-16 傻乐生物科技
-10000789012345678 - 2025-02-16 星辉医疗科技
-1000085651028900 - 2025-02-16 史前生物科技
-10000890123456789 - 2025-02-16 未来健康服务
-10000901234567890 - 2025-02-16 蓝天生物科技
-1000093620518989 - 2025-02-16 健康之路公司
-10001012345678901 - 2025-02-16 阳光健康产业
-1000103471774704 - 2025-02-16 安康医疗科技
-10001123456789012 - 2025-02-16 华康医疗集团
-10001234567890123 - 2025-02-16 易丰生物医药
-10001345678901234 - 2025-02-16 盛世健康科技
-1000138777615262 - 2025-02-16 福瑞堂生物
-10001456789012345 - 2025-02-16 康宁医疗服务
-10001567890123456 - 2025-02-16 和谐生物公司
-1000156823071129 - 2025-02-16 优质生活科技
-10001678901234567 - 2025-02-16 健康之路科技
-10001789012345678 - 2025-02-16 安康生物产业
-10001890123456789 - 2025-02-16 福瑞堂医疗
-10001901234567890 - 2025-02-16 未来生活科技
-1000191711015262 - 2025-02-16 健康未来企业
-10002012345678901 - 2025-02-16 美好未来企业
-10002123456789012 - 2025-02-16 金地医疗集团
-10002234567890123 - 2025-02-16 老头健康公司
-10002345678901234 - 2025-02-16 平安园生物科技
-10002456789012345 - 2025-02-16 闪电医药有限公司
-10002567890123456 - 2025-02-16 铜桥健康产业
-10002678901234567 - 2025-02-16 乐天医疗科技
-10002789012345678 - 2025-02-16 健康成长公司
-10002890123456789 - 2025-02-16 尖端生物科技
-10002901234567890 - 2025-02-16 保护伞医疗集团
-10003012345678901 - 2025-02-16 青春之源公司
-10003123456789012 - 2025-02-16 大森林医药有限公司
-10003234567890123 - 2025-02-16 毒蛇生物科技
-10003345678901234 - 2025-02-16 金地医疗服务
-10003456789012345 - 2025-02-16 瑞丰医药有限公司
-10003567890123456 - 2025-02-16 乐游娱乐产业
-10003678901234567 - 2025-02-16 康岩先锋公司
-1000633041475486 - 2025-02-16 天使医疗集团
-1000681518627336 - 2025-02-16 百年健康公司
-1002458253925730 - 2025-02-16 康乐园生物科技
-1008126191610424 - 2025-02-16 华康医药有限公司
-1071904784424147 - 2025-02-16 金桥健康产业
-1076564522324147 - 2025-02-16 乐活医疗科技
-1202217708798485 - 2025-02-16 健康家园公司
-1224474148903456 - 2025-02-16 康泰生物科技
-123 - 2025-02-16 蓝海生物有限公司
-2043829367811999 - 2025-02-16 未来医疗集团
-2191851926844270 - 2025-02-16 健康之源公司
-2232379824950609 - 2025-02-16 安宁医药有限公司
-2350341369782152 - 2025-02-16 和谐生物科技
-2548383917911403 - 2025-02-16 康健医疗服务
-2640774381717600 - 2025-02-16 瑞康医药有限公司
-2754625269782961 - 2025-02-16 乐享健康产业
-3064667398063809 - 2025-02-16 健康先锋公司
-3102689636972458 - 2025-02-16 安康生物科技
-3291916164371209 - 2025-02-16 未来之星医疗
-3946909802002976 - 2025-02-16 健康梦想公司
-3965513055005942 - 2025-02-16 康乐生物科技
-4143117309325214 - 2025-02-16 安宁健康产业
-4175970196426577 - 2025-02-16 乐活医疗集团
-4294566787233969 - 2025-02-16 健康之道公司
-4610682351457207 - 2025-02-16 瑞丰医疗科技
-4674640812462217 - 2025-02-16 未来健康企业
-4676494238858307 - 2025-02-16 安康医药有限公司
-4937264996861701 - 2025-02-16 乐享健康公司
-4947288173569190 - 2025-02-16 康宁医疗集团
-5115179098054305 - 2025-02-16 健康家园科技
-
--- !select2 --
--3590935906895636626 - 2025-02-16 未来健康产业
--3590935922607536626 - 2025-02-16 星辰医疗科技有限公司
-10000000430024147 - 2025-02-16 阳光医疗有限公司
-1000000076784258 - 2025-02-16 华夏健康科技
-100000048812501 - 2025-02-16 阳光医疗集团
-10000021073673208 - 2025-02-16 未来生物科技
-10000130032642122 - 2025-02-16 和谐健康产业
-1000022060522735 - 2025-02-16 瑞丰生物医药
-1000022193719484 - 2025-02-16 盛世医疗服务
-1000031422678924 - 2025-02-16 康宁健康有限公司
-10000365660973707 - 2025-02-16 安宁医药公司
-10000453096993544 - 2025-02-16 傻乐生物科技
-10000789012345678 - 2025-02-16 星辉医疗科技
-1000085651028900 - 2025-02-16 史前生物科技
-10000890123456789 - 2025-02-16 未来健康服务
-10000901234567890 - 2025-02-16 蓝天生物科技
-1000093620518989 - 2025-02-16 健康之路公司
-10001012345678901 - 2025-02-16 阳光健康产业
-1000103471774704 - 2025-02-16 安康医疗科技
-10001123456789012 - 2025-02-16 华康医疗集团
-10001234567890123 - 2025-02-16 易丰生物医药
-10001345678901234 - 2025-02-16 盛世健康科技
-1000138777615262 - 2025-02-16 福瑞堂生物
-10001456789012345 - 2025-02-16 康宁医疗服务
-10001567890123456 - 2025-02-16 和谐生物公司
-1000156823071129 - 2025-02-16 优质生活科技
-10001678901234567 - 2025-02-16 健康之路科技
-10001789012345678 - 2025-02-16 安康生物产业
-10001890123456789 - 2025-02-16 福瑞堂医疗
-10001901234567890 - 2025-02-16 未来生活科技
-1000191711015262 - 2025-02-16 健康未来企业
-10002012345678901 - 2025-02-16 美好未来企业
-10002123456789012 - 2025-02-16 金地医疗集团
-10002234567890123 - 2025-02-16 老头健康公司
-10002345678901234 - 2025-02-16 平安园生物科技
-10002456789012345 - 2025-02-16 闪电医药有限公司
-10002567890123456 - 2025-02-16 铜桥健康产业
-10002678901234567 - 2025-02-16 乐天医疗科技
-10002789012345678 - 2025-02-16 健康成长公司
-10002890123456789 - 2025-02-16 尖端生物科技
-10002901234567890 - 2025-02-16 保护伞医疗集团
-10003012345678901 - 2025-02-16 青春之源公司
-10003123456789012 - 2025-02-16 大森林医药有限公司
-10003234567890123 - 2025-02-16 毒蛇生物科技
-10003345678901234 - 2025-02-16 金地医疗服务
-10003456789012345 - 2025-02-16 瑞丰医药有限公司
-10003567890123456 - 2025-02-16 乐游娱乐产业
-10003678901234567 - 2025-02-16 康岩先锋公司
-1000633041475486 - 2025-02-16 天使医疗集团
-1000681518627336 - 2025-02-16 百年健康公司
-1002458253925730 - 2025-02-16 康乐园生物科技
-1008126191610424 - 2025-02-16 华康医药有限公司
-1071904784424147 - 2025-02-16 金桥健康产业
-1076564522324147 - 2025-02-16 乐活医疗科技
-1202217708798485 - 2025-02-16 健康家园公司
-1224474148903456 - 2025-02-16 康泰生物科技
-123 - 2025-02-16 蓝海生物有限公司
-2043829367811999 - 2025-02-16 未来医疗集团
-2191851926844270 - 2025-02-16 健康之源公司
-2232379824950609 - 2025-02-16 安宁医药有限公司
-2350341369782152 - 2025-02-16 和谐生物科技
-2548383917911403 - 2025-02-16 康健医疗服务
-2640774381717600 - 2025-02-16 瑞康医药有限公司
-2754625269782961 - 2025-02-16 乐享健康产业
-3064667398063809 - 2025-02-16 健康先锋公司
-3102689636972458 - 2025-02-16 安康生物科技
-3291916164371209 - 2025-02-16 未来之星医疗
-3946909802002976 - 2025-02-16 健康梦想公司
-3965513055005942 - 2025-02-16 康乐生物科技
-4143117309325214 - 2025-02-16 安宁健康产业
-4175970196426577 - 2025-02-16 乐活医疗集团
-4294566787233969 - 2025-02-16 健康之道公司
-4610682351457207 - 2025-02-16 瑞丰医疗科技
-4674640812462217 - 2025-02-16 未来健康企业
-4676494238858307 - 2025-02-16 安康医药有限公司
-4937264996861701 - 2025-02-16 乐享健康公司
-4947288173569190 - 2025-02-16 康宁医疗集团
-5115179098054305 - 2025-02-16 健康家园科技
-
diff --git
a/regression-test/suites/partition_p0/auto_partition/test_auto_partition_with_single_replica_insert.groovy
b/regression-test/suites/partition_p0/auto_partition/test_auto_partition_with_single_replica_insert.groovy
deleted file mode 100644
index d363bbc5d58..00000000000
---
a/regression-test/suites/partition_p0/auto_partition/test_auto_partition_with_single_replica_insert.groovy
+++ /dev/null
@@ -1,78 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements. See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership. The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License. You may obtain a copy of the License at
-//
-// http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied. See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-suite("test_auto_partition_with_single_replica_insert") {
- def tableName1 = "test_auto_partition_with_single_replica_insert_1"
- def tableName2 = "test_auto_partition_with_single_replica_insert_2"
- sql "drop table if exists ${tableName1}"
- sql """
- CREATE TABLE `${tableName1}` (
- `user_id` varchar(100) NULL,
- `goods_id` varchar(100) NULL,
- `dates` date NULL,
- `chain_name` varchar(100) NULL
- ) ENGINE=OLAP
- DUPLICATE KEY(`user_id`, `goods_id`, `dates`)
- COMMENT 'OLAP'
- AUTO PARTITION BY LIST (`chain_name`)
- (PARTITION pchain5fname10 VALUES IN ("chain_name"),
- PARTITION p4e0995e85ce1534e4e3a5 VALUES IN ("星辰医疗科技有限公司"))
- DISTRIBUTED BY HASH(`user_id`) buckets 10
- PROPERTIES (
- "replication_allocation" = "tag.location.default: 1"
- );
- """
- streamLoad {
- table "${tableName1}"
- set 'column_separator', ','
- file "test_auto_partition_with_single_replica_insert.csv"
- time 20000
- }
- sql " sync "
- qt_select1 "select * from ${tableName1} order by user_id"
- def result1 = sql "show partitions from ${tableName1}"
- logger.info("${result1}")
- assertEquals(result1.size(), 79)
-
- sql "drop table if exists ${tableName2}"
- sql """
- CREATE TABLE `${tableName2}` (
- `user_id` varchar(100) NULL,
- `goods_id` varchar(100) NULL,
- `dates` date NULL,
- `chain_name` varchar(100) NULL
- ) ENGINE=OLAP
- DUPLICATE KEY(`user_id`, `goods_id`, `dates`)
- COMMENT 'OLAP'
- AUTO PARTITION BY LIST (`chain_name`)
- (PARTITION pchain5fname10 VALUES IN ("chain_name"),
- PARTITION p4e0995e85ce1534e4e3a5 VALUES IN ("星辰医疗科技有限公司"))
- DISTRIBUTED BY HASH(`user_id`) buckets 10
- PROPERTIES (
- "replication_allocation" = "tag.location.default: 1"
- );
- """
- sql """set experimental_enable_nereids_planner = true"""
- sql """set enable_memtable_on_sink_node = false"""
- sql """set experimental_enable_single_replica_insert = true"""
- sql "insert into ${tableName2} select user_id, goods_id, dates, chain_name
from ${tableName1}"
- sql " sync "
- qt_select2 "select * from ${tableName2} order by user_id"
- def result2 = sql "show partitions from ${tableName1}"
- logger.info("${result2}")
- assertEquals(result1.size(), 79)
-}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
