This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 629f5006465 [cherry-pick](branch-2.1) Pick "[Fix](delete) Fix some
delete p2 case (#37689) (#41678)" (#41757)
629f5006465 is described below
commit 629f50064655ebd9fd2fb3f3e69c0b5ab93d9613
Author: abmdocrt <yukang.lian2...@gmail.com>
AuthorDate: Sat Oct 12 22:43:21 2024 +0800
[cherry-pick](branch-2.1) Pick "[Fix](delete) Fix some delete p2 case
(#37689) (#41678)" (#41757)
Pick #37689 #41678
---
regression-test/suites/ssb_unique_load_zstd_p0/ddl/customer_create.sql | 1 +
.../suites/ssb_unique_load_zstd_p0/ddl/customer_sequence_create.sql | 1 +
regression-test/suites/ssb_unique_load_zstd_p0/ddl/date_create.sql | 1 +
.../suites/ssb_unique_load_zstd_p0/ddl/date_sequence_create.sql | 1 +
regression-test/suites/ssb_unique_load_zstd_p0/ddl/lineorder_create.sql | 1 +
.../suites/ssb_unique_load_zstd_p0/ddl/lineorder_sequence_create.sql | 1 +
regression-test/suites/ssb_unique_load_zstd_p0/ddl/part_create.sql | 1 +
.../suites/ssb_unique_load_zstd_p0/ddl/part_sequence_create.sql | 1 +
regression-test/suites/ssb_unique_load_zstd_p0/ddl/supplier_create.sql | 1 +
.../suites/ssb_unique_load_zstd_p0/ddl/supplier_sequence_create.sql | 1 +
regression-test/suites/ssb_unique_sql_zstd_p0/ddl/customer_create.sql | 1 +
regression-test/suites/ssb_unique_sql_zstd_p0/ddl/date_create.sql | 1 +
regression-test/suites/ssb_unique_sql_zstd_p0/ddl/lineorder_create.sql | 1 +
regression-test/suites/ssb_unique_sql_zstd_p0/ddl/part_create.sql | 1 +
regression-test/suites/ssb_unique_sql_zstd_p0/ddl/supplier_create.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/customer.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/customer_sequence.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_sequence.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/nation.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/nation_sequence.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/orders.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/orders_sequence.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/part.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/part_sequence.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/partsupp.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/partsupp_sequence.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/region.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/region_sequence.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/supplier.sql | 1 +
regression-test/suites/tpch_sf100_unique_p2/ddl/supplier_sequence.sql | 1 +
regression-test/suites/tpch_sf100_unique_sql_p2/ddl/customer.sql | 1 +
regression-test/suites/tpch_sf100_unique_sql_p2/ddl/lineitem.sql | 1 +
regression-test/suites/tpch_sf100_unique_sql_p2/ddl/nation.sql | 1 +
regression-test/suites/tpch_sf100_unique_sql_p2/ddl/orders.sql | 1 +
regression-test/suites/tpch_sf100_unique_sql_p2/ddl/part.sql | 1 +
regression-test/suites/tpch_sf100_unique_sql_p2/ddl/partsupp.sql | 1 +
regression-test/suites/tpch_sf100_unique_sql_p2/ddl/region.sql | 1 +
regression-test/suites/tpch_sf100_unique_sql_p2/ddl/supplier.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/customer.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/customer_sequence.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/lineitem.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/lineitem_sequence.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/nation.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/nation_sequence.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/orders.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/orders_sequence.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/part.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/part_sequence.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/partsupp.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/partsupp_sequence.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/region.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/region_sequence.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/supplier.sql | 1 +
regression-test/suites/tpch_sf10_unique_p2/ddl/supplier_sequence.sql | 1 +
regression-test/suites/tpch_sf1_unique_p2/ddl/customer.sql | 1 +
regression-test/suites/tpch_sf1_unique_p2/ddl/lineitem.sql | 1 +
regression-test/suites/tpch_sf1_unique_p2/ddl/nation.sql | 1 +
regression-test/suites/tpch_sf1_unique_p2/ddl/orders.sql | 1 +
regression-test/suites/tpch_sf1_unique_p2/ddl/part.sql | 1 +
regression-test/suites/tpch_sf1_unique_p2/ddl/partsupp.sql | 1 +
regression-test/suites/tpch_sf1_unique_p2/ddl/region.sql | 1 +
regression-test/suites/tpch_sf1_unique_p2/ddl/supplier.sql | 1 +
.../unique_with_mow_p2/ssb_unique_load_zstd/ddl/customer_create.sql | 1 +
.../ssb_unique_load_zstd/ddl/customer_sequence_create.sql | 1 +
.../suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/date_create.sql | 1 +
.../unique_with_mow_p2/ssb_unique_load_zstd/ddl/date_sequence_create.sql | 1 +
.../unique_with_mow_p2/ssb_unique_load_zstd/ddl/lineorder_create.sql | 1 +
.../ssb_unique_load_zstd/ddl/lineorder_sequence_create.sql | 1 +
.../suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/part_create.sql | 1 +
.../unique_with_mow_p2/ssb_unique_load_zstd/ddl/part_sequence_create.sql | 1 +
.../unique_with_mow_p2/ssb_unique_load_zstd/ddl/supplier_create.sql | 1 +
.../ssb_unique_load_zstd/ddl/supplier_sequence_create.sql | 1 +
.../unique_with_mow_p2/ssb_unique_sql_zstd/ddl/customer_create.sql | 1 +
.../suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/date_create.sql | 1 +
.../unique_with_mow_p2/ssb_unique_sql_zstd/ddl/lineorder_create.sql | 1 +
.../suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/part_create.sql | 1 +
.../unique_with_mow_p2/ssb_unique_sql_zstd/ddl/supplier_create.sql | 1 +
78 files changed, 78 insertions(+)
diff --git
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/customer_create.sql
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/customer_create.sql
index d172400d82e..3950d5412f8 100644
--- a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/customer_create.sql
+++ b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/customer_create.sql
@@ -11,6 +11,7 @@ CREATE TABLE IF NOT EXISTS `customer` (
UNIQUE KEY (`c_custkey`)
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1"
);
diff --git
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/customer_sequence_create.sql
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/customer_sequence_create.sql
index 282479442da..378a8f4959f 100644
---
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/customer_sequence_create.sql
+++
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/customer_sequence_create.sql
@@ -11,6 +11,7 @@ CREATE TABLE IF NOT EXISTS `customer` (
UNIQUE KEY (`c_custkey`)
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"compression"="zstd",
"replication_num" = "1"
diff --git a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/date_create.sql
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/date_create.sql
index 830ce3ce599..9026e8179e0 100644
--- a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/date_create.sql
+++ b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/date_create.sql
@@ -20,6 +20,7 @@ CREATE TABLE IF NOT EXISTS `date` (
UNIQUE KEY (`d_datekey`)
DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1"
);
diff --git
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/date_sequence_create.sql
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/date_sequence_create.sql
index 662ac4fbd21..0f5e975f131 100644
---
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/date_sequence_create.sql
+++
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/date_sequence_create.sql
@@ -20,6 +20,7 @@ CREATE TABLE IF NOT EXISTS `date` (
UNIQUE KEY (`d_datekey`)
DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
PROPERTIES (
+"enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"compression"="zstd",
"replication_num" = "1"
diff --git
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/lineorder_create.sql
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/lineorder_create.sql
index d75a3f1ae39..0dc6e4f67b9 100644
--- a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/lineorder_create.sql
+++ b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/lineorder_create.sql
@@ -28,6 +28,7 @@ PARTITION p1997 VALUES [("19970101"), ("19980101")),
PARTITION p1998 VALUES [("19980101"), ("19990101")))
DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1"
);
diff --git
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/lineorder_sequence_create.sql
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/lineorder_sequence_create.sql
index 988cad5e2e2..07e231e9461 100644
---
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/lineorder_sequence_create.sql
+++
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/lineorder_sequence_create.sql
@@ -28,6 +28,7 @@ PARTITION p1997 VALUES [("19970101"), ("19980101")),
PARTITION p1998 VALUES [("19980101"), ("19990101")))
DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48
PROPERTIES (
+"enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"compression"="zstd",
"replication_num" = "1"
diff --git a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/part_create.sql
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/part_create.sql
index becc59157c3..111538092ad 100644
--- a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/part_create.sql
+++ b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/part_create.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS `part` (
UNIQUE KEY (`p_partkey`)
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1"
);
diff --git
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/part_sequence_create.sql
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/part_sequence_create.sql
index 89cdb202274..c41989bba2a 100644
---
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/part_sequence_create.sql
+++
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/part_sequence_create.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS `part` (
UNIQUE KEY (`p_partkey`)
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"compression"="zstd",
"replication_num" = "1"
diff --git
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/supplier_create.sql
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/supplier_create.sql
index 78394621962..0df74d82b26 100644
--- a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/supplier_create.sql
+++ b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/supplier_create.sql
@@ -10,6 +10,7 @@ CREATE TABLE IF NOT EXISTS `supplier` (
UNIQUE KEY (`s_suppkey`)
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1"
);
diff --git
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/supplier_sequence_create.sql
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/supplier_sequence_create.sql
index e3dcbf33b7f..2d378f72cef 100644
---
a/regression-test/suites/ssb_unique_load_zstd_p0/ddl/supplier_sequence_create.sql
+++
b/regression-test/suites/ssb_unique_load_zstd_p0/ddl/supplier_sequence_create.sql
@@ -10,6 +10,7 @@ CREATE TABLE IF NOT EXISTS `supplier` (
UNIQUE KEY (`s_suppkey`)
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"compression"="zstd",
"replication_num" = "1"
diff --git
a/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/customer_create.sql
b/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/customer_create.sql
index d172400d82e..3950d5412f8 100644
--- a/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/customer_create.sql
+++ b/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/customer_create.sql
@@ -11,6 +11,7 @@ CREATE TABLE IF NOT EXISTS `customer` (
UNIQUE KEY (`c_custkey`)
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1"
);
diff --git a/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/date_create.sql
b/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/date_create.sql
index 830ce3ce599..9026e8179e0 100644
--- a/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/date_create.sql
+++ b/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/date_create.sql
@@ -20,6 +20,7 @@ CREATE TABLE IF NOT EXISTS `date` (
UNIQUE KEY (`d_datekey`)
DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1"
);
diff --git
a/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/lineorder_create.sql
b/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/lineorder_create.sql
index d75a3f1ae39..0dc6e4f67b9 100644
--- a/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/lineorder_create.sql
+++ b/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/lineorder_create.sql
@@ -28,6 +28,7 @@ PARTITION p1997 VALUES [("19970101"), ("19980101")),
PARTITION p1998 VALUES [("19980101"), ("19990101")))
DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1"
);
diff --git a/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/part_create.sql
b/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/part_create.sql
index becc59157c3..111538092ad 100644
--- a/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/part_create.sql
+++ b/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/part_create.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS `part` (
UNIQUE KEY (`p_partkey`)
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1"
);
diff --git
a/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/supplier_create.sql
b/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/supplier_create.sql
index 78394621962..0df74d82b26 100644
--- a/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/supplier_create.sql
+++ b/regression-test/suites/ssb_unique_sql_zstd_p0/ddl/supplier_create.sql
@@ -10,6 +10,7 @@ CREATE TABLE IF NOT EXISTS `supplier` (
UNIQUE KEY (`s_suppkey`)
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1"
);
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/customer.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/customer.sql
index 49ea3f7a0f8..5b63e71429d 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/customer.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/customer.sql
@@ -12,6 +12,7 @@ UNIQUE KEY(`c_custkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git
a/regression-test/suites/tpch_sf100_unique_p2/ddl/customer_sequence.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/customer_sequence.sql
index d916c1b2615..0936506fd95 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/customer_sequence.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/customer_sequence.sql
@@ -12,6 +12,7 @@ UNIQUE KEY(`c_custkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem.sql
index ff422954820..3d5fe214710 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem.sql
@@ -20,6 +20,7 @@ UNIQUE KEY(`l_shipdate`,
`l_orderkey`,`l_linenumber`,`l_partkey`,`l_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git
a/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_sequence.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_sequence.sql
index 00d03fa2059..18a4882fc9d 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_sequence.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_sequence.sql
@@ -20,6 +20,7 @@ UNIQUE KEY(`l_shipdate`,
`l_orderkey`,`l_linenumber`,`l_partkey`,`l_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'DATE',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/nation.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/nation.sql
index a6421ac9b17..3581a266099 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/nation.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/nation.sql
@@ -8,6 +8,7 @@ UNIQUE KEY(`N_NATIONKEY`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`N_NATIONKEY`) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
);
diff --git
a/regression-test/suites/tpch_sf100_unique_p2/ddl/nation_sequence.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/nation_sequence.sql
index fab3660a2b5..f1f67a8872a 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/nation_sequence.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/nation_sequence.sql
@@ -8,6 +8,7 @@ UNIQUE KEY(`N_NATIONKEY`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`N_NATIONKEY`) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
);
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/orders.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/orders.sql
index 2d2f1d8db7d..57a54f2b329 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/orders.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/orders.sql
@@ -13,5 +13,6 @@ UNIQUE KEY(`o_orderkey`, `o_orderdate`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`o_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git
a/regression-test/suites/tpch_sf100_unique_p2/ddl/orders_sequence.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/orders_sequence.sql
index 4645ed0cc94..0c96bf845fd 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/orders_sequence.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/orders_sequence.sql
@@ -13,6 +13,7 @@ UNIQUE KEY(`o_orderkey`, `o_orderdate`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`o_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'bigint',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/part.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/part.sql
index 190a0019609..c3e5014e709 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/part.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/part.sql
@@ -13,6 +13,7 @@ UNIQUE KEY(`p_partkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/part_sequence.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/part_sequence.sql
index 40172254390..fe85dd84d30 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/part_sequence.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/part_sequence.sql
@@ -13,6 +13,7 @@ UNIQUE KEY(`p_partkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/partsupp.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/partsupp.sql
index 00c15535e83..fd83aec75cf 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/partsupp.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/partsupp.sql
@@ -9,6 +9,7 @@ UNIQUE KEY(`ps_partkey`,`ps_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`ps_partkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git
a/regression-test/suites/tpch_sf100_unique_p2/ddl/partsupp_sequence.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/partsupp_sequence.sql
index 63f8c72268e..37c3658112a 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/partsupp_sequence.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/partsupp_sequence.sql
@@ -9,6 +9,7 @@ UNIQUE KEY(`ps_partkey`,`ps_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`ps_partkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/region.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/region.sql
index 66eb7dd77e3..dab7e8b7cd4 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/region.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/region.sql
@@ -7,6 +7,7 @@ UNIQUE KEY(`r_regionkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`r_regionkey`) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git
a/regression-test/suites/tpch_sf100_unique_p2/ddl/region_sequence.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/region_sequence.sql
index c8f1e8812b8..11ad6dc1853 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/region_sequence.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/region_sequence.sql
@@ -7,6 +7,7 @@ UNIQUE KEY(`r_regionkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`r_regionkey`) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/supplier.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/supplier.sql
index e7c345d9346..e31d9332de8 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/supplier.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/supplier.sql
@@ -11,5 +11,6 @@ UNIQUE KEY(`s_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 12
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git
a/regression-test/suites/tpch_sf100_unique_p2/ddl/supplier_sequence.sql
b/regression-test/suites/tpch_sf100_unique_p2/ddl/supplier_sequence.sql
index f7c36adafb9..50ee24a118a 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/supplier_sequence.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/supplier_sequence.sql
@@ -11,6 +11,7 @@ UNIQUE KEY(`s_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 12
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/customer.sql
b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/customer.sql
index 49ea3f7a0f8..5b63e71429d 100644
--- a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/customer.sql
+++ b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/customer.sql
@@ -12,6 +12,7 @@ UNIQUE KEY(`c_custkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/lineitem.sql
b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/lineitem.sql
index ff422954820..3d5fe214710 100644
--- a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/lineitem.sql
+++ b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/lineitem.sql
@@ -20,6 +20,7 @@ UNIQUE KEY(`l_shipdate`,
`l_orderkey`,`l_linenumber`,`l_partkey`,`l_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/nation.sql
b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/nation.sql
index a6421ac9b17..3581a266099 100644
--- a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/nation.sql
+++ b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/nation.sql
@@ -8,6 +8,7 @@ UNIQUE KEY(`N_NATIONKEY`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`N_NATIONKEY`) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
);
diff --git a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/orders.sql
b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/orders.sql
index 2d2f1d8db7d..57a54f2b329 100644
--- a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/orders.sql
+++ b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/orders.sql
@@ -13,5 +13,6 @@ UNIQUE KEY(`o_orderkey`, `o_orderdate`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`o_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/part.sql
b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/part.sql
index 190a0019609..c3e5014e709 100644
--- a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/part.sql
+++ b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/part.sql
@@ -13,6 +13,7 @@ UNIQUE KEY(`p_partkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/partsupp.sql
b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/partsupp.sql
index 00c15535e83..fd83aec75cf 100644
--- a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/partsupp.sql
+++ b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/partsupp.sql
@@ -9,6 +9,7 @@ UNIQUE KEY(`ps_partkey`,`ps_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`ps_partkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/region.sql
b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/region.sql
index 66eb7dd77e3..dab7e8b7cd4 100644
--- a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/region.sql
+++ b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/region.sql
@@ -7,6 +7,7 @@ UNIQUE KEY(`r_regionkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`r_regionkey`) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/supplier.sql
b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/supplier.sql
index e7c345d9346..e31d9332de8 100644
--- a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/supplier.sql
+++ b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/supplier.sql
@@ -11,5 +11,6 @@ UNIQUE KEY(`s_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 12
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/customer.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/customer.sql
index 49ea3f7a0f8..5b63e71429d 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/customer.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/customer.sql
@@ -12,6 +12,7 @@ UNIQUE KEY(`c_custkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git
a/regression-test/suites/tpch_sf10_unique_p2/ddl/customer_sequence.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/customer_sequence.sql
index d916c1b2615..0936506fd95 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/customer_sequence.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/customer_sequence.sql
@@ -12,6 +12,7 @@ UNIQUE KEY(`c_custkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/lineitem.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/lineitem.sql
index ff422954820..3d5fe214710 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/lineitem.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/lineitem.sql
@@ -20,6 +20,7 @@ UNIQUE KEY(`l_shipdate`,
`l_orderkey`,`l_linenumber`,`l_partkey`,`l_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git
a/regression-test/suites/tpch_sf10_unique_p2/ddl/lineitem_sequence.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/lineitem_sequence.sql
index 00d03fa2059..18a4882fc9d 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/lineitem_sequence.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/lineitem_sequence.sql
@@ -20,6 +20,7 @@ UNIQUE KEY(`l_shipdate`,
`l_orderkey`,`l_linenumber`,`l_partkey`,`l_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'DATE',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/nation.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/nation.sql
index a6421ac9b17..3581a266099 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/nation.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/nation.sql
@@ -8,6 +8,7 @@ UNIQUE KEY(`N_NATIONKEY`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`N_NATIONKEY`) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
);
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/nation_sequence.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/nation_sequence.sql
index fab3660a2b5..f1f67a8872a 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/nation_sequence.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/nation_sequence.sql
@@ -8,6 +8,7 @@ UNIQUE KEY(`N_NATIONKEY`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`N_NATIONKEY`) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
);
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/orders.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/orders.sql
index 2d2f1d8db7d..57a54f2b329 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/orders.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/orders.sql
@@ -13,5 +13,6 @@ UNIQUE KEY(`o_orderkey`, `o_orderdate`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`o_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/orders_sequence.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/orders_sequence.sql
index 4645ed0cc94..0c96bf845fd 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/orders_sequence.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/orders_sequence.sql
@@ -13,6 +13,7 @@ UNIQUE KEY(`o_orderkey`, `o_orderdate`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`o_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'bigint',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/part.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/part.sql
index 190a0019609..c3e5014e709 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/part.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/part.sql
@@ -13,6 +13,7 @@ UNIQUE KEY(`p_partkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/part_sequence.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/part_sequence.sql
index 40172254390..fe85dd84d30 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/part_sequence.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/part_sequence.sql
@@ -13,6 +13,7 @@ UNIQUE KEY(`p_partkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/partsupp.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/partsupp.sql
index 00c15535e83..fd83aec75cf 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/partsupp.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/partsupp.sql
@@ -9,6 +9,7 @@ UNIQUE KEY(`ps_partkey`,`ps_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`ps_partkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git
a/regression-test/suites/tpch_sf10_unique_p2/ddl/partsupp_sequence.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/partsupp_sequence.sql
index 63f8c72268e..37c3658112a 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/partsupp_sequence.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/partsupp_sequence.sql
@@ -9,6 +9,7 @@ UNIQUE KEY(`ps_partkey`,`ps_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`ps_partkey`) BUCKETS 24
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/region.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/region.sql
index 66eb7dd77e3..dab7e8b7cd4 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/region.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/region.sql
@@ -7,6 +7,7 @@ UNIQUE KEY(`r_regionkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`r_regionkey`) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/region_sequence.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/region_sequence.sql
index c8f1e8812b8..11ad6dc1853 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/region_sequence.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/region_sequence.sql
@@ -7,6 +7,7 @@ UNIQUE KEY(`r_regionkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`r_regionkey`) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf10_unique_p2/ddl/supplier.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/supplier.sql
index e7c345d9346..e31d9332de8 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/supplier.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/supplier.sql
@@ -11,5 +11,6 @@ UNIQUE KEY(`s_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 12
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "3"
)
diff --git
a/regression-test/suites/tpch_sf10_unique_p2/ddl/supplier_sequence.sql
b/regression-test/suites/tpch_sf10_unique_p2/ddl/supplier_sequence.sql
index f7c36adafb9..50ee24a118a 100644
--- a/regression-test/suites/tpch_sf10_unique_p2/ddl/supplier_sequence.sql
+++ b/regression-test/suites/tpch_sf10_unique_p2/ddl/supplier_sequence.sql
@@ -11,6 +11,7 @@ UNIQUE KEY(`s_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 12
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"function_column.sequence_type" = 'int',
"replication_num" = "3"
)
diff --git a/regression-test/suites/tpch_sf1_unique_p2/ddl/customer.sql
b/regression-test/suites/tpch_sf1_unique_p2/ddl/customer.sql
index f81902a585e..1502dfdffec 100644
--- a/regression-test/suites/tpch_sf1_unique_p2/ddl/customer.sql
+++ b/regression-test/suites/tpch_sf1_unique_p2/ddl/customer.sql
@@ -11,6 +11,7 @@ CREATE TABLE IF NOT EXISTS customer (
UNIQUE KEY(C_CUSTKEY)
DISTRIBUTED BY HASH(C_CUSTKEY) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_unique_p2/ddl/lineitem.sql
b/regression-test/suites/tpch_sf1_unique_p2/ddl/lineitem.sql
index ee2b84d2479..d1ef02f4626 100644
--- a/regression-test/suites/tpch_sf1_unique_p2/ddl/lineitem.sql
+++ b/regression-test/suites/tpch_sf1_unique_p2/ddl/lineitem.sql
@@ -19,6 +19,7 @@ CREATE TABLE IF NOT EXISTS lineitem (
UNIQUE KEY(L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER)
DISTRIBUTED BY HASH(L_ORDERKEY) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_unique_p2/ddl/nation.sql
b/regression-test/suites/tpch_sf1_unique_p2/ddl/nation.sql
index d83e91c001e..042449c9cff 100644
--- a/regression-test/suites/tpch_sf1_unique_p2/ddl/nation.sql
+++ b/regression-test/suites/tpch_sf1_unique_p2/ddl/nation.sql
@@ -7,6 +7,7 @@ CREATE TABLE IF NOT EXISTS nation (
UNIQUE KEY(N_NATIONKEY)
DISTRIBUTED BY HASH(N_NATIONKEY) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_unique_p2/ddl/orders.sql
b/regression-test/suites/tpch_sf1_unique_p2/ddl/orders.sql
index 58793417aa6..431469e18e2 100644
--- a/regression-test/suites/tpch_sf1_unique_p2/ddl/orders.sql
+++ b/regression-test/suites/tpch_sf1_unique_p2/ddl/orders.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS orders (
UNIQUE KEY(O_ORDERKEY)
DISTRIBUTED BY HASH(O_ORDERKEY) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_unique_p2/ddl/part.sql
b/regression-test/suites/tpch_sf1_unique_p2/ddl/part.sql
index 30881dfc914..a43cefe01c9 100644
--- a/regression-test/suites/tpch_sf1_unique_p2/ddl/part.sql
+++ b/regression-test/suites/tpch_sf1_unique_p2/ddl/part.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS part (
UNIQUE KEY(P_PARTKEY)
DISTRIBUTED BY HASH(P_PARTKEY) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_unique_p2/ddl/partsupp.sql
b/regression-test/suites/tpch_sf1_unique_p2/ddl/partsupp.sql
index 6c35db2152f..8d29ff0a3ee 100644
--- a/regression-test/suites/tpch_sf1_unique_p2/ddl/partsupp.sql
+++ b/regression-test/suites/tpch_sf1_unique_p2/ddl/partsupp.sql
@@ -8,6 +8,7 @@ CREATE TABLE IF NOT EXISTS partsupp (
UNIQUE KEY(PS_PARTKEY, PS_SUPPKEY)
DISTRIBUTED BY HASH(PS_PARTKEY) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_unique_p2/ddl/region.sql
b/regression-test/suites/tpch_sf1_unique_p2/ddl/region.sql
index f83fd250ecb..4031b3fc260 100644
--- a/regression-test/suites/tpch_sf1_unique_p2/ddl/region.sql
+++ b/regression-test/suites/tpch_sf1_unique_p2/ddl/region.sql
@@ -6,6 +6,7 @@ CREATE TABLE IF NOT EXISTS region (
UNIQUE KEY(R_REGIONKEY)
DISTRIBUTED BY HASH(R_REGIONKEY) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_unique_p2/ddl/supplier.sql
b/regression-test/suites/tpch_sf1_unique_p2/ddl/supplier.sql
index 8d09b6848b9..71bab5a07a4 100644
--- a/regression-test/suites/tpch_sf1_unique_p2/ddl/supplier.sql
+++ b/regression-test/suites/tpch_sf1_unique_p2/ddl/supplier.sql
@@ -10,5 +10,6 @@ CREATE TABLE IF NOT EXISTS supplier (
UNIQUE KEY(S_SUPPKEY)
DISTRIBUTED BY HASH(S_SUPPKEY) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/customer_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/customer_create.sql
index d6566d3f1b3..1b5045e6a47 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/customer_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/customer_create.sql
@@ -11,6 +11,7 @@ CREATE TABLE IF NOT EXISTS `customer` (
UNIQUE KEY (`c_custkey`)
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/customer_sequence_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/customer_sequence_create.sql
index b756ad271b8..1fd98ea6391 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/customer_sequence_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/customer_sequence_create.sql
@@ -11,6 +11,7 @@ CREATE TABLE IF NOT EXISTS `customer` (
UNIQUE KEY (`c_custkey`)
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"function_column.sequence_col" = 'c_custkey',
"compression"="zstd",
"replication_num" = "1",
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/date_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/date_create.sql
index d6ad38d8bd8..f1e3b4f72db 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/date_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/date_create.sql
@@ -20,6 +20,7 @@ CREATE TABLE IF NOT EXISTS `date` (
UNIQUE KEY (`d_datekey`)
DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/date_sequence_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/date_sequence_create.sql
index b450b872650..317bedfbd95 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/date_sequence_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/date_sequence_create.sql
@@ -20,6 +20,7 @@ CREATE TABLE IF NOT EXISTS `date` (
UNIQUE KEY (`d_datekey`)
DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
PROPERTIES (
+"enable_mow_light_delete" = "true",
"function_column.sequence_col" = 'd_datekey',
"compression"="zstd",
"replication_num" = "1",
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/lineorder_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/lineorder_create.sql
index 44bbfaf804c..5b7ad6d45bc 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/lineorder_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/lineorder_create.sql
@@ -28,6 +28,7 @@ PARTITION p1997 VALUES [("19970101"), ("19980101")),
PARTITION p1998 VALUES [("19980101"), ("19990101")))
DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/lineorder_sequence_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/lineorder_sequence_create.sql
index 230c4fde44d..fbb869fabb2 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/lineorder_sequence_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/lineorder_sequence_create.sql
@@ -28,6 +28,7 @@ PARTITION p1997 VALUES [("19970101"), ("19980101")),
PARTITION p1998 VALUES [("19980101"), ("19990101")))
DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48
PROPERTIES (
+"enable_mow_light_delete" = "true",
"function_column.sequence_col" = 'lo_orderkey',
"compression"="zstd",
"replication_num" = "1",
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/part_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/part_create.sql
index 0c6f6e371aa..8d03167f909 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/part_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/part_create.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS `part` (
UNIQUE KEY (`p_partkey`)
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/part_sequence_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/part_sequence_create.sql
index a06acd3d9f8..fe6c511531b 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/part_sequence_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/part_sequence_create.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS `part` (
UNIQUE KEY (`p_partkey`)
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"function_column.sequence_col" = 'p_partkey',
"compression"="zstd",
"replication_num" = "1",
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/supplier_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/supplier_create.sql
index b021767b47c..dd146b460c2 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/supplier_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/supplier_create.sql
@@ -10,6 +10,7 @@ CREATE TABLE IF NOT EXISTS `supplier` (
UNIQUE KEY (`s_suppkey`)
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/supplier_sequence_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/supplier_sequence_create.sql
index e88dde59acd..19255397170 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/supplier_sequence_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_load_zstd/ddl/supplier_sequence_create.sql
@@ -10,6 +10,7 @@ CREATE TABLE IF NOT EXISTS `supplier` (
UNIQUE KEY (`s_suppkey`)
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"function_column.sequence_col" = 's_suppkey',
"compression"="zstd",
"replication_num" = "1",
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/customer_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/customer_create.sql
index d6566d3f1b3..1b5045e6a47 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/customer_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/customer_create.sql
@@ -11,6 +11,7 @@ CREATE TABLE IF NOT EXISTS `customer` (
UNIQUE KEY (`c_custkey`)
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/date_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/date_create.sql
index d6ad38d8bd8..f1e3b4f72db 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/date_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/date_create.sql
@@ -20,6 +20,7 @@ CREATE TABLE IF NOT EXISTS `date` (
UNIQUE KEY (`d_datekey`)
DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/lineorder_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/lineorder_create.sql
index 44bbfaf804c..5b7ad6d45bc 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/lineorder_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/lineorder_create.sql
@@ -28,6 +28,7 @@ PARTITION p1997 VALUES [("19970101"), ("19980101")),
PARTITION p1998 VALUES [("19980101"), ("19990101")))
DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/part_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/part_create.sql
index 0c6f6e371aa..8d03167f909 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/part_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/part_create.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS `part` (
UNIQUE KEY (`p_partkey`)
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
diff --git
a/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/supplier_create.sql
b/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/supplier_create.sql
index b021767b47c..dd146b460c2 100644
---
a/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/supplier_create.sql
+++
b/regression-test/suites/unique_with_mow_p2/ssb_unique_sql_zstd/ddl/supplier_create.sql
@@ -10,6 +10,7 @@ CREATE TABLE IF NOT EXISTS `supplier` (
UNIQUE KEY (`s_suppkey`)
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
