This is an automated email from the ASF dual-hosted git repository.
gavinchou 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 390e3333154 [Enhancement](delete) Modify some p2 delete cases'
property (#37689)
390e3333154 is described below
commit 390e3333154357171008e77ce698844df8263112
Author: abmdocrt <yukang.lian2...@gmail.com>
AuthorDate: Fri Sep 13 20:58:18 2024 +0800
[Enhancement](delete) Modify some p2 delete cases' property (#37689)
In #35917 and #37151, we changed MOW table default delete command from
delete predicate to delete sign. It makes sure the correctness during
partial update but leads to slowdowns. Actually, if there is no partial
update, delete predicate will not lead to data fault. Delete data by
delete predicate or delete sign can be controlled by a table property
"enable_light_delete". If "enable_light_delete=true", we execute delete
command by delete predicate. Otherwise, we execute delete command by
delete sign.
In p2 cases, there are lots of cases with large data need to delete and
do not perform partial column update operations. Therefore, in order to
make it faster, we change some cases default create table clause.
---
.../test_group_commit_http_stream_lineitem_schema_change.groovy | 2 ++
.../test_group_commit_insert_into_lineitem_scheme_change.groovy | 2 ++
.../test_group_commit_stream_load_lineitem_schema_change.groovy | 2 ++
regression-test/suites/insert_p2/txn_insert_concurrent_insert_ud.groovy | 1 +
.../suites/insert_p2/txn_insert_concurrent_insert_update.groovy | 1 +
regression-test/suites/insert_p2/txn_insert_with_schema_change.groovy | 1 +
regression-test/suites/tpch_sf100_p2/ddl/customer.sql | 1 +
regression-test/suites/tpch_sf100_p2/ddl/lineitem.sql | 1 +
regression-test/suites/tpch_sf100_p2/ddl/nation.sql | 1 +
regression-test/suites/tpch_sf100_p2/ddl/orders.sql | 1 +
regression-test/suites/tpch_sf100_p2/ddl/part.sql | 1 +
regression-test/suites/tpch_sf100_p2/ddl/partsupp.sql | 1 +
regression-test/suites/tpch_sf100_p2/ddl/region.sql | 1 +
regression-test/suites/tpch_sf100_p2/ddl/supplier.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_p2/ddl/create_table.sql | 1 +
regression-test/suites/tpch_sf1_p2/ddl/customer.sql | 1 +
regression-test/suites/tpch_sf1_p2/ddl/lineitem.sql | 1 +
regression-test/suites/tpch_sf1_p2/ddl/nation.sql | 1 +
regression-test/suites/tpch_sf1_p2/ddl/orders.sql | 1 +
regression-test/suites/tpch_sf1_p2/ddl/part.sql | 1 +
regression-test/suites/tpch_sf1_p2/ddl/partsupp.sql | 1 +
regression-test/suites/tpch_sf1_p2/ddl/region.sql | 1 +
regression-test/suites/tpch_sf1_p2/ddl/supplier.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_c_p2/ssb_unique_load_zstd/ddl/customer_create.sql | 1 +
.../ssb_unique_load_zstd/ddl/customer_sequence_create.sql | 1 +
.../unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/date_create.sql | 1 +
.../ssb_unique_load_zstd/ddl/date_sequence_create.sql | 1 +
.../unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/lineorder_create.sql | 1 +
.../ssb_unique_load_zstd/ddl/lineorder_sequence_create.sql | 1 +
.../unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/part_create.sql | 1 +
.../ssb_unique_load_zstd/ddl/part_sequence_create.sql | 1 +
.../unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/supplier_create.sql | 1 +
.../ssb_unique_load_zstd/ddl/supplier_sequence_create.sql | 1 +
.../unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/customer_create.sql | 1 +
.../suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/date_create.sql | 1 +
.../unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/lineorder_create.sql | 1 +
.../suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/part_create.sql | 1 +
.../unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/supplier_create.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 +
.../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 +
.../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 +
101 files changed, 104 insertions(+)
diff --git
a/regression-test/suites/insert_p2/test_group_commit_http_stream_lineitem_schema_change.groovy
b/regression-test/suites/insert_p2/test_group_commit_http_stream_lineitem_schema_change.groovy
index 2d0246774c4..2abfcd86126 100644
---
a/regression-test/suites/insert_p2/test_group_commit_http_stream_lineitem_schema_change.groovy
+++
b/regression-test/suites/insert_p2/test_group_commit_http_stream_lineitem_schema_change.groovy
@@ -113,6 +113,7 @@ DUPLICATE KEY(`l_shipdate`, `l_orderkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
);
"""
@@ -144,6 +145,7 @@ DUPLICATE KEY(`l_shipdate`, `l_orderkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
);
"""
diff --git
a/regression-test/suites/insert_p2/test_group_commit_insert_into_lineitem_scheme_change.groovy
b/regression-test/suites/insert_p2/test_group_commit_insert_into_lineitem_scheme_change.groovy
index 4043c7660ce..7924260b72a 100644
---
a/regression-test/suites/insert_p2/test_group_commit_insert_into_lineitem_scheme_change.groovy
+++
b/regression-test/suites/insert_p2/test_group_commit_insert_into_lineitem_scheme_change.groovy
@@ -129,6 +129,7 @@ DUPLICATE KEY(`l_shipdate`, `l_orderkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
);
"""
@@ -161,6 +162,7 @@ DUPLICATE KEY(`l_shipdate`, `l_orderkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
);
"""
diff --git
a/regression-test/suites/insert_p2/test_group_commit_stream_load_lineitem_schema_change.groovy
b/regression-test/suites/insert_p2/test_group_commit_stream_load_lineitem_schema_change.groovy
index 86c422f0d73..b42f5d9038c 100644
---
a/regression-test/suites/insert_p2/test_group_commit_stream_load_lineitem_schema_change.groovy
+++
b/regression-test/suites/insert_p2/test_group_commit_stream_load_lineitem_schema_change.groovy
@@ -114,6 +114,7 @@ DUPLICATE KEY(`l_shipdate`, `l_orderkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
);
"""
@@ -145,6 +146,7 @@ DUPLICATE KEY(`l_shipdate`, `l_orderkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
);
"""
diff --git
a/regression-test/suites/insert_p2/txn_insert_concurrent_insert_ud.groovy
b/regression-test/suites/insert_p2/txn_insert_concurrent_insert_ud.groovy
index fe1f5533701..a524703f9ef 100644
--- a/regression-test/suites/insert_p2/txn_insert_concurrent_insert_ud.groovy
+++ b/regression-test/suites/insert_p2/txn_insert_concurrent_insert_ud.groovy
@@ -57,6 +57,7 @@ suite("txn_insert_concurrent_insert_ud") {
UNIQUE KEY(L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER)
DISTRIBUTED BY HASH(L_ORDERKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
"""
diff --git
a/regression-test/suites/insert_p2/txn_insert_concurrent_insert_update.groovy
b/regression-test/suites/insert_p2/txn_insert_concurrent_insert_update.groovy
index a5d0bcd114b..b467a87de82 100644
---
a/regression-test/suites/insert_p2/txn_insert_concurrent_insert_update.groovy
+++
b/regression-test/suites/insert_p2/txn_insert_concurrent_insert_update.groovy
@@ -57,6 +57,7 @@ suite("txn_insert_concurrent_insert_update") {
UNIQUE KEY(L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER)
DISTRIBUTED BY HASH(L_ORDERKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
"""
diff --git
a/regression-test/suites/insert_p2/txn_insert_with_schema_change.groovy
b/regression-test/suites/insert_p2/txn_insert_with_schema_change.groovy
index 56692b68d37..ac05e3a69f4 100644
--- a/regression-test/suites/insert_p2/txn_insert_with_schema_change.groovy
+++ b/regression-test/suites/insert_p2/txn_insert_with_schema_change.groovy
@@ -54,6 +54,7 @@ suite("txn_insert_with_schema_change") {
DUPLICATE KEY(L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER)
DISTRIBUTED BY HASH(L_ORDERKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
"""
diff --git a/regression-test/suites/tpch_sf100_p2/ddl/customer.sql
b/regression-test/suites/tpch_sf100_p2/ddl/customer.sql
index 5f41d6dbb12..32665f2ce6a 100644
--- a/regression-test/suites/tpch_sf100_p2/ddl/customer.sql
+++ b/regression-test/suites/tpch_sf100_p2/ddl/customer.sql
@@ -11,6 +11,7 @@ CREATE TABLE IF NOT EXISTS customer (
DUPLICATE KEY(C_CUSTKEY, C_NAME)
DISTRIBUTED BY HASH(C_CUSTKEY) BUCKETS 32
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf100_p2/ddl/lineitem.sql
b/regression-test/suites/tpch_sf100_p2/ddl/lineitem.sql
index 34fce81b607..eebd825dc8a 100644
--- a/regression-test/suites/tpch_sf100_p2/ddl/lineitem.sql
+++ b/regression-test/suites/tpch_sf100_p2/ddl/lineitem.sql
@@ -19,6 +19,7 @@ CREATE TABLE IF NOT EXISTS lineitem (
DUPLICATE KEY(L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER)
DISTRIBUTED BY HASH(L_ORDERKEY) BUCKETS 32
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf100_p2/ddl/nation.sql
b/regression-test/suites/tpch_sf100_p2/ddl/nation.sql
index 56c133ce1ea..1e11fa86ea9 100644
--- a/regression-test/suites/tpch_sf100_p2/ddl/nation.sql
+++ b/regression-test/suites/tpch_sf100_p2/ddl/nation.sql
@@ -7,6 +7,7 @@ CREATE TABLE IF NOT EXISTS nation (
DUPLICATE KEY(N_NATIONKEY, N_NAME)
DISTRIBUTED BY HASH(N_NATIONKEY) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf100_p2/ddl/orders.sql
b/regression-test/suites/tpch_sf100_p2/ddl/orders.sql
index 1843ef0f2a5..a02695d5177 100644
--- a/regression-test/suites/tpch_sf100_p2/ddl/orders.sql
+++ b/regression-test/suites/tpch_sf100_p2/ddl/orders.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS orders (
DUPLICATE KEY(O_ORDERKEY, O_CUSTKEY)
DISTRIBUTED BY HASH(O_ORDERKEY) BUCKETS 32
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf100_p2/ddl/part.sql
b/regression-test/suites/tpch_sf100_p2/ddl/part.sql
index f5e75cef3f0..91de8dfa43b 100644
--- a/regression-test/suites/tpch_sf100_p2/ddl/part.sql
+++ b/regression-test/suites/tpch_sf100_p2/ddl/part.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS part (
DUPLICATE KEY(P_PARTKEY, P_NAME)
DISTRIBUTED BY HASH(P_PARTKEY) BUCKETS 32
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf100_p2/ddl/partsupp.sql
b/regression-test/suites/tpch_sf100_p2/ddl/partsupp.sql
index 72263631c58..ffb686f3716 100644
--- a/regression-test/suites/tpch_sf100_p2/ddl/partsupp.sql
+++ b/regression-test/suites/tpch_sf100_p2/ddl/partsupp.sql
@@ -8,6 +8,7 @@ CREATE TABLE IF NOT EXISTS partsupp (
DUPLICATE KEY(PS_PARTKEY, PS_SUPPKEY)
DISTRIBUTED BY HASH(PS_PARTKEY) BUCKETS 32
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf100_p2/ddl/region.sql
b/regression-test/suites/tpch_sf100_p2/ddl/region.sql
index fc94a17d46b..d4170a03432 100644
--- a/regression-test/suites/tpch_sf100_p2/ddl/region.sql
+++ b/regression-test/suites/tpch_sf100_p2/ddl/region.sql
@@ -6,6 +6,7 @@ CREATE TABLE IF NOT EXISTS region (
DUPLICATE KEY(R_REGIONKEY, R_NAME)
DISTRIBUTED BY HASH(R_REGIONKEY) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf100_p2/ddl/supplier.sql
b/regression-test/suites/tpch_sf100_p2/ddl/supplier.sql
index 156d5c9f356..c09e59e72f2 100644
--- a/regression-test/suites/tpch_sf100_p2/ddl/supplier.sql
+++ b/regression-test/suites/tpch_sf100_p2/ddl/supplier.sql
@@ -10,5 +10,6 @@ CREATE TABLE IF NOT EXISTS supplier (
DUPLICATE KEY(S_SUPPKEY, S_NAME)
DISTRIBUTED BY HASH(S_SUPPKEY) BUCKETS 32
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"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_p2/ddl/create_table.sql
b/regression-test/suites/tpch_sf1_p2/ddl/create_table.sql
index 324b167fc80..015058d6d89 100644
--- a/regression-test/suites/tpch_sf1_p2/ddl/create_table.sql
+++ b/regression-test/suites/tpch_sf1_p2/ddl/create_table.sql
@@ -6,5 +6,6 @@ CREATE TABLE IF NOT EXISTS gavin_test (
DUPLICATE KEY(id, name)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_p2/ddl/customer.sql
b/regression-test/suites/tpch_sf1_p2/ddl/customer.sql
index 00b1b98d489..0a98bb99ae2 100644
--- a/regression-test/suites/tpch_sf1_p2/ddl/customer.sql
+++ b/regression-test/suites/tpch_sf1_p2/ddl/customer.sql
@@ -11,6 +11,7 @@ CREATE TABLE IF NOT EXISTS customer (
DUPLICATE KEY(C_CUSTKEY, C_NAME)
DISTRIBUTED BY HASH(C_CUSTKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_p2/ddl/lineitem.sql
b/regression-test/suites/tpch_sf1_p2/ddl/lineitem.sql
index 2b4cb771438..30b29ee39c6 100644
--- a/regression-test/suites/tpch_sf1_p2/ddl/lineitem.sql
+++ b/regression-test/suites/tpch_sf1_p2/ddl/lineitem.sql
@@ -19,6 +19,7 @@ CREATE TABLE IF NOT EXISTS lineitem (
DUPLICATE KEY(L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER)
DISTRIBUTED BY HASH(L_ORDERKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_p2/ddl/nation.sql
b/regression-test/suites/tpch_sf1_p2/ddl/nation.sql
index 3eccc0dc976..b88f8c7365e 100644
--- a/regression-test/suites/tpch_sf1_p2/ddl/nation.sql
+++ b/regression-test/suites/tpch_sf1_p2/ddl/nation.sql
@@ -7,6 +7,7 @@ CREATE TABLE IF NOT EXISTS nation (
DUPLICATE KEY(N_NATIONKEY, N_NAME)
DISTRIBUTED BY HASH(N_NATIONKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_p2/ddl/orders.sql
b/regression-test/suites/tpch_sf1_p2/ddl/orders.sql
index caeaa341508..2574b829467 100644
--- a/regression-test/suites/tpch_sf1_p2/ddl/orders.sql
+++ b/regression-test/suites/tpch_sf1_p2/ddl/orders.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS orders (
DUPLICATE KEY(O_ORDERKEY, O_CUSTKEY)
DISTRIBUTED BY HASH(O_ORDERKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_p2/ddl/part.sql
b/regression-test/suites/tpch_sf1_p2/ddl/part.sql
index 994b6e66d55..e33cb50538c 100644
--- a/regression-test/suites/tpch_sf1_p2/ddl/part.sql
+++ b/regression-test/suites/tpch_sf1_p2/ddl/part.sql
@@ -12,6 +12,7 @@ CREATE TABLE IF NOT EXISTS part (
DUPLICATE KEY(P_PARTKEY, P_NAME)
DISTRIBUTED BY HASH(P_PARTKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_p2/ddl/partsupp.sql
b/regression-test/suites/tpch_sf1_p2/ddl/partsupp.sql
index be186a29db9..8ccc23a2794 100644
--- a/regression-test/suites/tpch_sf1_p2/ddl/partsupp.sql
+++ b/regression-test/suites/tpch_sf1_p2/ddl/partsupp.sql
@@ -8,6 +8,7 @@ CREATE TABLE IF NOT EXISTS partsupp (
DUPLICATE KEY(PS_PARTKEY, PS_SUPPKEY)
DISTRIBUTED BY HASH(PS_PARTKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_p2/ddl/region.sql
b/regression-test/suites/tpch_sf1_p2/ddl/region.sql
index fbe34c05c6f..fde4c2add33 100644
--- a/regression-test/suites/tpch_sf1_p2/ddl/region.sql
+++ b/regression-test/suites/tpch_sf1_p2/ddl/region.sql
@@ -6,6 +6,7 @@ CREATE TABLE IF NOT EXISTS region (
DUPLICATE KEY(R_REGIONKEY, R_NAME)
DISTRIBUTED BY HASH(R_REGIONKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
diff --git a/regression-test/suites/tpch_sf1_p2/ddl/supplier.sql
b/regression-test/suites/tpch_sf1_p2/ddl/supplier.sql
index 7214eaebd12..244db711c43 100644
--- a/regression-test/suites/tpch_sf1_p2/ddl/supplier.sql
+++ b/regression-test/suites/tpch_sf1_p2/ddl/supplier.sql
@@ -10,5 +10,6 @@ CREATE TABLE IF NOT EXISTS supplier (
DUPLICATE KEY(S_SUPPKEY, S_NAME)
DISTRIBUTED BY HASH(S_SUPPKEY) BUCKETS 3
PROPERTIES (
+ "enable_mow_light_delete" = "true",
"replication_num" = "1"
)
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_c_p2/ssb_unique_load_zstd/ddl/customer_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/customer_create.sql
index 30df14525cf..22145548145 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/customer_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/customer_create.sql
@@ -12,6 +12,7 @@ UNIQUE KEY (`c_custkey`)
CLUSTER BY (`c_region`, `c_phone`, `c_city`)
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"disable_auto_compaction" = "true",
diff --git
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/customer_sequence_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/customer_sequence_create.sql
index 892384684bf..9508841da0f 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/customer_sequence_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/customer_sequence_create.sql
@@ -12,6 +12,7 @@ UNIQUE KEY (`c_custkey`)
CLUSTER BY (`c_mktsegment`, `c_city`, `c_region`, `c_nation`)
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/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/date_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/date_create.sql
index ffd796f227a..5e2490b3e72 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/date_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/date_create.sql
@@ -21,6 +21,7 @@ UNIQUE KEY (`d_datekey`)
CLUSTER BY (`d_sellingseason`, `d_holidayfl`)
DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"disable_auto_compaction" = "true",
diff --git
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/date_sequence_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/date_sequence_create.sql
index 9ec46190c79..447c6276a24 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/date_sequence_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/date_sequence_create.sql
@@ -21,6 +21,7 @@ UNIQUE KEY (`d_datekey`)
CLUSTER BY (`d_sellingseason`, `d_lastdayinweekfl`)
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/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/lineorder_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/lineorder_create.sql
index 0945fe0af46..094015d3ec4 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/lineorder_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/lineorder_create.sql
@@ -29,6 +29,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",
"disable_auto_compaction" = "true",
diff --git
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/lineorder_sequence_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/lineorder_sequence_create.sql
index a9b1d411561..39502312434 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/lineorder_sequence_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/lineorder_sequence_create.sql
@@ -29,6 +29,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/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/part_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/part_create.sql
index 86e906b4c2b..b98d195979a 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/part_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/part_create.sql
@@ -13,6 +13,7 @@ UNIQUE KEY (`p_partkey`)
CLUSTER BY (`p_color`, `p_name`, `p_category`)
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"disable_auto_compaction" = "true",
diff --git
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/part_sequence_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/part_sequence_create.sql
index 5ba4038e12d..f6f7a84dc21 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/part_sequence_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/part_sequence_create.sql
@@ -13,6 +13,7 @@ UNIQUE KEY (`p_partkey`)
CLUSTER BY (`p_size`, `p_type`, `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/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/supplier_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/supplier_create.sql
index 404e4987b44..85e10df302f 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/supplier_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/supplier_create.sql
@@ -11,6 +11,7 @@ UNIQUE KEY (`s_suppkey`)
CLUSTER BY (`s_address`)
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
PROPERTIES (
+"enable_mow_light_delete" = "true",
"compression"="zstd",
"replication_num" = "1",
"disable_auto_compaction" = "true",
diff --git
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/supplier_sequence_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/supplier_sequence_create.sql
index 74fa9c46baa..356a6079f04 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/supplier_sequence_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_load_zstd/ddl/supplier_sequence_create.sql
@@ -11,6 +11,7 @@ UNIQUE KEY (`s_suppkey`)
CLUSTER BY (`s_nation`, `s_region`, `s_city`, `s_name`)
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/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/customer_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/customer_create.sql
index 9e201b44646..5ade9e170ad 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/customer_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/customer_create.sql
@@ -12,6 +12,7 @@ UNIQUE KEY (`c_custkey`)
CLUSTER BY (`c_region`, `c_address`, `c_city`, `c_name`)
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_c_p2/ssb_unique_sql_zstd/ddl/date_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/date_create.sql
index 3d12170cf99..0ae14f534ca 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/date_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/date_create.sql
@@ -21,6 +21,7 @@ UNIQUE KEY (`d_datekey`)
CLUSTER BY (`d_weeknuminyear`, `d_month`)
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_c_p2/ssb_unique_sql_zstd/ddl/lineorder_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/lineorder_create.sql
index b9481142be1..4d213e2ff14 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/lineorder_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/lineorder_create.sql
@@ -29,6 +29,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_c_p2/ssb_unique_sql_zstd/ddl/part_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/part_create.sql
index 3975ff83f09..980c57e0a90 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/part_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/part_create.sql
@@ -13,6 +13,7 @@ UNIQUE KEY (`p_partkey`)
CLUSTER BY (`p_color`, `p_container`)
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_c_p2/ssb_unique_sql_zstd/ddl/supplier_create.sql
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/supplier_create.sql
index 7e101c5667f..78d4e332efb 100644
---
a/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/supplier_create.sql
+++
b/regression-test/suites/unique_with_mow_c_p2/ssb_unique_sql_zstd/ddl/supplier_create.sql
@@ -11,6 +11,7 @@ UNIQUE KEY (`s_suppkey`)
CLUSTER BY (`s_address`, `s_name`)
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/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
