This is an automated email from the ASF dual-hosted git repository.
diwu pushed a commit to branch revert-10957-ssb_zstd_unique_table
in repository https://gitbox.apache.org/repos/asf/doris.git
commit bd6227ad3978d00adedf76b7e0e2ed1a80e0efb5
Author: wudi <676366...@qq.com>
AuthorDate: Tue Jul 19 10:55:26 2022 +0800
Revert "[regression] Add ssb sf1 test under unique table with zstd (#10957)"
This reverts commit 216a55c12c0be5c4090523195b2aff9d96c64f65.
---
.../data/ssb_sf1_unique_sql_zstd/sql/q1.1.out | 4 -
.../data/ssb_sf1_unique_sql_zstd/sql/q1.2.out | 4 -
.../data/ssb_sf1_unique_sql_zstd/sql/q1.3.out | 4 -
.../data/ssb_sf1_unique_sql_zstd/sql/q2.1.out | 283 ---------
.../data/ssb_sf1_unique_sql_zstd/sql/q2.2.out | 59 --
.../data/ssb_sf1_unique_sql_zstd/sql/q2.3.out | 10 -
.../data/ssb_sf1_unique_sql_zstd/sql/q3.1.out | 153 -----
.../data/ssb_sf1_unique_sql_zstd/sql/q3.2.out | 602 ------------------
.../data/ssb_sf1_unique_sql_zstd/sql/q3.3.out | 27 -
.../data/ssb_sf1_unique_sql_zstd/sql/q3.4.out | 6 -
.../data/ssb_sf1_unique_sql_zstd/sql/q4.1.out | 38 --
.../data/ssb_sf1_unique_sql_zstd/sql/q4.2.out | 103 ---
.../data/ssb_sf1_unique_sql_zstd/sql/q4.3.out | 697 ---------------------
.../ddl/customer_create.sql | 16 -
.../ddl/customer_delete.sql | 1 -
.../ddl/customer_part_delete.sql | 1 -
.../ddl/customer_sequence_create.sql | 17 -
.../ssb_sf1_unique_load_zstd/ddl/date_create.sql | 25 -
.../ssb_sf1_unique_load_zstd/ddl/date_delete.sql | 1 -
.../ddl/date_part_delete.sql | 1 -
.../ddl/date_sequence_create.sql | 26 -
.../ddl/lineorder_create.sql | 33 -
.../ddl/lineorder_delete.sql | 1 -
.../ddl/lineorder_part_delete.sql | 1 -
.../ddl/lineorder_sequence_create.sql | 34 -
.../ssb_sf1_unique_load_zstd/ddl/part_create.sql | 17 -
.../ssb_sf1_unique_load_zstd/ddl/part_delete.sql | 1 -
.../ddl/part_part_delete.sql | 1 -
.../ddl/part_sequence_create.sql | 18 -
.../ddl/supplier_create.sql | 15 -
.../ddl/supplier_delete.sql | 1 -
.../ddl/supplier_part_delete.sql | 1 -
.../ddl/supplier_sequence_create.sql | 16 -
.../ssb_sf1_unique_load_zstd/load_four_step.groovy | 112 ----
.../ssb_sf1_unique_load_zstd/load_one_step.groovy | 68 --
.../load_three_step.groovy | 77 ---
.../ssb_sf1_unique_load_zstd/load_two_step.groovy | 75 ---
.../ddl/customer_create.sql | 16 -
.../ddl/customer_delete.sql | 1 -
.../ssb_sf1_unique_sql_zstd/ddl/date_create.sql | 25 -
.../ssb_sf1_unique_sql_zstd/ddl/date_delete.sql | 1 -
.../ddl/lineorder_create.sql | 33 -
.../ddl/lineorder_delete.sql | 1 -
.../ssb_sf1_unique_sql_zstd/ddl/part_create.sql | 17 -
.../ssb_sf1_unique_sql_zstd/ddl/part_delete.sql | 1 -
.../ddl/supplier_create.sql | 15 -
.../ddl/supplier_delete.sql | 1 -
.../suites/ssb_sf1_unique_sql_zstd/load.groovy | 86 ---
.../suites/ssb_sf1_unique_sql_zstd/sql/q1.1.sql | 24 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q1.2.sql | 24 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q1.3.sql | 25 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q2.1.sql | 26 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q2.2.sql | 27 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q2.3.sql | 26 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q3.1.sql | 28 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q3.2.sql | 28 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q3.3.sql | 30 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q3.4.sql | 30 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q4.1.sql | 30 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q4.2.sql | 31 -
.../suites/ssb_sf1_unique_sql_zstd/sql/q4.3.sql | 29 -
61 files changed, 3104 deletions(-)
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q1.1.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q1.1.out
deleted file mode 100644
index ba450f16d5..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q1.1.out
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q1.1 --
-446031203850
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q1.2.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q1.2.out
deleted file mode 100644
index 9e6e59831d..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q1.2.out
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q1.2 --
-98714004603
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q1.3.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q1.3.out
deleted file mode 100644
index dd5cabbd7c..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q1.3.out
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q1.3 --
-26232701005
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q2.1.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q2.1.out
deleted file mode 100644
index e1ebddab41..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q2.1.out
+++ /dev/null
@@ -1,283 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q2.1 --
-567838207 1992 MFGR#121
-610663790 1992 MFGR#1210
-550769662 1992 MFGR#1211
-649205856 1992 MFGR#1212
-624031241 1992 MFGR#1213
-670488468 1992 MFGR#1214
-633152470 1992 MFGR#1215
-674846781 1992 MFGR#1216
-675093435 1992 MFGR#1217
-600202070 1992 MFGR#1218
-538043594 1992 MFGR#1219
-655326672 1992 MFGR#122
-540262882 1992 MFGR#1220
-556120633 1992 MFGR#1221
-590762777 1992 MFGR#1222
-535448651 1992 MFGR#1223
-703752611 1992 MFGR#1224
-570832868 1992 MFGR#1225
-614061593 1992 MFGR#1226
-581759388 1992 MFGR#1227
-644642592 1992 MFGR#1228
-640858430 1992 MFGR#1229
-789755835 1992 MFGR#123
-468535087 1992 MFGR#1230
-592436656 1992 MFGR#1231
-664275152 1992 MFGR#1232
-613885100 1992 MFGR#1233
-667399281 1992 MFGR#1234
-640290070 1992 MFGR#1235
-501892561 1992 MFGR#1236
-591481503 1992 MFGR#1237
-477423770 1992 MFGR#1238
-638259374 1992 MFGR#1239
-572354196 1992 MFGR#124
-740479248 1992 MFGR#1240
-478777095 1992 MFGR#125
-592174616 1992 MFGR#126
-706151632 1992 MFGR#127
-542306646 1992 MFGR#128
-581987352 1992 MFGR#129
-823087702 1993 MFGR#121
-648160706 1993 MFGR#1210
-634743898 1993 MFGR#1211
-785639283 1993 MFGR#1212
-638255029 1993 MFGR#1213
-616837237 1993 MFGR#1214
-634687975 1993 MFGR#1215
-638353900 1993 MFGR#1216
-663372951 1993 MFGR#1217
-683985855 1993 MFGR#1218
-646950033 1993 MFGR#1219
-622532984 1993 MFGR#122
-530830127 1993 MFGR#1220
-543346337 1993 MFGR#1221
-756921203 1993 MFGR#1222
-533544350 1993 MFGR#1223
-915916085 1993 MFGR#1224
-473007381 1993 MFGR#1225
-739036124 1993 MFGR#1226
-592178887 1993 MFGR#1227
-583507058 1993 MFGR#1228
-617453491 1993 MFGR#1229
-637863868 1993 MFGR#123
-625534310 1993 MFGR#1230
-580327635 1993 MFGR#1231
-697373098 1993 MFGR#1232
-515571416 1993 MFGR#1233
-651935758 1993 MFGR#1234
-575779480 1993 MFGR#1235
-591878667 1993 MFGR#1236
-609618576 1993 MFGR#1237
-444614010 1993 MFGR#1238
-595256327 1993 MFGR#1239
-660586237 1993 MFGR#124
-788730059 1993 MFGR#1240
-616224539 1993 MFGR#125
-617126754 1993 MFGR#126
-654438324 1993 MFGR#127
-731657001 1993 MFGR#128
-548048395 1993 MFGR#129
-564405648 1994 MFGR#121
-645404849 1994 MFGR#1210
-631620635 1994 MFGR#1211
-568332348 1994 MFGR#1212
-678785857 1994 MFGR#1213
-534002330 1994 MFGR#1214
-654400242 1994 MFGR#1215
-558646341 1994 MFGR#1216
-687845641 1994 MFGR#1217
-546674347 1994 MFGR#1218
-567272942 1994 MFGR#1219
-659884062 1994 MFGR#122
-562582172 1994 MFGR#1220
-598618997 1994 MFGR#1221
-601016441 1994 MFGR#1222
-555134404 1994 MFGR#1223
-737422302 1994 MFGR#1224
-570745955 1994 MFGR#1225
-746302245 1994 MFGR#1226
-651707481 1994 MFGR#1227
-573693547 1994 MFGR#1228
-647918373 1994 MFGR#1229
-580449592 1994 MFGR#123
-493270412 1994 MFGR#1230
-603546148 1994 MFGR#1231
-719865331 1994 MFGR#1232
-638982238 1994 MFGR#1233
-743247677 1994 MFGR#1234
-598680959 1994 MFGR#1235
-615726097 1994 MFGR#1236
-542569815 1994 MFGR#1237
-573510781 1994 MFGR#1238
-579855853 1994 MFGR#1239
-684573322 1994 MFGR#124
-873735737 1994 MFGR#1240
-560488304 1994 MFGR#125
-657036514 1994 MFGR#126
-622571183 1994 MFGR#127
-586845664 1994 MFGR#128
-534541525 1994 MFGR#129
-706469511 1995 MFGR#121
-602892803 1995 MFGR#1210
-645166092 1995 MFGR#1211
-613289283 1995 MFGR#1212
-599586479 1995 MFGR#1213
-562570804 1995 MFGR#1214
-672528755 1995 MFGR#1215
-669000972 1995 MFGR#1216
-725362449 1995 MFGR#1217
-657026635 1995 MFGR#1218
-519659003 1995 MFGR#1219
-724727741 1995 MFGR#122
-517956131 1995 MFGR#1220
-635741351 1995 MFGR#1221
-564368410 1995 MFGR#1222
-600665149 1995 MFGR#1223
-762700351 1995 MFGR#1224
-671669586 1995 MFGR#1225
-572568748 1995 MFGR#1226
-530361300 1995 MFGR#1227
-633357085 1995 MFGR#1228
-547960244 1995 MFGR#1229
-660711077 1995 MFGR#123
-602735858 1995 MFGR#1230
-499852146 1995 MFGR#1231
-715300753 1995 MFGR#1232
-557149571 1995 MFGR#1233
-710023059 1995 MFGR#1234
-622425239 1995 MFGR#1235
-634565501 1995 MFGR#1236
-572847270 1995 MFGR#1237
-549318912 1995 MFGR#1238
-593851712 1995 MFGR#1239
-585421815 1995 MFGR#124
-707207888 1995 MFGR#1240
-538246872 1995 MFGR#125
-605799021 1995 MFGR#126
-665978112 1995 MFGR#127
-646960956 1995 MFGR#128
-508749401 1995 MFGR#129
-523879145 1996 MFGR#121
-643645053 1996 MFGR#1210
-595065339 1996 MFGR#1211
-674626440 1996 MFGR#1212
-496297087 1996 MFGR#1213
-583249505 1996 MFGR#1214
-702184857 1996 MFGR#1215
-601809334 1996 MFGR#1216
-704898387 1996 MFGR#1217
-528843086 1996 MFGR#1218
-586246330 1996 MFGR#1219
-712110492 1996 MFGR#122
-518444215 1996 MFGR#1220
-499319414 1996 MFGR#1221
-679469356 1996 MFGR#1222
-628762754 1996 MFGR#1223
-724844856 1996 MFGR#1224
-660620587 1996 MFGR#1225
-667674729 1996 MFGR#1226
-483838085 1996 MFGR#1227
-609855391 1996 MFGR#1228
-658959557 1996 MFGR#1229
-566217852 1996 MFGR#123
-528879998 1996 MFGR#1230
-589481194 1996 MFGR#1231
-702805896 1996 MFGR#1232
-663679947 1996 MFGR#1233
-571149450 1996 MFGR#1234
-478648074 1996 MFGR#1235
-568249365 1996 MFGR#1236
-592616167 1996 MFGR#1237
-466676148 1996 MFGR#1238
-670693719 1996 MFGR#1239
-560667719 1996 MFGR#124
-821167950 1996 MFGR#1240
-476864333 1996 MFGR#125
-558030884 1996 MFGR#126
-635873891 1996 MFGR#127
-551010618 1996 MFGR#128
-560570630 1996 MFGR#129
-587013207 1997 MFGR#121
-616287892 1997 MFGR#1210
-548588761 1997 MFGR#1211
-589593892 1997 MFGR#1212
-424306670 1997 MFGR#1213
-511971910 1997 MFGR#1214
-631772246 1997 MFGR#1215
-692135140 1997 MFGR#1216
-777994957 1997 MFGR#1217
-707053720 1997 MFGR#1218
-561169527 1997 MFGR#1219
-664916245 1997 MFGR#122
-594466157 1997 MFGR#1220
-588848171 1997 MFGR#1221
-528988960 1997 MFGR#1222
-537098211 1997 MFGR#1223
-674763166 1997 MFGR#1224
-450402292 1997 MFGR#1225
-701360722 1997 MFGR#1226
-506011570 1997 MFGR#1227
-585578737 1997 MFGR#1228
-622744016 1997 MFGR#1229
-646503168 1997 MFGR#123
-571800941 1997 MFGR#1230
-502601790 1997 MFGR#1231
-677924656 1997 MFGR#1232
-534455976 1997 MFGR#1233
-714934715 1997 MFGR#1234
-767151420 1997 MFGR#1235
-618877179 1997 MFGR#1236
-639638057 1997 MFGR#1237
-401953419 1997 MFGR#1238
-610756714 1997 MFGR#1239
-543248087 1997 MFGR#124
-675132692 1997 MFGR#1240
-479099365 1997 MFGR#125
-570696568 1997 MFGR#126
-583074592 1997 MFGR#127
-695133104 1997 MFGR#128
-655638776 1997 MFGR#129
-344575925 1998 MFGR#121
-417152416 1998 MFGR#1210
-317068168 1998 MFGR#1211
-374341516 1998 MFGR#1212
-332740903 1998 MFGR#1213
-304873002 1998 MFGR#1214
-366101132 1998 MFGR#1215
-379133898 1998 MFGR#1216
-359508497 1998 MFGR#1217
-320623334 1998 MFGR#1218
-346182862 1998 MFGR#1219
-312440027 1998 MFGR#122
-348123961 1998 MFGR#1220
-339845398 1998 MFGR#1221
-355416161 1998 MFGR#1222
-344889822 1998 MFGR#1223
-396906691 1998 MFGR#1224
-290208878 1998 MFGR#1225
-419415707 1998 MFGR#1226
-358466340 1998 MFGR#1227
-251549955 1998 MFGR#1228
-383138860 1998 MFGR#1229
-296330561 1998 MFGR#123
-437181243 1998 MFGR#1230
-398944492 1998 MFGR#1231
-424062455 1998 MFGR#1232
-406967188 1998 MFGR#1233
-428867240 1998 MFGR#1234
-352277781 1998 MFGR#1235
-361827086 1998 MFGR#1236
-341618569 1998 MFGR#1237
-244739231 1998 MFGR#1238
-414151803 1998 MFGR#1239
-330082371 1998 MFGR#124
-415312453 1998 MFGR#1240
-360289624 1998 MFGR#125
-341657580 1998 MFGR#126
-377507061 1998 MFGR#127
-361416497 1998 MFGR#128
-318769573 1998 MFGR#129
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q2.2.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q2.2.out
deleted file mode 100644
index 8677d312f4..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q2.2.out
+++ /dev/null
@@ -1,59 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q2.2 --
-709524929 1992 MFGR#2221
-783846394 1992 MFGR#2222
-765052002 1992 MFGR#2223
-651488962 1992 MFGR#2224
-646528589 1992 MFGR#2225
-709650548 1992 MFGR#2226
-745556316 1992 MFGR#2227
-756901875 1992 MFGR#2228
-766521103 1993 MFGR#2221
-691475597 1993 MFGR#2222
-758220752 1993 MFGR#2223
-669662707 1993 MFGR#2224
-773854228 1993 MFGR#2225
-737087518 1993 MFGR#2226
-781967766 1993 MFGR#2227
-680880216 1993 MFGR#2228
-685777518 1994 MFGR#2221
-666524807 1994 MFGR#2222
-733993590 1994 MFGR#2223
-707869040 1994 MFGR#2224
-721251967 1994 MFGR#2225
-822495919 1994 MFGR#2226
-720837128 1994 MFGR#2227
-826225350 1994 MFGR#2228
-775437074 1995 MFGR#2221
-761354792 1995 MFGR#2222
-637832575 1995 MFGR#2223
-589765707 1995 MFGR#2224
-708290039 1995 MFGR#2225
-747356383 1995 MFGR#2226
-802502540 1995 MFGR#2227
-895936786 1995 MFGR#2228
-700010008 1996 MFGR#2221
-777310085 1996 MFGR#2222
-656095314 1996 MFGR#2223
-656859917 1996 MFGR#2224
-765820896 1996 MFGR#2225
-808177734 1996 MFGR#2226
-729563303 1996 MFGR#2227
-819665874 1996 MFGR#2228
-727342382 1997 MFGR#2221
-664533779 1997 MFGR#2222
-748288392 1997 MFGR#2223
-630422081 1997 MFGR#2224
-757391203 1997 MFGR#2225
-747889257 1997 MFGR#2226
-728857899 1997 MFGR#2227
-775312985 1997 MFGR#2228
-335304504 1998 MFGR#2221
-409347137 1998 MFGR#2222
-459109577 1998 MFGR#2223
-413318072 1998 MFGR#2224
-410402095 1998 MFGR#2225
-453515044 1998 MFGR#2226
-390506405 1998 MFGR#2227
-397939103 1998 MFGR#2228
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q2.3.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q2.3.out
deleted file mode 100644
index cb87e34504..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q2.3.out
+++ /dev/null
@@ -1,10 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q2.3 --
-726427486 1992 MFGR#2239
-705238959 1993 MFGR#2239
-664145134 1994 MFGR#2239
-713839336 1995 MFGR#2239
-728492865 1996 MFGR#2239
-733896532 1997 MFGR#2239
-380255731 1998 MFGR#2239
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.1.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.1.out
deleted file mode 100644
index c618f9495d..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.1.out
+++ /dev/null
@@ -1,153 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q3.1 --
-INDONESIA INDONESIA 1992 6905698988
-CHINA INDONESIA 1992 6616078869
-CHINA CHINA 1992 6456431477
-VIETNAM INDONESIA 1992 6340181707
-VIETNAM CHINA 1992 6332844390
-INDONESIA CHINA 1992 6310709533
-INDIA INDONESIA 1992 6238807354
-JAPAN INDONESIA 1992 6222565638
-CHINA INDIA 1992 6189831351
-CHINA JAPAN 1992 6157678893
-JAPAN CHINA 1992 6067100655
-INDIA CHINA 1992 6066461811
-VIETNAM JAPAN 1992 5863786349
-JAPAN INDIA 1992 5802749985
-INDONESIA INDIA 1992 5770203218
-VIETNAM INDIA 1992 5698511401
-INDONESIA JAPAN 1992 5663765610
-JAPAN JAPAN 1992 5648034711
-INDIA JAPAN 1992 5421959281
-CHINA VIETNAM 1992 5412322026
-JAPAN VIETNAM 1992 5401692555
-INDIA INDIA 1992 5361243755
-INDONESIA VIETNAM 1992 5302638372
-INDIA VIETNAM 1992 5245330621
-VIETNAM VIETNAM 1992 5111731778
-INDONESIA INDONESIA 1993 6931363262
-INDONESIA CHINA 1993 6612891249
-CHINA INDONESIA 1993 6581513366
-VIETNAM INDONESIA 1993 6511639352
-CHINA CHINA 1993 6444513787
-CHINA INDIA 1993 6421694121
-VIETNAM CHINA 1993 6413579999
-INDIA INDONESIA 1993 6331058594
-JAPAN CHINA 1993 6292293995
-INDIA CHINA 1993 6209353792
-CHINA JAPAN 1993 6195466884
-VIETNAM INDIA 1993 6161174477
-INDONESIA INDIA 1993 6151664306
-INDONESIA JAPAN 1993 6147605249
-JAPAN INDONESIA 1993 6053946313
-INDIA JAPAN 1993 5995208985
-CHINA VIETNAM 1993 5885023228
-VIETNAM JAPAN 1993 5874266867
-INDONESIA VIETNAM 1993 5840287722
-JAPAN INDIA 1993 5823343157
-INDIA INDIA 1993 5571575799
-VIETNAM VIETNAM 1993 5554161183
-JAPAN JAPAN 1993 5430318583
-JAPAN VIETNAM 1993 5406569653
-INDIA VIETNAM 1993 5233871487
-VIETNAM CHINA 1994 6709883442
-CHINA CHINA 1994 6648942965
-INDONESIA CHINA 1994 6483600910
-CHINA JAPAN 1994 6349037021
-VIETNAM INDONESIA 1994 6347441931
-JAPAN CHINA 1994 6320009218
-INDONESIA INDONESIA 1994 6315331086
-CHINA INDIA 1994 6297582811
-CHINA INDONESIA 1994 6234787896
-VIETNAM JAPAN 1994 6231973047
-INDONESIA INDIA 1994 6198412245
-INDIA INDONESIA 1994 6168189859
-INDONESIA JAPAN 1994 6141195969
-JAPAN INDONESIA 1994 6013034618
-CHINA VIETNAM 1994 5885318733
-INDIA CHINA 1994 5815022714
-VIETNAM INDIA 1994 5789398691
-JAPAN JAPAN 1994 5753821482
-JAPAN INDIA 1994 5645818872
-INDONESIA VIETNAM 1994 5624346368
-INDIA INDIA 1994 5584936515
-VIETNAM VIETNAM 1994 5418498159
-INDIA JAPAN 1994 5394134974
-JAPAN VIETNAM 1994 5275821637
-INDIA VIETNAM 1994 5251039815
-CHINA INDONESIA 1995 7074539444
-INDONESIA CHINA 1995 6928620620
-CHINA CHINA 1995 6624666612
-JAPAN CHINA 1995 6519889385
-VIETNAM CHINA 1995 6332731268
-INDONESIA INDONESIA 1995 6268531321
-VIETNAM JAPAN 1995 6263957020
-CHINA INDIA 1995 6246656374
-VIETNAM INDIA 1995 6198441957
-INDONESIA INDIA 1995 6173805183
-VIETNAM INDONESIA 1995 6057820148
-CHINA JAPAN 1995 6021854130
-INDONESIA JAPAN 1995 6019093871
-INDIA CHINA 1995 6010532793
-INDIA INDONESIA 1995 5975518597
-JAPAN JAPAN 1995 5952279129
-JAPAN INDONESIA 1995 5947000735
-VIETNAM VIETNAM 1995 5754727607
-JAPAN INDIA 1995 5730743126
-INDONESIA VIETNAM 1995 5574974066
-INDIA INDIA 1995 5565995550
-JAPAN VIETNAM 1995 5501313775
-CHINA VIETNAM 1995 5489936063
-INDIA JAPAN 1995 5469203427
-INDIA VIETNAM 1995 5207063284
-INDONESIA INDONESIA 1996 6750056283
-CHINA INDONESIA 1996 6657125075
-INDONESIA CHINA 1996 6613439112
-CHINA CHINA 1996 6591697915
-VIETNAM CHINA 1996 6428653890
-VIETNAM INDONESIA 1996 6295626732
-JAPAN INDONESIA 1996 6227447856
-INDIA CHINA 1996 6198567819
-INDIA INDONESIA 1996 6189242058
-CHINA INDIA 1996 6153787365
-INDONESIA INDIA 1996 6138810863
-CHINA JAPAN 1996 6105566324
-JAPAN CHINA 1996 6088985564
-INDONESIA JAPAN 1996 6055638222
-VIETNAM JAPAN 1996 5919997150
-VIETNAM VIETNAM 1996 5860842302
-INDIA JAPAN 1996 5841664805
-VIETNAM INDIA 1996 5807486983
-JAPAN INDIA 1996 5644579616
-JAPAN JAPAN 1996 5566204795
-INDIA INDIA 1996 5532073103
-INDONESIA VIETNAM 1996 5438514387
-CHINA VIETNAM 1996 5434772818
-JAPAN VIETNAM 1996 5334277549
-INDIA VIETNAM 1996 5293891531
-CHINA INDONESIA 1997 6653234696
-INDONESIA CHINA 1997 6577396314
-CHINA CHINA 1997 6463794795
-JAPAN INDONESIA 1997 6429270126
-INDONESIA INDONESIA 1997 6398427821
-VIETNAM INDONESIA 1997 6363583120
-CHINA JAPAN 1997 6284733518
-VIETNAM CHINA 1997 6164218723
-INDIA CHINA 1997 6153282214
-CHINA INDIA 1997 6084283983
-INDONESIA JAPAN 1997 6001427956
-INDIA INDONESIA 1997 5983439300
-JAPAN CHINA 1997 5973849687
-CHINA VIETNAM 1997 5908254176
-JAPAN INDIA 1997 5796921992
-JAPAN JAPAN 1997 5790450039
-INDONESIA INDIA 1997 5789367105
-VIETNAM INDIA 1997 5730121608
-INDIA INDIA 1997 5693028907
-VIETNAM JAPAN 1997 5689345230
-INDONESIA VIETNAM 1997 5665678132
-VIETNAM VIETNAM 1997 5620251324
-INDIA JAPAN 1997 5587827913
-JAPAN VIETNAM 1997 5249874614
-INDIA VIETNAM 1997 5003624837
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.2.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.2.out
deleted file mode 100644
index 6fa0c9ba6d..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.2.out
+++ /dev/null
@@ -1,602 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q3.2 --
-UNITED ST4 UNITED ST1 1992 102027455
-UNITED ST1 UNITED ST0 1992 96989491
-UNITED ST7 UNITED ST0 1992 96078010
-UNITED ST9 UNITED ST0 1992 94813294
-UNITED ST4 UNITED ST0 1992 94644242
-UNITED ST2 UNITED ST4 1992 91180500
-UNITED ST5 UNITED ST0 1992 90432300
-UNITED ST6 UNITED ST7 1992 87658267
-UNITED ST3 UNITED ST9 1992 86142048
-UNITED ST6 UNITED ST5 1992 85882966
-UNITED ST7 UNITED ST3 1992 83765666
-UNITED ST2 UNITED ST9 1992 83705618
-UNITED ST4 UNITED ST6 1992 81886374
-UNITED ST2 UNITED ST1 1992 81839165
-UNITED ST9 UNITED ST1 1992 80795302
-UNITED ST6 UNITED ST3 1992 78778218
-UNITED ST6 UNITED ST0 1992 78696956
-UNITED ST0 UNITED ST1 1992 77267396
-UNITED ST0 UNITED ST0 1992 75622122
-UNITED ST1 UNITED ST9 1992 75367059
-UNITED ST3 UNITED ST1 1992 73637490
-UNITED ST2 UNITED ST0 1992 72210218
-UNITED ST1 UNITED ST7 1992 71472973
-UNITED ST6 UNITED ST4 1992 71086944
-UNITED ST4 UNITED ST4 1992 70111335
-UNITED ST6 UNITED ST1 1992 69408688
-UNITED ST4 UNITED ST3 1992 69001787
-UNITED ST5 UNITED ST7 1992 68333651
-UNITED ST4 UNITED ST9 1992 67837970
-UNITED ST7 UNITED ST6 1992 65513205
-UNITED ST4 UNITED ST5 1992 65057872
-UNITED ST7 UNITED ST4 1992 64900888
-UNITED ST1 UNITED ST1 1992 64669070
-UNITED ST3 UNITED ST5 1992 64239048
-UNITED ST0 UNITED ST9 1992 63979996
-UNITED ST3 UNITED ST4 1992 63144772
-UNITED ST5 UNITED ST6 1992 62628093
-UNITED ST4 UNITED ST7 1992 62529376
-UNITED ST3 UNITED ST0 1992 62441656
-UNITED ST9 UNITED ST4 1992 61489513
-UNITED ST8 UNITED ST6 1992 60540440
-UNITED ST7 UNITED ST9 1992 60326042
-UNITED ST7 UNITED ST7 1992 60121386
-UNITED ST5 UNITED ST1 1992 59945287
-UNITED ST5 UNITED ST4 1992 57625627
-UNITED ST7 UNITED ST5 1992 57566802
-UNITED ST2 UNITED ST5 1992 57021365
-UNITED ST9 UNITED ST7 1992 56883359
-UNITED ST0 UNITED ST3 1992 56359317
-UNITED ST1 UNITED ST3 1992 55727474
-UNITED ST5 UNITED ST3 1992 53963553
-UNITED ST0 UNITED ST7 1992 50583409
-UNITED ST5 UNITED ST9 1992 50191091
-UNITED ST7 UNITED ST1 1992 50167208
-UNITED ST0 UNITED ST8 1992 49732640
-UNITED ST0 UNITED ST4 1992 49676807
-UNITED ST9 UNITED ST3 1992 47681165
-UNITED ST8 UNITED ST4 1992 46757019
-UNITED ST3 UNITED ST3 1992 45087216
-UNITED ST8 UNITED ST0 1992 44368839
-UNITED ST0 UNITED ST6 1992 42471806
-UNITED ST6 UNITED ST8 1992 42463690
-UNITED ST8 UNITED ST7 1992 41897901
-UNITED ST3 UNITED ST8 1992 41275764
-UNITED ST6 UNITED ST9 1992 40591721
-UNITED ST0 UNITED ST5 1992 40120886
-UNITED ST1 UNITED ST4 1992 39326346
-UNITED ST3 UNITED ST7 1992 39028579
-UNITED ST3 UNITED ST6 1992 38798715
-UNITED ST9 UNITED ST9 1992 36048343
-UNITED ST2 UNITED ST8 1992 36046449
-UNITED ST2 UNITED ST3 1992 35981963
-UNITED ST8 UNITED ST1 1992 35680752
-UNITED ST1 UNITED ST6 1992 35404990
-UNITED ST8 UNITED ST5 1992 35187610
-UNITED ST1 UNITED ST5 1992 33971251
-UNITED ST5 UNITED ST8 1992 33878053
-UNITED ST2 UNITED ST7 1992 33702779
-UNITED ST8 UNITED ST3 1992 30949324
-UNITED ST8 UNITED ST8 1992 29309108
-UNITED ST5 UNITED ST5 1992 29279568
-UNITED ST1 UNITED ST8 1992 28565579
-UNITED ST9 UNITED ST5 1992 28075004
-UNITED ST2 UNITED ST6 1992 27813739
-UNITED ST0 UNITED ST2 1992 27718733
-UNITED ST2 UNITED ST2 1992 25743654
-UNITED ST8 UNITED ST9 1992 22684471
-UNITED ST4 UNITED ST8 1992 21928442
-UNITED ST9 UNITED ST8 1992 21386100
-UNITED ST5 UNITED ST2 1992 20495817
-UNITED ST6 UNITED ST6 1992 18137105
-UNITED ST9 UNITED ST6 1992 15879568
-UNITED ST4 UNITED ST2 1992 12061845
-UNITED ST7 UNITED ST8 1992 11895702
-UNITED ST6 UNITED ST2 1992 11820698
-UNITED ST9 UNITED ST2 1992 11623177
-UNITED ST8 UNITED ST2 1992 10971561
-UNITED ST1 UNITED ST2 1992 7706728
-UNITED ST7 UNITED ST2 1992 4943204
-UNITED ST3 UNITED ST2 1992 1097208
-UNITED ST0 UNITED ST9 1993 109834040
-UNITED ST7 UNITED ST0 1993 109788024
-UNITED ST5 UNITED ST0 1993 106822597
-UNITED ST0 UNITED ST0 1993 106742548
-UNITED ST1 UNITED ST0 1993 99305952
-UNITED ST4 UNITED ST4 1993 98150465
-UNITED ST3 UNITED ST4 1993 92493920
-UNITED ST0 UNITED ST1 1993 91196593
-UNITED ST4 UNITED ST1 1993 88521423
-UNITED ST8 UNITED ST0 1993 88356371
-UNITED ST4 UNITED ST7 1993 88172198
-UNITED ST4 UNITED ST0 1993 86918458
-UNITED ST6 UNITED ST3 1993 83417161
-UNITED ST6 UNITED ST1 1993 83345939
-UNITED ST7 UNITED ST9 1993 80310701
-UNITED ST3 UNITED ST1 1993 78230278
-UNITED ST6 UNITED ST7 1993 78197294
-UNITED ST5 UNITED ST9 1993 76286539
-UNITED ST0 UNITED ST3 1993 76171283
-UNITED ST5 UNITED ST8 1993 74359279
-UNITED ST9 UNITED ST1 1993 74059419
-UNITED ST4 UNITED ST9 1993 73296959
-UNITED ST5 UNITED ST1 1993 71454623
-UNITED ST6 UNITED ST4 1993 69646913
-UNITED ST2 UNITED ST1 1993 69631701
-UNITED ST6 UNITED ST0 1993 68247539
-UNITED ST7 UNITED ST7 1993 68109820
-UNITED ST2 UNITED ST3 1993 66972438
-UNITED ST3 UNITED ST0 1993 66626926
-UNITED ST9 UNITED ST7 1993 66625483
-UNITED ST1 UNITED ST8 1993 66146198
-UNITED ST2 UNITED ST7 1993 64185014
-UNITED ST5 UNITED ST4 1993 63415639
-UNITED ST9 UNITED ST9 1993 63260763
-UNITED ST1 UNITED ST4 1993 62884347
-UNITED ST7 UNITED ST4 1993 61656613
-UNITED ST3 UNITED ST6 1993 58584808
-UNITED ST2 UNITED ST4 1993 56650391
-UNITED ST3 UNITED ST5 1993 55907305
-UNITED ST6 UNITED ST9 1993 54900942
-UNITED ST1 UNITED ST7 1993 54851183
-UNITED ST3 UNITED ST9 1993 54762596
-UNITED ST8 UNITED ST6 1993 54633062
-UNITED ST8 UNITED ST3 1993 54049874
-UNITED ST5 UNITED ST7 1993 52745538
-UNITED ST0 UNITED ST5 1993 52701052
-UNITED ST1 UNITED ST9 1993 52514902
-UNITED ST8 UNITED ST5 1993 52237837
-UNITED ST1 UNITED ST3 1993 52097946
-UNITED ST8 UNITED ST4 1993 51419356
-UNITED ST0 UNITED ST6 1993 50432282
-UNITED ST5 UNITED ST5 1993 50357189
-UNITED ST3 UNITED ST7 1993 50135448
-UNITED ST0 UNITED ST4 1993 49260067
-UNITED ST0 UNITED ST7 1993 48796360
-UNITED ST2 UNITED ST9 1993 48188507
-UNITED ST1 UNITED ST1 1993 47538610
-UNITED ST9 UNITED ST3 1993 46943647
-UNITED ST7 UNITED ST5 1993 44763692
-UNITED ST1 UNITED ST6 1993 44728540
-UNITED ST8 UNITED ST1 1993 44415434
-UNITED ST7 UNITED ST8 1993 43902628
-UNITED ST9 UNITED ST6 1993 43867160
-UNITED ST2 UNITED ST0 1993 42845485
-UNITED ST3 UNITED ST8 1993 42251848
-UNITED ST0 UNITED ST8 1993 42002682
-UNITED ST4 UNITED ST8 1993 41657582
-UNITED ST1 UNITED ST5 1993 40693513
-UNITED ST9 UNITED ST5 1993 39685269
-UNITED ST7 UNITED ST3 1993 39523861
-UNITED ST8 UNITED ST8 1993 38790235
-UNITED ST8 UNITED ST9 1993 38516361
-UNITED ST2 UNITED ST5 1993 37406845
-UNITED ST9 UNITED ST8 1993 37184696
-UNITED ST8 UNITED ST7 1993 36902218
-UNITED ST6 UNITED ST8 1993 36456741
-UNITED ST7 UNITED ST1 1993 34391159
-UNITED ST6 UNITED ST5 1993 34229082
-UNITED ST5 UNITED ST3 1993 34031811
-UNITED ST2 UNITED ST8 1993 33445446
-UNITED ST4 UNITED ST3 1993 33129412
-UNITED ST6 UNITED ST6 1993 33050663
-UNITED ST9 UNITED ST0 1993 32653305
-UNITED ST4 UNITED ST6 1993 30699255
-UNITED ST9 UNITED ST4 1993 30644687
-UNITED ST4 UNITED ST5 1993 29119594
-UNITED ST7 UNITED ST6 1993 27100502
-UNITED ST4 UNITED ST2 1993 27012678
-UNITED ST2 UNITED ST6 1993 26482226
-UNITED ST5 UNITED ST6 1993 25357679
-UNITED ST3 UNITED ST3 1993 21777144
-UNITED ST3 UNITED ST2 1993 21559073
-UNITED ST5 UNITED ST2 1993 20610242
-UNITED ST7 UNITED ST2 1993 20219304
-UNITED ST6 UNITED ST2 1993 18814367
-UNITED ST9 UNITED ST2 1993 17718390
-UNITED ST1 UNITED ST2 1993 16844538
-UNITED ST0 UNITED ST2 1993 15042145
-UNITED ST2 UNITED ST2 1993 14521995
-UNITED ST8 UNITED ST2 1993 9984366
-UNITED ST8 UNITED ST0 1994 99220789
-UNITED ST3 UNITED ST9 1994 97476185
-UNITED ST6 UNITED ST1 1994 96937147
-UNITED ST6 UNITED ST9 1994 94683309
-UNITED ST9 UNITED ST1 1994 90440948
-UNITED ST0 UNITED ST9 1994 89865202
-UNITED ST5 UNITED ST7 1994 89089961
-UNITED ST9 UNITED ST0 1994 87670573
-UNITED ST3 UNITED ST1 1994 85523653
-UNITED ST4 UNITED ST9 1994 83822393
-UNITED ST0 UNITED ST0 1994 83526877
-UNITED ST7 UNITED ST0 1994 82265536
-UNITED ST2 UNITED ST1 1994 81300089
-UNITED ST5 UNITED ST0 1994 78648057
-UNITED ST4 UNITED ST7 1994 76954140
-UNITED ST4 UNITED ST4 1994 76837381
-UNITED ST0 UNITED ST1 1994 76613379
-UNITED ST1 UNITED ST3 1994 75992459
-UNITED ST7 UNITED ST1 1994 75320799
-UNITED ST4 UNITED ST0 1994 73719340
-UNITED ST5 UNITED ST1 1994 73508418
-UNITED ST4 UNITED ST1 1994 72219557
-UNITED ST2 UNITED ST9 1994 69671054
-UNITED ST6 UNITED ST5 1994 66461534
-UNITED ST2 UNITED ST3 1994 65620760
-UNITED ST3 UNITED ST0 1994 65522727
-UNITED ST5 UNITED ST3 1994 65334911
-UNITED ST7 UNITED ST4 1994 64778715
-UNITED ST3 UNITED ST4 1994 63412365
-UNITED ST8 UNITED ST4 1994 62141681
-UNITED ST0 UNITED ST4 1994 61519744
-UNITED ST0 UNITED ST7 1994 61480820
-UNITED ST0 UNITED ST6 1994 61288778
-UNITED ST2 UNITED ST0 1994 60182153
-UNITED ST6 UNITED ST4 1994 59829989
-UNITED ST4 UNITED ST5 1994 59397028
-UNITED ST8 UNITED ST9 1994 58666906
-UNITED ST4 UNITED ST6 1994 58633482
-UNITED ST5 UNITED ST5 1994 56235213
-UNITED ST6 UNITED ST3 1994 56123238
-UNITED ST2 UNITED ST4 1994 55679377
-UNITED ST8 UNITED ST3 1994 55203841
-UNITED ST1 UNITED ST1 1994 54383174
-UNITED ST1 UNITED ST7 1994 53853106
-UNITED ST6 UNITED ST0 1994 53728853
-UNITED ST5 UNITED ST9 1994 53367331
-UNITED ST9 UNITED ST9 1994 51980849
-UNITED ST5 UNITED ST4 1994 51799593
-UNITED ST7 UNITED ST9 1994 50144085
-UNITED ST7 UNITED ST7 1994 46446442
-UNITED ST6 UNITED ST6 1994 46199722
-UNITED ST7 UNITED ST5 1994 45895364
-UNITED ST3 UNITED ST3 1994 45627153
-UNITED ST8 UNITED ST5 1994 44553056
-UNITED ST9 UNITED ST4 1994 43910761
-UNITED ST1 UNITED ST0 1994 43225201
-UNITED ST1 UNITED ST9 1994 43000037
-UNITED ST7 UNITED ST8 1994 42776467
-UNITED ST0 UNITED ST5 1994 41808301
-UNITED ST2 UNITED ST6 1994 41526105
-UNITED ST1 UNITED ST4 1994 41381558
-UNITED ST3 UNITED ST7 1994 40935131
-UNITED ST8 UNITED ST1 1994 40152096
-UNITED ST9 UNITED ST8 1994 39278808
-UNITED ST5 UNITED ST6 1994 38658451
-UNITED ST2 UNITED ST5 1994 37640317
-UNITED ST8 UNITED ST7 1994 37600687
-UNITED ST9 UNITED ST5 1994 37146726
-UNITED ST6 UNITED ST7 1994 37057808
-UNITED ST8 UNITED ST6 1994 36776569
-UNITED ST3 UNITED ST6 1994 36290257
-UNITED ST9 UNITED ST3 1994 35846500
-UNITED ST2 UNITED ST8 1994 33767774
-UNITED ST0 UNITED ST8 1994 31845433
-UNITED ST4 UNITED ST3 1994 31599433
-UNITED ST9 UNITED ST7 1994 31586173
-UNITED ST1 UNITED ST6 1994 31287326
-UNITED ST1 UNITED ST8 1994 30245153
-UNITED ST7 UNITED ST3 1994 29424840
-UNITED ST9 UNITED ST6 1994 29212927
-UNITED ST0 UNITED ST3 1994 27327829
-UNITED ST6 UNITED ST8 1994 26592996
-UNITED ST3 UNITED ST5 1994 26197875
-UNITED ST6 UNITED ST2 1994 25809000
-UNITED ST1 UNITED ST5 1994 24939138
-UNITED ST7 UNITED ST6 1994 24631937
-UNITED ST1 UNITED ST2 1994 23556586
-UNITED ST4 UNITED ST2 1994 23035892
-UNITED ST2 UNITED ST7 1994 22182758
-UNITED ST0 UNITED ST2 1994 22017954
-UNITED ST4 UNITED ST8 1994 20685352
-UNITED ST7 UNITED ST2 1994 19655081
-UNITED ST5 UNITED ST8 1994 18931891
-UNITED ST2 UNITED ST2 1994 18068657
-UNITED ST3 UNITED ST8 1994 15936051
-UNITED ST8 UNITED ST8 1994 10023412
-UNITED ST3 UNITED ST2 1994 9995234
-UNITED ST9 UNITED ST2 1994 9700989
-UNITED ST5 UNITED ST2 1994 7162796
-UNITED ST8 UNITED ST2 1994 3789626
-UNITED ST5 UNITED ST1 1995 119793669
-UNITED ST4 UNITED ST9 1995 99490068
-UNITED ST7 UNITED ST0 1995 98031295
-UNITED ST6 UNITED ST0 1995 91718471
-UNITED ST4 UNITED ST1 1995 90878653
-UNITED ST0 UNITED ST1 1995 90763599
-UNITED ST8 UNITED ST9 1995 88855089
-UNITED ST7 UNITED ST7 1995 86571624
-UNITED ST3 UNITED ST0 1995 84462733
-UNITED ST9 UNITED ST1 1995 82938967
-UNITED ST2 UNITED ST4 1995 82432305
-UNITED ST1 UNITED ST0 1995 81676623
-UNITED ST5 UNITED ST4 1995 81016761
-UNITED ST7 UNITED ST1 1995 79964362
-UNITED ST5 UNITED ST3 1995 78099130
-UNITED ST5 UNITED ST0 1995 77615746
-UNITED ST9 UNITED ST9 1995 76515958
-UNITED ST7 UNITED ST9 1995 75317709
-UNITED ST4 UNITED ST4 1995 74587071
-UNITED ST9 UNITED ST4 1995 72525686
-UNITED ST1 UNITED ST9 1995 72470870
-UNITED ST4 UNITED ST7 1995 69264407
-UNITED ST6 UNITED ST3 1995 67513062
-UNITED ST2 UNITED ST3 1995 65218129
-UNITED ST2 UNITED ST9 1995 65055178
-UNITED ST7 UNITED ST6 1995 65020671
-UNITED ST3 UNITED ST1 1995 64762815
-UNITED ST1 UNITED ST1 1995 64199332
-UNITED ST6 UNITED ST9 1995 63457105
-UNITED ST0 UNITED ST9 1995 63253499
-UNITED ST5 UNITED ST9 1995 62364897
-UNITED ST4 UNITED ST5 1995 62081505
-UNITED ST1 UNITED ST7 1995 61515741
-UNITED ST2 UNITED ST7 1995 60000208
-UNITED ST8 UNITED ST6 1995 58990404
-UNITED ST1 UNITED ST4 1995 57535599
-UNITED ST0 UNITED ST3 1995 56360708
-UNITED ST8 UNITED ST0 1995 55231664
-UNITED ST5 UNITED ST7 1995 53740759
-UNITED ST2 UNITED ST0 1995 52560838
-UNITED ST3 UNITED ST7 1995 51579548
-UNITED ST9 UNITED ST0 1995 51548621
-UNITED ST6 UNITED ST6 1995 50954677
-UNITED ST5 UNITED ST5 1995 50394007
-UNITED ST7 UNITED ST4 1995 49899545
-UNITED ST3 UNITED ST3 1995 48158089
-UNITED ST6 UNITED ST4 1995 47697241
-UNITED ST9 UNITED ST7 1995 46464589
-UNITED ST4 UNITED ST0 1995 46142899
-UNITED ST1 UNITED ST3 1995 45823056
-UNITED ST2 UNITED ST1 1995 45437340
-UNITED ST6 UNITED ST5 1995 45428152
-UNITED ST8 UNITED ST5 1995 44994863
-UNITED ST7 UNITED ST3 1995 43699734
-UNITED ST9 UNITED ST6 1995 43482494
-UNITED ST2 UNITED ST5 1995 43382417
-UNITED ST6 UNITED ST8 1995 41973920
-UNITED ST0 UNITED ST6 1995 40718942
-UNITED ST3 UNITED ST5 1995 40057815
-UNITED ST7 UNITED ST5 1995 39015293
-UNITED ST0 UNITED ST0 1995 38984502
-UNITED ST6 UNITED ST1 1995 38328352
-UNITED ST4 UNITED ST6 1995 38109524
-UNITED ST3 UNITED ST9 1995 37364623
-UNITED ST4 UNITED ST3 1995 37356396
-UNITED ST2 UNITED ST6 1995 37146288
-UNITED ST9 UNITED ST5 1995 36009924
-UNITED ST1 UNITED ST8 1995 34918793
-UNITED ST8 UNITED ST1 1995 34217780
-UNITED ST0 UNITED ST7 1995 33395313
-UNITED ST1 UNITED ST5 1995 31857452
-UNITED ST8 UNITED ST7 1995 30918202
-UNITED ST2 UNITED ST8 1995 30504189
-UNITED ST3 UNITED ST4 1995 30422346
-UNITED ST5 UNITED ST6 1995 30204737
-UNITED ST8 UNITED ST3 1995 29349938
-UNITED ST0 UNITED ST4 1995 29170038
-UNITED ST1 UNITED ST6 1995 27139403
-UNITED ST7 UNITED ST8 1995 26444490
-UNITED ST6 UNITED ST7 1995 23833977
-UNITED ST4 UNITED ST8 1995 23053236
-UNITED ST4 UNITED ST2 1995 22787003
-UNITED ST3 UNITED ST8 1995 22505239
-UNITED ST9 UNITED ST8 1995 21292527
-UNITED ST8 UNITED ST4 1995 19287311
-UNITED ST8 UNITED ST2 1995 18282990
-UNITED ST9 UNITED ST3 1995 17539102
-UNITED ST3 UNITED ST6 1995 16738530
-UNITED ST0 UNITED ST8 1995 16393249
-UNITED ST5 UNITED ST2 1995 14951023
-UNITED ST2 UNITED ST2 1995 13455031
-UNITED ST5 UNITED ST8 1995 13346932
-UNITED ST3 UNITED ST2 1995 12886829
-UNITED ST9 UNITED ST2 1995 12653362
-UNITED ST0 UNITED ST5 1995 11453709
-UNITED ST6 UNITED ST2 1995 11363551
-UNITED ST8 UNITED ST8 1995 11285867
-UNITED ST1 UNITED ST2 1995 7991676
-UNITED ST0 UNITED ST2 1995 4776460
-UNITED ST7 UNITED ST2 1995 3973565
-UNITED ST6 UNITED ST0 1996 132286763
-UNITED ST4 UNITED ST0 1996 106897563
-UNITED ST5 UNITED ST0 1996 104501979
-UNITED ST0 UNITED ST4 1996 103228749
-UNITED ST9 UNITED ST1 1996 101983827
-UNITED ST1 UNITED ST0 1996 94861554
-UNITED ST0 UNITED ST1 1996 91948777
-UNITED ST6 UNITED ST1 1996 89705870
-UNITED ST2 UNITED ST1 1996 88256155
-UNITED ST1 UNITED ST1 1996 87265848
-UNITED ST4 UNITED ST7 1996 83677814
-UNITED ST6 UNITED ST3 1996 82168229
-UNITED ST2 UNITED ST7 1996 80468477
-UNITED ST8 UNITED ST1 1996 78971756
-UNITED ST7 UNITED ST4 1996 77941011
-UNITED ST1 UNITED ST3 1996 77610905
-UNITED ST9 UNITED ST9 1996 77301740
-UNITED ST0 UNITED ST9 1996 75935209
-UNITED ST7 UNITED ST0 1996 75602445
-UNITED ST3 UNITED ST1 1996 74746699
-UNITED ST7 UNITED ST7 1996 74040644
-UNITED ST4 UNITED ST1 1996 72819867
-UNITED ST5 UNITED ST9 1996 72614114
-UNITED ST1 UNITED ST9 1996 69823769
-UNITED ST9 UNITED ST4 1996 69616614
-UNITED ST6 UNITED ST4 1996 69296005
-UNITED ST2 UNITED ST0 1996 67095122
-UNITED ST5 UNITED ST1 1996 65346389
-UNITED ST6 UNITED ST9 1996 63256182
-UNITED ST4 UNITED ST6 1996 62189328
-UNITED ST0 UNITED ST0 1996 61528855
-UNITED ST8 UNITED ST9 1996 60466691
-UNITED ST3 UNITED ST0 1996 60226840
-UNITED ST8 UNITED ST6 1996 59746655
-UNITED ST2 UNITED ST3 1996 59648598
-UNITED ST0 UNITED ST5 1996 57762895
-UNITED ST8 UNITED ST7 1996 57523925
-UNITED ST2 UNITED ST4 1996 57487057
-UNITED ST6 UNITED ST7 1996 57090619
-UNITED ST3 UNITED ST4 1996 54838259
-UNITED ST4 UNITED ST9 1996 54134840
-UNITED ST1 UNITED ST6 1996 54056366
-UNITED ST3 UNITED ST7 1996 53987218
-UNITED ST2 UNITED ST9 1996 53491415
-UNITED ST4 UNITED ST8 1996 53035662
-UNITED ST9 UNITED ST5 1996 52825922
-UNITED ST7 UNITED ST3 1996 52356886
-UNITED ST6 UNITED ST8 1996 52136784
-UNITED ST1 UNITED ST5 1996 51189649
-UNITED ST8 UNITED ST4 1996 51033054
-UNITED ST1 UNITED ST4 1996 50135547
-UNITED ST3 UNITED ST9 1996 49612304
-UNITED ST9 UNITED ST0 1996 49590701
-UNITED ST3 UNITED ST3 1996 49263796
-UNITED ST9 UNITED ST7 1996 48798759
-UNITED ST7 UNITED ST1 1996 48784175
-UNITED ST9 UNITED ST6 1996 48685063
-UNITED ST2 UNITED ST5 1996 47028976
-UNITED ST9 UNITED ST3 1996 47021018
-UNITED ST2 UNITED ST8 1996 46865113
-UNITED ST4 UNITED ST3 1996 46460940
-UNITED ST6 UNITED ST5 1996 46030104
-UNITED ST2 UNITED ST6 1996 45416649
-UNITED ST8 UNITED ST5 1996 43480473
-UNITED ST5 UNITED ST5 1996 43020722
-UNITED ST6 UNITED ST6 1996 42923032
-UNITED ST4 UNITED ST5 1996 42808412
-UNITED ST3 UNITED ST6 1996 41881628
-UNITED ST1 UNITED ST7 1996 41721506
-UNITED ST5 UNITED ST7 1996 40946330
-UNITED ST8 UNITED ST0 1996 39845427
-UNITED ST8 UNITED ST3 1996 39535940
-UNITED ST1 UNITED ST8 1996 39430882
-UNITED ST5 UNITED ST6 1996 38332044
-UNITED ST0 UNITED ST6 1996 37232062
-UNITED ST7 UNITED ST6 1996 36535628
-UNITED ST9 UNITED ST8 1996 36112301
-UNITED ST3 UNITED ST8 1996 33924732
-UNITED ST3 UNITED ST5 1996 33717439
-UNITED ST5 UNITED ST4 1996 33424859
-UNITED ST5 UNITED ST3 1996 32919926
-UNITED ST4 UNITED ST4 1996 32787995
-UNITED ST7 UNITED ST5 1996 32784224
-UNITED ST5 UNITED ST8 1996 32415682
-UNITED ST0 UNITED ST7 1996 31391181
-UNITED ST0 UNITED ST3 1996 29795665
-UNITED ST7 UNITED ST9 1996 25028091
-UNITED ST7 UNITED ST8 1996 24348851
-UNITED ST6 UNITED ST2 1996 20447847
-UNITED ST8 UNITED ST8 1996 16340603
-UNITED ST0 UNITED ST8 1996 15168262
-UNITED ST4 UNITED ST2 1996 12451867
-UNITED ST1 UNITED ST2 1996 10082536
-UNITED ST5 UNITED ST2 1996 8544233
-UNITED ST7 UNITED ST2 1996 8390470
-UNITED ST9 UNITED ST2 1996 8108035
-UNITED ST8 UNITED ST2 1996 7028334
-UNITED ST0 UNITED ST2 1996 6907199
-UNITED ST3 UNITED ST2 1996 4311800
-UNITED ST5 UNITED ST0 1997 121457766
-UNITED ST0 UNITED ST9 1997 119856268
-UNITED ST5 UNITED ST1 1997 106900161
-UNITED ST9 UNITED ST9 1997 106222795
-UNITED ST5 UNITED ST4 1997 103432927
-UNITED ST7 UNITED ST1 1997 101326940
-UNITED ST5 UNITED ST9 1997 97392640
-UNITED ST8 UNITED ST0 1997 89434845
-UNITED ST1 UNITED ST3 1997 85175638
-UNITED ST4 UNITED ST1 1997 84611188
-UNITED ST4 UNITED ST7 1997 84606996
-UNITED ST1 UNITED ST4 1997 83092569
-UNITED ST0 UNITED ST1 1997 80167139
-UNITED ST4 UNITED ST9 1997 79697927
-UNITED ST1 UNITED ST0 1997 77667866
-UNITED ST2 UNITED ST0 1997 77591470
-UNITED ST1 UNITED ST7 1997 77045722
-UNITED ST2 UNITED ST7 1997 76483802
-UNITED ST1 UNITED ST1 1997 76340444
-UNITED ST0 UNITED ST7 1997 72577490
-UNITED ST4 UNITED ST0 1997 69875804
-UNITED ST6 UNITED ST3 1997 69725506
-UNITED ST2 UNITED ST9 1997 69543984
-UNITED ST7 UNITED ST0 1997 69354312
-UNITED ST9 UNITED ST7 1997 69052630
-UNITED ST8 UNITED ST3 1997 66918394
-UNITED ST0 UNITED ST0 1997 66308516
-UNITED ST9 UNITED ST0 1997 66066791
-UNITED ST2 UNITED ST3 1997 65429453
-UNITED ST2 UNITED ST1 1997 65396135
-UNITED ST4 UNITED ST4 1997 62532346
-UNITED ST9 UNITED ST1 1997 62418406
-UNITED ST3 UNITED ST7 1997 61095300
-UNITED ST7 UNITED ST4 1997 60123494
-UNITED ST4 UNITED ST3 1997 59634153
-UNITED ST3 UNITED ST4 1997 58356141
-UNITED ST6 UNITED ST9 1997 58231263
-UNITED ST6 UNITED ST4 1997 57215022
-UNITED ST2 UNITED ST4 1997 57012611
-UNITED ST5 UNITED ST3 1997 56789932
-UNITED ST9 UNITED ST5 1997 56091920
-UNITED ST6 UNITED ST0 1997 55824919
-UNITED ST6 UNITED ST1 1997 55117709
-UNITED ST7 UNITED ST9 1997 55039970
-UNITED ST5 UNITED ST7 1997 54534315
-UNITED ST3 UNITED ST1 1997 54150683
-UNITED ST3 UNITED ST0 1997 54050172
-UNITED ST3 UNITED ST9 1997 51370308
-UNITED ST1 UNITED ST5 1997 51052110
-UNITED ST6 UNITED ST7 1997 49795849
-UNITED ST5 UNITED ST6 1997 49030016
-UNITED ST1 UNITED ST9 1997 48944111
-UNITED ST3 UNITED ST3 1997 48385233
-UNITED ST0 UNITED ST5 1997 47988418
-UNITED ST2 UNITED ST8 1997 46391909
-UNITED ST4 UNITED ST6 1997 46236849
-UNITED ST9 UNITED ST3 1997 46121724
-UNITED ST8 UNITED ST9 1997 45852796
-UNITED ST7 UNITED ST8 1997 45476266
-UNITED ST8 UNITED ST1 1997 43284139
-UNITED ST7 UNITED ST7 1997 42566603
-UNITED ST0 UNITED ST4 1997 41193803
-UNITED ST8 UNITED ST7 1997 40878429
-UNITED ST8 UNITED ST8 1997 40749400
-UNITED ST2 UNITED ST5 1997 40662886
-UNITED ST0 UNITED ST3 1997 40078508
-UNITED ST6 UNITED ST8 1997 37988445
-UNITED ST9 UNITED ST6 1997 37596882
-UNITED ST6 UNITED ST5 1997 37571788
-UNITED ST2 UNITED ST2 1997 37034333
-UNITED ST7 UNITED ST5 1997 36889736
-UNITED ST8 UNITED ST4 1997 36600584
-UNITED ST3 UNITED ST6 1997 36075844
-UNITED ST7 UNITED ST3 1997 35168922
-UNITED ST2 UNITED ST6 1997 34274467
-UNITED ST5 UNITED ST8 1997 32910946
-UNITED ST3 UNITED ST5 1997 32811963
-UNITED ST4 UNITED ST8 1997 32599736
-UNITED ST5 UNITED ST5 1997 32568888
-UNITED ST4 UNITED ST5 1997 31995868
-UNITED ST9 UNITED ST4 1997 31765478
-UNITED ST7 UNITED ST2 1997 31409590
-UNITED ST9 UNITED ST8 1997 31272385
-UNITED ST0 UNITED ST8 1997 30241370
-UNITED ST3 UNITED ST8 1997 29102220
-UNITED ST7 UNITED ST6 1997 27539931
-UNITED ST8 UNITED ST5 1997 26673743
-UNITED ST6 UNITED ST6 1997 24983291
-UNITED ST0 UNITED ST2 1997 23584229
-UNITED ST0 UNITED ST6 1997 22924046
-UNITED ST1 UNITED ST2 1997 20599130
-UNITED ST8 UNITED ST6 1997 20073000
-UNITED ST1 UNITED ST6 1997 18205326
-UNITED ST1 UNITED ST8 1997 15375258
-UNITED ST6 UNITED ST2 1997 14746680
-UNITED ST5 UNITED ST2 1997 13863438
-UNITED ST8 UNITED ST2 1997 12053706
-UNITED ST3 UNITED ST2 1997 7891878
-UNITED ST4 UNITED ST2 1997 2848157
-UNITED ST9 UNITED ST2 1997 2661652
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.3.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.3.out
deleted file mode 100644
index 96695e04c8..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.3.out
+++ /dev/null
@@ -1,27 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q3.3 --
-UNITED KI1 UNITED KI1 1992 46735995
-UNITED KI5 UNITED KI1 1992 36277055
-UNITED KI5 UNITED KI5 1992 25355267
-UNITED KI1 UNITED KI5 1992 21917846
-UNITED KI5 UNITED KI1 1993 61017607
-UNITED KI1 UNITED KI1 1993 45669535
-UNITED KI5 UNITED KI5 1993 34099392
-UNITED KI1 UNITED KI5 1993 21444206
-UNITED KI5 UNITED KI1 1994 36282163
-UNITED KI1 UNITED KI1 1994 34868441
-UNITED KI5 UNITED KI5 1994 34507284
-UNITED KI1 UNITED KI5 1994 21221780
-UNITED KI5 UNITED KI1 1995 82955896
-UNITED KI1 UNITED KI1 1995 35881186
-UNITED KI5 UNITED KI5 1995 20539805
-UNITED KI1 UNITED KI5 1995 17176510
-UNITED KI5 UNITED KI1 1996 65767049
-UNITED KI1 UNITED KI1 1996 59923037
-UNITED KI5 UNITED KI5 1996 46077342
-UNITED KI1 UNITED KI5 1996 13700254
-UNITED KI1 UNITED KI1 1997 70343133
-UNITED KI5 UNITED KI1 1997 64978359
-UNITED KI5 UNITED KI5 1997 27332027
-UNITED KI1 UNITED KI5 1997 16410668
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.4.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.4.out
deleted file mode 100644
index 136aefa350..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q3.4.out
+++ /dev/null
@@ -1,6 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q3.4 --
-UNITED KI5 UNITED KI1 1997 9117846
-UNITED KI5 UNITED KI5 1997 6203801
-UNITED KI1 UNITED KI5 1997 1870070
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q4.1.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q4.1.out
deleted file mode 100644
index 485ce1aa92..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q4.1.out
+++ /dev/null
@@ -1,38 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q4.1 --
-1992 ARGENTINA 9658964469
-1992 BRAZIL 9226983055
-1992 CANADA 9643176787
-1992 PERU 9410676597
-1992 UNITED STATES 9849427653
-1993 ARGENTINA 9976332853
-1993 BRAZIL 9468799229
-1993 CANADA 9897302420
-1993 PERU 9309445836
-1993 UNITED STATES 10003985086
-1994 ARGENTINA 9940305215
-1994 BRAZIL 9348651677
-1994 CANADA 9582647596
-1994 PERU 9295265013
-1994 UNITED STATES 9519880425
-1995 ARGENTINA 10143841380
-1995 BRAZIL 9156077350
-1995 CANADA 9562612160
-1995 PERU 9778087211
-1995 UNITED STATES 9310565244
-1996 ARGENTINA 10001927895
-1996 BRAZIL 9168485151
-1996 CANADA 10061604203
-1996 PERU 9355135674
-1996 UNITED STATES 9769712174
-1997 ARGENTINA 9854560261
-1997 BRAZIL 9121571047
-1997 CANADA 10097371778
-1997 PERU 9315525917
-1997 UNITED STATES 10506723879
-1998 ARGENTINA 5834240407
-1998 BRAZIL 5356398095
-1998 CANADA 5423211196
-1998 PERU 5726185970
-1998 UNITED STATES 6009462019
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q4.2.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q4.2.out
deleted file mode 100644
index 600a018fb4..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q4.2.out
+++ /dev/null
@@ -1,103 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q4.2 --
-1997 ARGENTINA MFGR#11 907071566
-1997 ARGENTINA MFGR#12 924115562
-1997 ARGENTINA MFGR#13 972861821
-1997 ARGENTINA MFGR#14 975410345
-1997 ARGENTINA MFGR#15 938867375
-1997 ARGENTINA MFGR#21 1014782574
-1997 ARGENTINA MFGR#22 873016783
-1997 ARGENTINA MFGR#23 1030357302
-1997 ARGENTINA MFGR#24 893460579
-1997 ARGENTINA MFGR#25 1006311403
-1997 BRAZIL MFGR#11 1073219328
-1997 BRAZIL MFGR#12 989858833
-1997 BRAZIL MFGR#13 1128480379
-1997 BRAZIL MFGR#14 1194256722
-1997 BRAZIL MFGR#15 1094419124
-1997 BRAZIL MFGR#21 910026832
-1997 BRAZIL MFGR#22 993142048
-1997 BRAZIL MFGR#23 1107672874
-1997 BRAZIL MFGR#24 1058013649
-1997 BRAZIL MFGR#25 994733764
-1997 CANADA MFGR#11 854725020
-1997 CANADA MFGR#12 938718164
-1997 CANADA MFGR#13 959265890
-1997 CANADA MFGR#14 1002812450
-1997 CANADA MFGR#15 848183013
-1997 CANADA MFGR#21 999805272
-1997 CANADA MFGR#22 778419763
-1997 CANADA MFGR#23 928359645
-1997 CANADA MFGR#24 849895128
-1997 CANADA MFGR#25 904587965
-1997 PERU MFGR#11 1100242877
-1997 PERU MFGR#12 994365350
-1997 PERU MFGR#13 847486105
-1997 PERU MFGR#14 947769683
-1997 PERU MFGR#15 999395678
-1997 PERU MFGR#21 867923394
-1997 PERU MFGR#22 988747459
-1997 PERU MFGR#23 1066645086
-1997 PERU MFGR#24 935665725
-1997 PERU MFGR#25 981454129
-1997 UNITED STATES MFGR#11 1046706048
-1997 UNITED STATES MFGR#12 909213709
-1997 UNITED STATES MFGR#13 1096278906
-1997 UNITED STATES MFGR#14 934282111
-1997 UNITED STATES MFGR#15 962760843
-1997 UNITED STATES MFGR#21 1000676474
-1997 UNITED STATES MFGR#22 1076947615
-1997 UNITED STATES MFGR#23 937288102
-1997 UNITED STATES MFGR#24 1003386363
-1997 UNITED STATES MFGR#25 1053666052
-1998 ARGENTINA MFGR#11 567612227
-1998 ARGENTINA MFGR#12 527025042
-1998 ARGENTINA MFGR#13 582791792
-1998 ARGENTINA MFGR#14 523726368
-1998 ARGENTINA MFGR#15 522078267
-1998 ARGENTINA MFGR#21 504712685
-1998 ARGENTINA MFGR#22 506061736
-1998 ARGENTINA MFGR#23 560479801
-1998 ARGENTINA MFGR#24 524579118
-1998 ARGENTINA MFGR#25 547840211
-1998 BRAZIL MFGR#11 638578488
-1998 BRAZIL MFGR#12 646312681
-1998 BRAZIL MFGR#13 655161772
-1998 BRAZIL MFGR#14 552676170
-1998 BRAZIL MFGR#15 663812709
-1998 BRAZIL MFGR#21 668822448
-1998 BRAZIL MFGR#22 591791918
-1998 BRAZIL MFGR#23 690648877
-1998 BRAZIL MFGR#24 562362220
-1998 BRAZIL MFGR#25 704182376
-1998 CANADA MFGR#11 509086125
-1998 CANADA MFGR#12 488089772
-1998 CANADA MFGR#13 486533297
-1998 CANADA MFGR#14 527837227
-1998 CANADA MFGR#15 535869299
-1998 CANADA MFGR#21 455868651
-1998 CANADA MFGR#22 594277308
-1998 CANADA MFGR#23 574125070
-1998 CANADA MFGR#24 508530424
-1998 CANADA MFGR#25 547757992
-1998 PERU MFGR#11 567838547
-1998 PERU MFGR#12 540544757
-1998 PERU MFGR#13 591331883
-1998 PERU MFGR#14 481335064
-1998 PERU MFGR#15 570246138
-1998 PERU MFGR#21 533733330
-1998 PERU MFGR#22 527790656
-1998 PERU MFGR#23 636393221
-1998 PERU MFGR#24 589075262
-1998 PERU MFGR#25 543251115
-1998 UNITED STATES MFGR#11 556276232
-1998 UNITED STATES MFGR#12 612385982
-1998 UNITED STATES MFGR#13 622413927
-1998 UNITED STATES MFGR#14 555006887
-1998 UNITED STATES MFGR#15 525119569
-1998 UNITED STATES MFGR#21 563406836
-1998 UNITED STATES MFGR#22 580478735
-1998 UNITED STATES MFGR#23 656080465
-1998 UNITED STATES MFGR#24 538445058
-1998 UNITED STATES MFGR#25 589111952
-
diff --git a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q4.3.out
b/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q4.3.out
deleted file mode 100644
index 09c8399d00..0000000000
--- a/regression-test/data/ssb_sf1_unique_sql_zstd/sql/q4.3.out
+++ /dev/null
@@ -1,697 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !q4.3 --
-1997 UNITED ST0 MFGR#141 15456288
-1997 UNITED ST0 MFGR#1410 32961113
-1997 UNITED ST0 MFGR#1411 36166400
-1997 UNITED ST0 MFGR#1412 18237451
-1997 UNITED ST0 MFGR#1413 40752813
-1997 UNITED ST0 MFGR#1414 24237588
-1997 UNITED ST0 MFGR#1415 6419001
-1997 UNITED ST0 MFGR#1416 15639876
-1997 UNITED ST0 MFGR#1417 15476211
-1997 UNITED ST0 MFGR#1418 8169956
-1997 UNITED ST0 MFGR#1419 18217252
-1997 UNITED ST0 MFGR#142 29361222
-1997 UNITED ST0 MFGR#1420 34587603
-1997 UNITED ST0 MFGR#1421 28560921
-1997 UNITED ST0 MFGR#1422 25154181
-1997 UNITED ST0 MFGR#1423 18144008
-1997 UNITED ST0 MFGR#1424 28064267
-1997 UNITED ST0 MFGR#1425 15255845
-1997 UNITED ST0 MFGR#1426 5610353
-1997 UNITED ST0 MFGR#1427 5750693
-1997 UNITED ST0 MFGR#1428 14081707
-1997 UNITED ST0 MFGR#1429 9024512
-1997 UNITED ST0 MFGR#143 5325193
-1997 UNITED ST0 MFGR#1430 16961739
-1997 UNITED ST0 MFGR#1431 19015253
-1997 UNITED ST0 MFGR#1432 6324917
-1997 UNITED ST0 MFGR#1433 6734461
-1997 UNITED ST0 MFGR#1434 19206393
-1997 UNITED ST0 MFGR#1435 679925
-1997 UNITED ST0 MFGR#1436 13834012
-1997 UNITED ST0 MFGR#1437 23575407
-1997 UNITED ST0 MFGR#1438 24756074
-1997 UNITED ST0 MFGR#1439 19644072
-1997 UNITED ST0 MFGR#144 20285157
-1997 UNITED ST0 MFGR#1440 14068558
-1997 UNITED ST0 MFGR#145 22646138
-1997 UNITED ST0 MFGR#146 16381159
-1997 UNITED ST0 MFGR#147 12267827
-1997 UNITED ST0 MFGR#148 30968614
-1997 UNITED ST0 MFGR#149 8640669
-1997 UNITED ST1 MFGR#141 10152087
-1997 UNITED ST1 MFGR#1410 32583300
-1997 UNITED ST1 MFGR#1411 15690352
-1997 UNITED ST1 MFGR#1412 16671403
-1997 UNITED ST1 MFGR#1413 4942775
-1997 UNITED ST1 MFGR#1414 9391597
-1997 UNITED ST1 MFGR#1415 26937296
-1997 UNITED ST1 MFGR#1416 25782871
-1997 UNITED ST1 MFGR#1417 23349641
-1997 UNITED ST1 MFGR#1418 10934620
-1997 UNITED ST1 MFGR#1419 22673030
-1997 UNITED ST1 MFGR#142 14048276
-1997 UNITED ST1 MFGR#1420 18100795
-1997 UNITED ST1 MFGR#1421 25405678
-1997 UNITED ST1 MFGR#1423 5713800
-1997 UNITED ST1 MFGR#1424 4131923
-1997 UNITED ST1 MFGR#1425 17190425
-1997 UNITED ST1 MFGR#1426 22314044
-1997 UNITED ST1 MFGR#1427 13635057
-1997 UNITED ST1 MFGR#1428 17735811
-1997 UNITED ST1 MFGR#1429 28740911
-1997 UNITED ST1 MFGR#143 27418033
-1997 UNITED ST1 MFGR#1430 18655292
-1997 UNITED ST1 MFGR#1431 11074399
-1997 UNITED ST1 MFGR#1432 7490170
-1997 UNITED ST1 MFGR#1433 28997266
-1997 UNITED ST1 MFGR#1434 4612211
-1997 UNITED ST1 MFGR#1435 16327124
-1997 UNITED ST1 MFGR#1436 17409665
-1997 UNITED ST1 MFGR#1437 33391635
-1997 UNITED ST1 MFGR#1438 37321134
-1997 UNITED ST1 MFGR#1439 10279941
-1997 UNITED ST1 MFGR#144 12304723
-1997 UNITED ST1 MFGR#1440 28921230
-1997 UNITED ST1 MFGR#145 17933684
-1997 UNITED ST1 MFGR#146 8709103
-1997 UNITED ST1 MFGR#147 20145983
-1997 UNITED ST1 MFGR#148 16940400
-1997 UNITED ST1 MFGR#149 10284949
-1997 UNITED ST2 MFGR#1412 6328240
-1997 UNITED ST2 MFGR#1415 5022682
-1997 UNITED ST2 MFGR#1416 4102214
-1997 UNITED ST2 MFGR#1417 5284444
-1997 UNITED ST2 MFGR#1418 2649908
-1997 UNITED ST2 MFGR#1419 4664673
-1997 UNITED ST2 MFGR#142 10784835
-1997 UNITED ST2 MFGR#1423 4095190
-1997 UNITED ST2 MFGR#1424 5376355
-1997 UNITED ST2 MFGR#1425 3949957
-1997 UNITED ST2 MFGR#143 2859829
-1997 UNITED ST2 MFGR#1430 4618266
-1997 UNITED ST2 MFGR#1432 5183060
-1997 UNITED ST2 MFGR#1433 10531371
-1997 UNITED ST2 MFGR#1434 77646
-1997 UNITED ST2 MFGR#1436 6538508
-1997 UNITED ST2 MFGR#1438 12324747
-1997 UNITED ST2 MFGR#144 2002870
-1997 UNITED ST2 MFGR#1440 12247229
-1997 UNITED ST2 MFGR#145 202685
-1997 UNITED ST2 MFGR#148 5998932
-1997 UNITED ST3 MFGR#141 12866083
-1997 UNITED ST3 MFGR#1410 31051703
-1997 UNITED ST3 MFGR#1411 14099543
-1997 UNITED ST3 MFGR#1412 4970551
-1997 UNITED ST3 MFGR#1413 26129762
-1997 UNITED ST3 MFGR#1414 22364787
-1997 UNITED ST3 MFGR#1415 27883428
-1997 UNITED ST3 MFGR#1416 25289630
-1997 UNITED ST3 MFGR#1417 5524810
-1997 UNITED ST3 MFGR#1419 3616608
-1997 UNITED ST3 MFGR#142 10776059
-1997 UNITED ST3 MFGR#1420 12958851
-1997 UNITED ST3 MFGR#1421 5815494
-1997 UNITED ST3 MFGR#1422 17694270
-1997 UNITED ST3 MFGR#1423 10285142
-1997 UNITED ST3 MFGR#1424 21555317
-1997 UNITED ST3 MFGR#1425 5214517
-1997 UNITED ST3 MFGR#1426 16810700
-1997 UNITED ST3 MFGR#1427 10086430
-1997 UNITED ST3 MFGR#1428 7733716
-1997 UNITED ST3 MFGR#1429 11922430
-1997 UNITED ST3 MFGR#1430 20105292
-1997 UNITED ST3 MFGR#1431 14716979
-1997 UNITED ST3 MFGR#1432 15779247
-1997 UNITED ST3 MFGR#1433 15308773
-1997 UNITED ST3 MFGR#1434 8515037
-1997 UNITED ST3 MFGR#1435 25486899
-1997 UNITED ST3 MFGR#1436 12739448
-1997 UNITED ST3 MFGR#1437 11249180
-1997 UNITED ST3 MFGR#1438 4156824
-1997 UNITED ST3 MFGR#1439 18358277
-1997 UNITED ST3 MFGR#144 10097718
-1997 UNITED ST3 MFGR#1440 22920494
-1997 UNITED ST3 MFGR#145 20285859
-1997 UNITED ST3 MFGR#146 18406423
-1997 UNITED ST3 MFGR#147 17295990
-1997 UNITED ST3 MFGR#148 26127145
-1997 UNITED ST3 MFGR#149 19895538
-1997 UNITED ST4 MFGR#141 8135477
-1997 UNITED ST4 MFGR#1410 5503247
-1997 UNITED ST4 MFGR#1411 6096435
-1997 UNITED ST4 MFGR#1412 19976043
-1997 UNITED ST4 MFGR#1413 22581282
-1997 UNITED ST4 MFGR#1414 10101379
-1997 UNITED ST4 MFGR#1415 8877444
-1997 UNITED ST4 MFGR#1416 17943398
-1997 UNITED ST4 MFGR#1417 9224501
-1997 UNITED ST4 MFGR#1418 16255176
-1997 UNITED ST4 MFGR#1419 683069
-1997 UNITED ST4 MFGR#142 23512944
-1997 UNITED ST4 MFGR#1420 27954262
-1997 UNITED ST4 MFGR#1421 54209185
-1997 UNITED ST4 MFGR#1422 1173957
-1997 UNITED ST4 MFGR#1423 20410710
-1997 UNITED ST4 MFGR#1424 2889270
-1997 UNITED ST4 MFGR#1425 13361796
-1997 UNITED ST4 MFGR#1426 18678819
-1997 UNITED ST4 MFGR#1427 18206066
-1997 UNITED ST4 MFGR#1428 18153974
-1997 UNITED ST4 MFGR#1429 12545076
-1997 UNITED ST4 MFGR#143 6158834
-1997 UNITED ST4 MFGR#1430 16128370
-1997 UNITED ST4 MFGR#1431 11153717
-1997 UNITED ST4 MFGR#1432 7745636
-1997 UNITED ST4 MFGR#1433 15983634
-1997 UNITED ST4 MFGR#1434 3662246
-1997 UNITED ST4 MFGR#1435 3060180
-1997 UNITED ST4 MFGR#1436 11524592
-1997 UNITED ST4 MFGR#1437 36824174
-1997 UNITED ST4 MFGR#1438 8226666
-1997 UNITED ST4 MFGR#1439 9872470
-1997 UNITED ST4 MFGR#1440 401207
-1997 UNITED ST4 MFGR#145 11698312
-1997 UNITED ST4 MFGR#146 18259956
-1997 UNITED ST4 MFGR#147 10256110
-1997 UNITED ST4 MFGR#148 15892628
-1997 UNITED ST4 MFGR#149 4322491
-1997 UNITED ST5 MFGR#141 8534275
-1997 UNITED ST5 MFGR#1411 2427261
-1997 UNITED ST5 MFGR#1412 9032422
-1997 UNITED ST5 MFGR#1413 6343588
-1997 UNITED ST5 MFGR#1414 2961025
-1997 UNITED ST5 MFGR#1415 21186568
-1997 UNITED ST5 MFGR#1416 9354080
-1997 UNITED ST5 MFGR#1417 11786246
-1997 UNITED ST5 MFGR#1418 15297245
-1997 UNITED ST5 MFGR#1420 15787608
-1997 UNITED ST5 MFGR#1421 17858301
-1997 UNITED ST5 MFGR#1422 14080987
-1997 UNITED ST5 MFGR#1423 12535186
-1997 UNITED ST5 MFGR#1424 3221960
-1997 UNITED ST5 MFGR#1425 8950317
-1997 UNITED ST5 MFGR#1426 13161486
-1997 UNITED ST5 MFGR#1427 6149737
-1997 UNITED ST5 MFGR#1428 6796520
-1997 UNITED ST5 MFGR#1429 26026300
-1997 UNITED ST5 MFGR#143 6712572
-1997 UNITED ST5 MFGR#1430 16092131
-1997 UNITED ST5 MFGR#1431 3425291
-1997 UNITED ST5 MFGR#1432 14630175
-1997 UNITED ST5 MFGR#1433 4967585
-1997 UNITED ST5 MFGR#1434 6716261
-1997 UNITED ST5 MFGR#1435 6290790
-1997 UNITED ST5 MFGR#1436 6787699
-1997 UNITED ST5 MFGR#1437 6045168
-1997 UNITED ST5 MFGR#1438 1082877
-1997 UNITED ST5 MFGR#1439 5268611
-1997 UNITED ST5 MFGR#144 8900840
-1997 UNITED ST5 MFGR#1440 2644336
-1997 UNITED ST5 MFGR#145 18054844
-1997 UNITED ST5 MFGR#146 4893668
-1997 UNITED ST5 MFGR#147 9615891
-1997 UNITED ST5 MFGR#148 1426124
-1997 UNITED ST5 MFGR#149 7320726
-1997 UNITED ST6 MFGR#141 10051337
-1997 UNITED ST6 MFGR#1410 23352963
-1997 UNITED ST6 MFGR#1411 1537303
-1997 UNITED ST6 MFGR#1412 4332646
-1997 UNITED ST6 MFGR#1413 14686752
-1997 UNITED ST6 MFGR#1414 7226409
-1997 UNITED ST6 MFGR#1415 15062686
-1997 UNITED ST6 MFGR#1416 8606480
-1997 UNITED ST6 MFGR#1417 7662761
-1997 UNITED ST6 MFGR#1418 1810860
-1997 UNITED ST6 MFGR#1419 20179568
-1997 UNITED ST6 MFGR#142 15506072
-1997 UNITED ST6 MFGR#1420 3844271
-1997 UNITED ST6 MFGR#1421 10608709
-1997 UNITED ST6 MFGR#1422 16083699
-1997 UNITED ST6 MFGR#1423 6789571
-1997 UNITED ST6 MFGR#1424 17631950
-1997 UNITED ST6 MFGR#1425 8477221
-1997 UNITED ST6 MFGR#1426 16847029
-1997 UNITED ST6 MFGR#1428 17314796
-1997 UNITED ST6 MFGR#1429 19175871
-1997 UNITED ST6 MFGR#143 8775848
-1997 UNITED ST6 MFGR#1431 5319063
-1997 UNITED ST6 MFGR#1432 7875606
-1997 UNITED ST6 MFGR#1433 9305264
-1997 UNITED ST6 MFGR#1434 8050404
-1997 UNITED ST6 MFGR#1435 17585836
-1997 UNITED ST6 MFGR#1436 13745758
-1997 UNITED ST6 MFGR#1438 14536324
-1997 UNITED ST6 MFGR#1439 11451329
-1997 UNITED ST6 MFGR#144 10794837
-1997 UNITED ST6 MFGR#1440 5719238
-1997 UNITED ST6 MFGR#145 25449058
-1997 UNITED ST6 MFGR#146 17821996
-1997 UNITED ST6 MFGR#147 18922333
-1997 UNITED ST6 MFGR#148 10825718
-1997 UNITED ST6 MFGR#149 14950868
-1997 UNITED ST7 MFGR#141 8291476
-1997 UNITED ST7 MFGR#1410 4622953
-1997 UNITED ST7 MFGR#1411 14885507
-1997 UNITED ST7 MFGR#1412 19011375
-1997 UNITED ST7 MFGR#1413 31178370
-1997 UNITED ST7 MFGR#1414 16429613
-1997 UNITED ST7 MFGR#1415 3091832
-1997 UNITED ST7 MFGR#1416 17008243
-1997 UNITED ST7 MFGR#1417 15609283
-1997 UNITED ST7 MFGR#1418 5059394
-1997 UNITED ST7 MFGR#1419 7234721
-1997 UNITED ST7 MFGR#142 6898938
-1997 UNITED ST7 MFGR#1420 6426590
-1997 UNITED ST7 MFGR#1421 6043221
-1997 UNITED ST7 MFGR#1422 13273021
-1997 UNITED ST7 MFGR#1423 30537249
-1997 UNITED ST7 MFGR#1424 9224296
-1997 UNITED ST7 MFGR#1425 12799069
-1997 UNITED ST7 MFGR#1426 30277891
-1997 UNITED ST7 MFGR#1427 8331493
-1997 UNITED ST7 MFGR#1428 16205423
-1997 UNITED ST7 MFGR#1429 14396627
-1997 UNITED ST7 MFGR#143 10209623
-1997 UNITED ST7 MFGR#1430 16556758
-1997 UNITED ST7 MFGR#1431 15775327
-1997 UNITED ST7 MFGR#1432 24602989
-1997 UNITED ST7 MFGR#1433 22927717
-1997 UNITED ST7 MFGR#1434 9486462
-1997 UNITED ST7 MFGR#1435 14254290
-1997 UNITED ST7 MFGR#1436 8645365
-1997 UNITED ST7 MFGR#1437 19026166
-1997 UNITED ST7 MFGR#1438 11291550
-1997 UNITED ST7 MFGR#1439 9590292
-1997 UNITED ST7 MFGR#144 14110404
-1997 UNITED ST7 MFGR#1440 21877355
-1997 UNITED ST7 MFGR#145 8246717
-1997 UNITED ST7 MFGR#146 9785781
-1997 UNITED ST7 MFGR#147 13412691
-1997 UNITED ST7 MFGR#148 14235939
-1997 UNITED ST7 MFGR#149 23450309
-1997 UNITED ST8 MFGR#141 7323416
-1997 UNITED ST8 MFGR#1410 7191961
-1997 UNITED ST8 MFGR#1411 2425849
-1997 UNITED ST8 MFGR#1412 26725641
-1997 UNITED ST8 MFGR#1413 7915896
-1997 UNITED ST8 MFGR#1414 14359044
-1997 UNITED ST8 MFGR#1415 15834927
-1997 UNITED ST8 MFGR#1416 7464470
-1997 UNITED ST8 MFGR#1417 15274496
-1997 UNITED ST8 MFGR#1418 3261391
-1997 UNITED ST8 MFGR#1419 8020386
-1997 UNITED ST8 MFGR#142 5985550
-1997 UNITED ST8 MFGR#1420 9441461
-1997 UNITED ST8 MFGR#1421 2998735
-1997 UNITED ST8 MFGR#1423 1565415
-1997 UNITED ST8 MFGR#1424 5613094
-1997 UNITED ST8 MFGR#1425 7186734
-1997 UNITED ST8 MFGR#1426 3153117
-1997 UNITED ST8 MFGR#1427 11303043
-1997 UNITED ST8 MFGR#1428 3564003
-1997 UNITED ST8 MFGR#143 6357477
-1997 UNITED ST8 MFGR#1430 6633950
-1997 UNITED ST8 MFGR#1431 867285
-1997 UNITED ST8 MFGR#1432 9962884
-1997 UNITED ST8 MFGR#1433 13708011
-1997 UNITED ST8 MFGR#1434 7357067
-1997 UNITED ST8 MFGR#1435 11993453
-1997 UNITED ST8 MFGR#1436 7231938
-1997 UNITED ST8 MFGR#1437 18632056
-1997 UNITED ST8 MFGR#1438 3609384
-1997 UNITED ST8 MFGR#144 4822734
-1997 UNITED ST8 MFGR#1440 2521917
-1997 UNITED ST8 MFGR#145 11683385
-1997 UNITED ST8 MFGR#146 3350415
-1997 UNITED ST8 MFGR#147 8425393
-1997 UNITED ST8 MFGR#148 15005341
-1997 UNITED ST8 MFGR#149 9018101
-1997 UNITED ST9 MFGR#141 21838850
-1997 UNITED ST9 MFGR#1410 8455387
-1997 UNITED ST9 MFGR#1411 27984689
-1997 UNITED ST9 MFGR#1412 26491401
-1997 UNITED ST9 MFGR#1413 30237705
-1997 UNITED ST9 MFGR#1414 8957476
-1997 UNITED ST9 MFGR#1415 35391583
-1997 UNITED ST9 MFGR#1416 8923782
-1997 UNITED ST9 MFGR#1417 3210984
-1997 UNITED ST9 MFGR#1418 12102607
-1997 UNITED ST9 MFGR#1419 14468627
-1997 UNITED ST9 MFGR#142 33363582
-1997 UNITED ST9 MFGR#1420 13139731
-1997 UNITED ST9 MFGR#1421 8410650
-1997 UNITED ST9 MFGR#1422 11268410
-1997 UNITED ST9 MFGR#1423 2846614
-1997 UNITED ST9 MFGR#1424 2305872
-1997 UNITED ST9 MFGR#1425 4896060
-1997 UNITED ST9 MFGR#1426 31544772
-1997 UNITED ST9 MFGR#1427 4113085
-1997 UNITED ST9 MFGR#1428 11137081
-1997 UNITED ST9 MFGR#1429 10633230
-1997 UNITED ST9 MFGR#143 11438203
-1997 UNITED ST9 MFGR#1430 2727389
-1997 UNITED ST9 MFGR#1431 10548538
-1997 UNITED ST9 MFGR#1433 26564495
-1997 UNITED ST9 MFGR#1434 11948206
-1997 UNITED ST9 MFGR#1435 2201909
-1997 UNITED ST9 MFGR#1436 10347631
-1997 UNITED ST9 MFGR#1437 40051690
-1997 UNITED ST9 MFGR#1438 2662945
-1997 UNITED ST9 MFGR#1439 18011455
-1997 UNITED ST9 MFGR#144 10202784
-1997 UNITED ST9 MFGR#1440 11123196
-1997 UNITED ST9 MFGR#145 11326624
-1997 UNITED ST9 MFGR#146 27825456
-1997 UNITED ST9 MFGR#147 17579502
-1997 UNITED ST9 MFGR#148 17001116
-1998 UNITED ST0 MFGR#141 12484786
-1998 UNITED ST0 MFGR#1410 5225999
-1998 UNITED ST0 MFGR#1411 2633395
-1998 UNITED ST0 MFGR#1412 9479536
-1998 UNITED ST0 MFGR#1413 18468711
-1998 UNITED ST0 MFGR#1414 19440601
-1998 UNITED ST0 MFGR#1415 16894643
-1998 UNITED ST0 MFGR#1416 7520117
-1998 UNITED ST0 MFGR#1417 464576
-1998 UNITED ST0 MFGR#1418 5171747
-1998 UNITED ST0 MFGR#1419 5970985
-1998 UNITED ST0 MFGR#142 23830409
-1998 UNITED ST0 MFGR#1420 2568835
-1998 UNITED ST0 MFGR#1421 6096442
-1998 UNITED ST0 MFGR#1422 10099456
-1998 UNITED ST0 MFGR#1423 24617746
-1998 UNITED ST0 MFGR#1424 22853888
-1998 UNITED ST0 MFGR#1425 25622112
-1998 UNITED ST0 MFGR#1426 9630701
-1998 UNITED ST0 MFGR#1427 4952625
-1998 UNITED ST0 MFGR#1428 4675471
-1998 UNITED ST0 MFGR#1429 19713527
-1998 UNITED ST0 MFGR#143 4971265
-1998 UNITED ST0 MFGR#1430 13948705
-1998 UNITED ST0 MFGR#1431 2955181
-1998 UNITED ST0 MFGR#1432 17946759
-1998 UNITED ST0 MFGR#1433 23325027
-1998 UNITED ST0 MFGR#1434 8580738
-1998 UNITED ST0 MFGR#1435 6663914
-1998 UNITED ST0 MFGR#1436 13468582
-1998 UNITED ST0 MFGR#1437 9419979
-1998 UNITED ST0 MFGR#1438 16164522
-1998 UNITED ST0 MFGR#1439 8692866
-1998 UNITED ST0 MFGR#144 17338711
-1998 UNITED ST0 MFGR#1440 8513736
-1998 UNITED ST0 MFGR#145 6212569
-1998 UNITED ST0 MFGR#146 2702349
-1998 UNITED ST0 MFGR#149 8844540
-1998 UNITED ST1 MFGR#141 13449110
-1998 UNITED ST1 MFGR#1410 5224626
-1998 UNITED ST1 MFGR#1411 16046399
-1998 UNITED ST1 MFGR#1412 8424392
-1998 UNITED ST1 MFGR#1413 7634982
-1998 UNITED ST1 MFGR#1414 8711782
-1998 UNITED ST1 MFGR#1415 5991201
-1998 UNITED ST1 MFGR#1416 11059645
-1998 UNITED ST1 MFGR#1417 8108087
-1998 UNITED ST1 MFGR#1418 1710875
-1998 UNITED ST1 MFGR#1419 452298
-1998 UNITED ST1 MFGR#142 6186526
-1998 UNITED ST1 MFGR#1421 4766963
-1998 UNITED ST1 MFGR#1422 5556563
-1998 UNITED ST1 MFGR#1423 12110257
-1998 UNITED ST1 MFGR#1424 8924948
-1998 UNITED ST1 MFGR#1425 5684710
-1998 UNITED ST1 MFGR#1426 6844444
-1998 UNITED ST1 MFGR#1427 7625525
-1998 UNITED ST1 MFGR#1428 5227395
-1998 UNITED ST1 MFGR#1429 2855272
-1998 UNITED ST1 MFGR#143 6964811
-1998 UNITED ST1 MFGR#1430 16952380
-1998 UNITED ST1 MFGR#1431 7655883
-1998 UNITED ST1 MFGR#1432 2975960
-1998 UNITED ST1 MFGR#1433 10175594
-1998 UNITED ST1 MFGR#1434 26358848
-1998 UNITED ST1 MFGR#1435 11408623
-1998 UNITED ST1 MFGR#1436 4438242
-1998 UNITED ST1 MFGR#1437 10014906
-1998 UNITED ST1 MFGR#1438 18817171
-1998 UNITED ST1 MFGR#1439 2129973
-1998 UNITED ST1 MFGR#144 9512727
-1998 UNITED ST1 MFGR#1440 20185179
-1998 UNITED ST1 MFGR#145 823605
-1998 UNITED ST1 MFGR#146 9358026
-1998 UNITED ST1 MFGR#147 6552312
-1998 UNITED ST1 MFGR#148 9144461
-1998 UNITED ST1 MFGR#149 2149639
-1998 UNITED ST2 MFGR#1410 8044368
-1998 UNITED ST2 MFGR#1413 727343
-1998 UNITED ST2 MFGR#1414 251088
-1998 UNITED ST2 MFGR#1416 5224696
-1998 UNITED ST2 MFGR#1419 7917142
-1998 UNITED ST2 MFGR#1420 9848986
-1998 UNITED ST2 MFGR#1427 4816976
-1998 UNITED ST2 MFGR#1429 4196069
-1998 UNITED ST2 MFGR#143 10073044
-1998 UNITED ST2 MFGR#1431 877123
-1998 UNITED ST2 MFGR#1433 3740836
-1998 UNITED ST2 MFGR#1434 857691
-1998 UNITED ST2 MFGR#1435 2277870
-1998 UNITED ST2 MFGR#145 4906521
-1998 UNITED ST2 MFGR#149 842348
-1998 UNITED ST3 MFGR#141 4181582
-1998 UNITED ST3 MFGR#1410 3169761
-1998 UNITED ST3 MFGR#1412 6590440
-1998 UNITED ST3 MFGR#1413 2015369
-1998 UNITED ST3 MFGR#1414 4408466
-1998 UNITED ST3 MFGR#1415 3963826
-1998 UNITED ST3 MFGR#1416 3179540
-1998 UNITED ST3 MFGR#1417 11440999
-1998 UNITED ST3 MFGR#1418 8725751
-1998 UNITED ST3 MFGR#1419 10646990
-1998 UNITED ST3 MFGR#142 5056172
-1998 UNITED ST3 MFGR#1420 3583150
-1998 UNITED ST3 MFGR#1421 7085689
-1998 UNITED ST3 MFGR#1422 20858904
-1998 UNITED ST3 MFGR#1423 12825743
-1998 UNITED ST3 MFGR#1424 3533518
-1998 UNITED ST3 MFGR#1425 4938324
-1998 UNITED ST3 MFGR#1426 15164664
-1998 UNITED ST3 MFGR#1427 2619162
-1998 UNITED ST3 MFGR#1428 7723699
-1998 UNITED ST3 MFGR#143 24362893
-1998 UNITED ST3 MFGR#1430 7139650
-1998 UNITED ST3 MFGR#1431 10306394
-1998 UNITED ST3 MFGR#1432 14769004
-1998 UNITED ST3 MFGR#1433 9610545
-1998 UNITED ST3 MFGR#1435 6611760
-1998 UNITED ST3 MFGR#1436 941348
-1998 UNITED ST3 MFGR#1437 4802162
-1998 UNITED ST3 MFGR#1438 5079750
-1998 UNITED ST3 MFGR#1439 5905118
-1998 UNITED ST3 MFGR#144 5436839
-1998 UNITED ST3 MFGR#1440 9815517
-1998 UNITED ST3 MFGR#145 7580271
-1998 UNITED ST3 MFGR#146 14051404
-1998 UNITED ST3 MFGR#147 7786017
-1998 UNITED ST3 MFGR#149 1271813
-1998 UNITED ST4 MFGR#141 26703183
-1998 UNITED ST4 MFGR#1410 18094129
-1998 UNITED ST4 MFGR#1411 615999
-1998 UNITED ST4 MFGR#1412 13988709
-1998 UNITED ST4 MFGR#1413 10115647
-1998 UNITED ST4 MFGR#1414 1586551
-1998 UNITED ST4 MFGR#1415 14357244
-1998 UNITED ST4 MFGR#1416 9430036
-1998 UNITED ST4 MFGR#1417 17361773
-1998 UNITED ST4 MFGR#1418 10187338
-1998 UNITED ST4 MFGR#1419 7116094
-1998 UNITED ST4 MFGR#142 18454502
-1998 UNITED ST4 MFGR#1420 1621340
-1998 UNITED ST4 MFGR#1422 13861291
-1998 UNITED ST4 MFGR#1423 4208006
-1998 UNITED ST4 MFGR#1424 3242576
-1998 UNITED ST4 MFGR#1425 1470642
-1998 UNITED ST4 MFGR#1426 11987205
-1998 UNITED ST4 MFGR#1427 12975399
-1998 UNITED ST4 MFGR#1428 11756155
-1998 UNITED ST4 MFGR#1429 6956191
-1998 UNITED ST4 MFGR#143 11499476
-1998 UNITED ST4 MFGR#1430 4355096
-1998 UNITED ST4 MFGR#1431 20166612
-1998 UNITED ST4 MFGR#1432 8849789
-1998 UNITED ST4 MFGR#1433 10786037
-1998 UNITED ST4 MFGR#1435 13208151
-1998 UNITED ST4 MFGR#1436 4747808
-1998 UNITED ST4 MFGR#1437 12999351
-1998 UNITED ST4 MFGR#1438 17360787
-1998 UNITED ST4 MFGR#1439 2557841
-1998 UNITED ST4 MFGR#144 22030911
-1998 UNITED ST4 MFGR#145 5272280
-1998 UNITED ST4 MFGR#146 4307958
-1998 UNITED ST4 MFGR#147 7995050
-1998 UNITED ST4 MFGR#148 2348889
-1998 UNITED ST5 MFGR#141 8396190
-1998 UNITED ST5 MFGR#1410 17422889
-1998 UNITED ST5 MFGR#1411 764246
-1998 UNITED ST5 MFGR#1413 8051561
-1998 UNITED ST5 MFGR#1414 1500867
-1998 UNITED ST5 MFGR#1416 3874315
-1998 UNITED ST5 MFGR#1417 7550747
-1998 UNITED ST5 MFGR#1418 14241755
-1998 UNITED ST5 MFGR#1419 4893846
-1998 UNITED ST5 MFGR#142 5418299
-1998 UNITED ST5 MFGR#1420 3810727
-1998 UNITED ST5 MFGR#1421 3321336
-1998 UNITED ST5 MFGR#1423 5021100
-1998 UNITED ST5 MFGR#1424 6125645
-1998 UNITED ST5 MFGR#1426 880680
-1998 UNITED ST5 MFGR#1427 1284890
-1998 UNITED ST5 MFGR#1428 3813108
-1998 UNITED ST5 MFGR#1429 9429868
-1998 UNITED ST5 MFGR#143 15699981
-1998 UNITED ST5 MFGR#1430 7977654
-1998 UNITED ST5 MFGR#1431 5545969
-1998 UNITED ST5 MFGR#1432 1803434
-1998 UNITED ST5 MFGR#1435 12957056
-1998 UNITED ST5 MFGR#1436 20666755
-1998 UNITED ST5 MFGR#1437 9536733
-1998 UNITED ST5 MFGR#1439 11784214
-1998 UNITED ST5 MFGR#1440 613089
-1998 UNITED ST5 MFGR#145 8237944
-1998 UNITED ST5 MFGR#147 5370351
-1998 UNITED ST6 MFGR#141 6683977
-1998 UNITED ST6 MFGR#1411 11589040
-1998 UNITED ST6 MFGR#1412 4800954
-1998 UNITED ST6 MFGR#1416 5848432
-1998 UNITED ST6 MFGR#1417 1804324
-1998 UNITED ST6 MFGR#1418 4642727
-1998 UNITED ST6 MFGR#1419 10079621
-1998 UNITED ST6 MFGR#142 2533570
-1998 UNITED ST6 MFGR#1420 9016258
-1998 UNITED ST6 MFGR#1421 7636150
-1998 UNITED ST6 MFGR#1422 1272436
-1998 UNITED ST6 MFGR#1423 9600097
-1998 UNITED ST6 MFGR#1424 7036762
-1998 UNITED ST6 MFGR#1425 10867426
-1998 UNITED ST6 MFGR#1426 7033994
-1998 UNITED ST6 MFGR#1427 6481679
-1998 UNITED ST6 MFGR#1428 6269185
-1998 UNITED ST6 MFGR#1429 12055631
-1998 UNITED ST6 MFGR#143 6500459
-1998 UNITED ST6 MFGR#1430 6816243
-1998 UNITED ST6 MFGR#1432 7752973
-1998 UNITED ST6 MFGR#1436 6292813
-1998 UNITED ST6 MFGR#1437 2334894
-1998 UNITED ST6 MFGR#1438 4459455
-1998 UNITED ST6 MFGR#144 640220
-1998 UNITED ST6 MFGR#1440 748200
-1998 UNITED ST6 MFGR#145 7948794
-1998 UNITED ST6 MFGR#146 2734333
-1998 UNITED ST6 MFGR#147 2995632
-1998 UNITED ST6 MFGR#148 10695287
-1998 UNITED ST6 MFGR#149 1475864
-1998 UNITED ST7 MFGR#141 4816637
-1998 UNITED ST7 MFGR#1410 24393912
-1998 UNITED ST7 MFGR#1411 1283038
-1998 UNITED ST7 MFGR#1412 12607459
-1998 UNITED ST7 MFGR#1413 15421293
-1998 UNITED ST7 MFGR#1414 7681668
-1998 UNITED ST7 MFGR#1415 7138377
-1998 UNITED ST7 MFGR#1416 9246990
-1998 UNITED ST7 MFGR#1417 5242972
-1998 UNITED ST7 MFGR#1419 13548941
-1998 UNITED ST7 MFGR#142 17758762
-1998 UNITED ST7 MFGR#1420 11980437
-1998 UNITED ST7 MFGR#1421 11166952
-1998 UNITED ST7 MFGR#1422 9231883
-1998 UNITED ST7 MFGR#1424 5796389
-1998 UNITED ST7 MFGR#1425 4943582
-1998 UNITED ST7 MFGR#1426 16361100
-1998 UNITED ST7 MFGR#1427 9659296
-1998 UNITED ST7 MFGR#1428 2998020
-1998 UNITED ST7 MFGR#1429 5766768
-1998 UNITED ST7 MFGR#143 5526167
-1998 UNITED ST7 MFGR#1430 4191892
-1998 UNITED ST7 MFGR#1431 12979559
-1998 UNITED ST7 MFGR#1432 5832068
-1998 UNITED ST7 MFGR#1433 11410227
-1998 UNITED ST7 MFGR#1434 10525792
-1998 UNITED ST7 MFGR#1435 5982420
-1998 UNITED ST7 MFGR#1436 7142934
-1998 UNITED ST7 MFGR#1437 7499671
-1998 UNITED ST7 MFGR#1438 9177564
-1998 UNITED ST7 MFGR#1439 1974444
-1998 UNITED ST7 MFGR#144 2428463
-1998 UNITED ST7 MFGR#1440 3300838
-1998 UNITED ST7 MFGR#146 1771645
-1998 UNITED ST7 MFGR#147 4681835
-1998 UNITED ST7 MFGR#148 7124367
-1998 UNITED ST7 MFGR#149 11662970
-1998 UNITED ST8 MFGR#141 12753354
-1998 UNITED ST8 MFGR#1410 1097292
-1998 UNITED ST8 MFGR#1411 4069881
-1998 UNITED ST8 MFGR#1414 9474831
-1998 UNITED ST8 MFGR#1415 6406304
-1998 UNITED ST8 MFGR#1418 2392133
-1998 UNITED ST8 MFGR#1419 2953230
-1998 UNITED ST8 MFGR#142 10702563
-1998 UNITED ST8 MFGR#1420 3719432
-1998 UNITED ST8 MFGR#1421 3854657
-1998 UNITED ST8 MFGR#1422 9711968
-1998 UNITED ST8 MFGR#1424 1102516
-1998 UNITED ST8 MFGR#1426 8937532
-1998 UNITED ST8 MFGR#1427 5255637
-1998 UNITED ST8 MFGR#1428 1695112
-1998 UNITED ST8 MFGR#143 6231349
-1998 UNITED ST8 MFGR#1430 4678664
-1998 UNITED ST8 MFGR#1431 2459741
-1998 UNITED ST8 MFGR#1433 1724339
-1998 UNITED ST8 MFGR#1434 8222328
-1998 UNITED ST8 MFGR#1435 4087165
-1998 UNITED ST8 MFGR#1437 7379288
-1998 UNITED ST8 MFGR#1439 1947163
-1998 UNITED ST8 MFGR#144 21846266
-1998 UNITED ST8 MFGR#146 13768113
-1998 UNITED ST8 MFGR#147 5279643
-1998 UNITED ST8 MFGR#149 15221410
-1998 UNITED ST9 MFGR#141 5544000
-1998 UNITED ST9 MFGR#1410 7971104
-1998 UNITED ST9 MFGR#1411 26426609
-1998 UNITED ST9 MFGR#1412 1701777
-1998 UNITED ST9 MFGR#1413 18786672
-1998 UNITED ST9 MFGR#1414 15787780
-1998 UNITED ST9 MFGR#1415 11214818
-1998 UNITED ST9 MFGR#1416 2076120
-1998 UNITED ST9 MFGR#1417 14310334
-1998 UNITED ST9 MFGR#1418 3558355
-1998 UNITED ST9 MFGR#1419 6134867
-1998 UNITED ST9 MFGR#142 257897
-1998 UNITED ST9 MFGR#1420 7716338
-1998 UNITED ST9 MFGR#1421 10291775
-1998 UNITED ST9 MFGR#1422 6105716
-1998 UNITED ST9 MFGR#1423 11378613
-1998 UNITED ST9 MFGR#1424 1904550
-1998 UNITED ST9 MFGR#1425 18831147
-1998 UNITED ST9 MFGR#1426 18562642
-1998 UNITED ST9 MFGR#1427 12565890
-1998 UNITED ST9 MFGR#1428 10720914
-1998 UNITED ST9 MFGR#1429 21940718
-1998 UNITED ST9 MFGR#143 21480722
-1998 UNITED ST9 MFGR#1430 30935173
-1998 UNITED ST9 MFGR#1431 7793012
-1998 UNITED ST9 MFGR#1432 10026104
-1998 UNITED ST9 MFGR#1433 17874435
-1998 UNITED ST9 MFGR#1434 5493785
-1998 UNITED ST9 MFGR#1435 10738769
-1998 UNITED ST9 MFGR#1436 43504
-1998 UNITED ST9 MFGR#1437 13559646
-1998 UNITED ST9 MFGR#1438 12654258
-1998 UNITED ST9 MFGR#1439 5972923
-1998 UNITED ST9 MFGR#144 15702123
-1998 UNITED ST9 MFGR#1440 6681029
-1998 UNITED ST9 MFGR#145 920718
-1998 UNITED ST9 MFGR#146 10435931
-1998 UNITED ST9 MFGR#147 4759326
-1998 UNITED ST9 MFGR#148 9970848
-1998 UNITED ST9 MFGR#149 7510940
-
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_create.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_create.sql
deleted file mode 100644
index d172400d82..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_create.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-CREATE TABLE IF NOT EXISTS `customer` (
- `c_custkey` int(11) NOT NULL COMMENT "",
- `c_name` varchar(26) NOT NULL COMMENT "",
- `c_address` varchar(41) NOT NULL COMMENT "",
- `c_city` varchar(11) NOT NULL COMMENT "",
- `c_nation` varchar(16) NOT NULL COMMENT "",
- `c_region` varchar(13) NOT NULL COMMENT "",
- `c_phone` varchar(16) NOT NULL COMMENT "",
- `c_mktsegment` varchar(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`c_custkey`)
-DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
-PROPERTIES (
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_delete.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_delete.sql
deleted file mode 100644
index fe22a226fe..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-truncate table customer;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_part_delete.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_part_delete.sql
deleted file mode 100644
index f6d0edda74..0000000000
---
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_part_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-delete from customer where c_custkey > 15000 ;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_sequence_create.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_sequence_create.sql
deleted file mode 100644
index 282479442d..0000000000
---
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/customer_sequence_create.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-CREATE TABLE IF NOT EXISTS `customer` (
- `c_custkey` int(11) NOT NULL COMMENT "",
- `c_name` varchar(26) NOT NULL COMMENT "",
- `c_address` varchar(41) NOT NULL COMMENT "",
- `c_city` varchar(11) NOT NULL COMMENT "",
- `c_nation` varchar(16) NOT NULL COMMENT "",
- `c_region` varchar(13) NOT NULL COMMENT "",
- `c_phone` varchar(16) NOT NULL COMMENT "",
- `c_mktsegment` varchar(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`c_custkey`)
-DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
-PROPERTIES (
-"function_column.sequence_type" = 'int',
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_create.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_create.sql
deleted file mode 100644
index 830ce3ce59..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_create.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-CREATE TABLE IF NOT EXISTS `date` (
- `d_datekey` int(11) NOT NULL COMMENT "",
- `d_date` varchar(20) NOT NULL COMMENT "",
- `d_dayofweek` varchar(10) NOT NULL COMMENT "",
- `d_month` varchar(11) NOT NULL COMMENT "",
- `d_year` int(11) NOT NULL COMMENT "",
- `d_yearmonthnum` int(11) NOT NULL COMMENT "",
- `d_yearmonth` varchar(9) NOT NULL COMMENT "",
- `d_daynuminweek` int(11) NOT NULL COMMENT "",
- `d_daynuminmonth` int(11) NOT NULL COMMENT "",
- `d_daynuminyear` int(11) NOT NULL COMMENT "",
- `d_monthnuminyear` int(11) NOT NULL COMMENT "",
- `d_weeknuminyear` int(11) NOT NULL COMMENT "",
- `d_sellingseason` varchar(14) NOT NULL COMMENT "",
- `d_lastdayinweekfl` int(11) NOT NULL COMMENT "",
- `d_lastdayinmonthfl` int(11) NOT NULL COMMENT "",
- `d_holidayfl` int(11) NOT NULL COMMENT "",
- `d_weekdayfl` int(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`d_datekey`)
-DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
-PROPERTIES (
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_delete.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_delete.sql
deleted file mode 100644
index 12933cbbad..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-truncate table `date`;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_part_delete.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_part_delete.sql
deleted file mode 100644
index d9ccd7c336..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_part_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-delete from `date` where d_datekey >= '19930101' and d_datekey <= '19951230';
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_sequence_create.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_sequence_create.sql
deleted file mode 100644
index 662ac4fbd2..0000000000
---
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/date_sequence_create.sql
+++ /dev/null
@@ -1,26 +0,0 @@
-CREATE TABLE IF NOT EXISTS `date` (
- `d_datekey` int(11) NOT NULL COMMENT "",
- `d_date` varchar(20) NOT NULL COMMENT "",
- `d_dayofweek` varchar(10) NOT NULL COMMENT "",
- `d_month` varchar(11) NOT NULL COMMENT "",
- `d_year` int(11) NOT NULL COMMENT "",
- `d_yearmonthnum` int(11) NOT NULL COMMENT "",
- `d_yearmonth` varchar(9) NOT NULL COMMENT "",
- `d_daynuminweek` int(11) NOT NULL COMMENT "",
- `d_daynuminmonth` int(11) NOT NULL COMMENT "",
- `d_daynuminyear` int(11) NOT NULL COMMENT "",
- `d_monthnuminyear` int(11) NOT NULL COMMENT "",
- `d_weeknuminyear` int(11) NOT NULL COMMENT "",
- `d_sellingseason` varchar(14) NOT NULL COMMENT "",
- `d_lastdayinweekfl` int(11) NOT NULL COMMENT "",
- `d_lastdayinmonthfl` int(11) NOT NULL COMMENT "",
- `d_holidayfl` int(11) NOT NULL COMMENT "",
- `d_weekdayfl` int(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`d_datekey`)
-DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
-PROPERTIES (
-"function_column.sequence_type" = 'int',
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_create.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_create.sql
deleted file mode 100644
index d75a3f1ae3..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_create.sql
+++ /dev/null
@@ -1,33 +0,0 @@
-CREATE TABLE IF NOT EXISTS `lineorder` (
- `lo_orderdate` int(11) NOT NULL COMMENT "",
- `lo_orderkey` bigint(20) NOT NULL COMMENT "",
- `lo_linenumber` bigint(20) NOT NULL COMMENT "",
- `lo_custkey` int(11) NOT NULL COMMENT "",
- `lo_partkey` int(11) NOT NULL COMMENT "",
- `lo_suppkey` int(11) NOT NULL COMMENT "",
- `lo_orderpriority` varchar(16) NOT NULL COMMENT "",
- `lo_shippriority` int(11) NOT NULL COMMENT "",
- `lo_quantity` bigint(20) NOT NULL COMMENT "",
- `lo_extendedprice` bigint(20) NOT NULL COMMENT "",
- `lo_ordtotalprice` bigint(20) NOT NULL COMMENT "",
- `lo_discount` bigint(20) NOT NULL COMMENT "",
- `lo_revenue` bigint(20) NOT NULL COMMENT "",
- `lo_supplycost` bigint(20) NOT NULL COMMENT "",
- `lo_tax` bigint(20) NOT NULL COMMENT "",
- `lo_commitdate` bigint(20) NOT NULL COMMENT "",
- `lo_shipmode` varchar(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`lo_orderdate`,`lo_orderkey`,`lo_linenumber`)
-PARTITION BY RANGE(`lo_orderdate`)
-(PARTITION p1992 VALUES [("-2147483648"), ("19930101")),
-PARTITION p1993 VALUES [("19930101"), ("19940101")),
-PARTITION p1994 VALUES [("19940101"), ("19950101")),
-PARTITION p1995 VALUES [("19950101"), ("19960101")),
-PARTITION p1996 VALUES [("19960101"), ("19970101")),
-PARTITION p1997 VALUES [("19970101"), ("19980101")),
-PARTITION p1998 VALUES [("19980101"), ("19990101")))
-DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48
-PROPERTIES (
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_delete.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_delete.sql
deleted file mode 100644
index 329e040060..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-truncate table lineorder;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_part_delete.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_part_delete.sql
deleted file mode 100644
index 3dfa3a69d9..0000000000
---
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_part_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-delete from lineorder where lo_orderkey >= 2400001 and lo_orderkey <= 3600000;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_sequence_create.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_sequence_create.sql
deleted file mode 100644
index 988cad5e2e..0000000000
---
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/lineorder_sequence_create.sql
+++ /dev/null
@@ -1,34 +0,0 @@
-CREATE TABLE IF NOT EXISTS `lineorder` (
- `lo_orderdate` int(11) NOT NULL COMMENT "",
- `lo_orderkey` bigint(20) NOT NULL COMMENT "",
- `lo_linenumber` bigint(20) NOT NULL COMMENT "",
- `lo_custkey` int(11) NOT NULL COMMENT "",
- `lo_partkey` int(11) NOT NULL COMMENT "",
- `lo_suppkey` int(11) NOT NULL COMMENT "",
- `lo_orderpriority` varchar(16) NOT NULL COMMENT "",
- `lo_shippriority` int(11) NOT NULL COMMENT "",
- `lo_quantity` bigint(20) NOT NULL COMMENT "",
- `lo_extendedprice` bigint(20) NOT NULL COMMENT "",
- `lo_ordtotalprice` bigint(20) NOT NULL COMMENT "",
- `lo_discount` bigint(20) NOT NULL COMMENT "",
- `lo_revenue` bigint(20) NOT NULL COMMENT "",
- `lo_supplycost` bigint(20) NOT NULL COMMENT "",
- `lo_tax` bigint(20) NOT NULL COMMENT "",
- `lo_commitdate` bigint(20) NOT NULL COMMENT "",
- `lo_shipmode` varchar(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`lo_orderdate`,`lo_orderkey`,`lo_linenumber`)
-PARTITION BY RANGE(`lo_orderdate`)
-(PARTITION p1992 VALUES [("-2147483648"), ("19930101")),
-PARTITION p1993 VALUES [("19930101"), ("19940101")),
-PARTITION p1994 VALUES [("19940101"), ("19950101")),
-PARTITION p1995 VALUES [("19950101"), ("19960101")),
-PARTITION p1996 VALUES [("19960101"), ("19970101")),
-PARTITION p1997 VALUES [("19970101"), ("19980101")),
-PARTITION p1998 VALUES [("19980101"), ("19990101")))
-DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48
-PROPERTIES (
-"function_column.sequence_type" = 'int',
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_create.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_create.sql
deleted file mode 100644
index becc59157c..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_create.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-CREATE TABLE IF NOT EXISTS `part` (
- `p_partkey` int(11) NOT NULL COMMENT "",
- `p_name` varchar(23) NOT NULL COMMENT "",
- `p_mfgr` varchar(7) NOT NULL COMMENT "",
- `p_category` varchar(8) NOT NULL COMMENT "",
- `p_brand` varchar(10) NOT NULL COMMENT "",
- `p_color` varchar(12) NOT NULL COMMENT "",
- `p_type` varchar(26) NOT NULL COMMENT "",
- `p_size` int(11) NOT NULL COMMENT "",
- `p_container` varchar(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`p_partkey`)
-DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
-PROPERTIES (
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_delete.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_delete.sql
deleted file mode 100644
index 02c6abd253..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-truncate table `part`;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_part_delete.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_part_delete.sql
deleted file mode 100644
index 9bfcb37904..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_part_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-delete from `part` where p_partkey > 100000;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_sequence_create.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_sequence_create.sql
deleted file mode 100644
index 89cdb20227..0000000000
---
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/part_sequence_create.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-CREATE TABLE IF NOT EXISTS `part` (
- `p_partkey` int(11) NOT NULL COMMENT "",
- `p_name` varchar(23) NOT NULL COMMENT "",
- `p_mfgr` varchar(7) NOT NULL COMMENT "",
- `p_category` varchar(8) NOT NULL COMMENT "",
- `p_brand` varchar(10) NOT NULL COMMENT "",
- `p_color` varchar(12) NOT NULL COMMENT "",
- `p_type` varchar(26) NOT NULL COMMENT "",
- `p_size` int(11) NOT NULL COMMENT "",
- `p_container` varchar(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`p_partkey`)
-DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
-PROPERTIES (
-"function_column.sequence_type" = 'int',
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_create.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_create.sql
deleted file mode 100644
index 7839462196..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_create.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-CREATE TABLE IF NOT EXISTS `supplier` (
- `s_suppkey` int(11) NOT NULL COMMENT "",
- `s_name` varchar(26) NOT NULL COMMENT "",
- `s_address` varchar(26) NOT NULL COMMENT "",
- `s_city` varchar(11) NOT NULL COMMENT "",
- `s_nation` varchar(16) NOT NULL COMMENT "",
- `s_region` varchar(13) NOT NULL COMMENT "",
- `s_phone` varchar(16) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`s_suppkey`)
-DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
-PROPERTIES (
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_delete.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_delete.sql
deleted file mode 100644
index 39e663134c..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-truncate table `supplier`;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_part_delete.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_part_delete.sql
deleted file mode 100644
index 431b9bbb82..0000000000
---
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_part_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-delete from `supplier` where s_suppkey > 1000;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_sequence_create.sql
b/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_sequence_create.sql
deleted file mode 100644
index e3dcbf33b7..0000000000
---
a/regression-test/suites/ssb_sf1_unique_load_zstd/ddl/supplier_sequence_create.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-CREATE TABLE IF NOT EXISTS `supplier` (
- `s_suppkey` int(11) NOT NULL COMMENT "",
- `s_name` varchar(26) NOT NULL COMMENT "",
- `s_address` varchar(26) NOT NULL COMMENT "",
- `s_city` varchar(11) NOT NULL COMMENT "",
- `s_nation` varchar(16) NOT NULL COMMENT "",
- `s_region` varchar(13) NOT NULL COMMENT "",
- `s_phone` varchar(16) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`s_suppkey`)
-DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
-PROPERTIES (
-"function_column.sequence_type" = 'int',
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/load_four_step.groovy
b/regression-test/suites/ssb_sf1_unique_load_zstd/load_four_step.groovy
deleted file mode 100644
index 37a5f0650a..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/load_four_step.groovy
+++ /dev/null
@@ -1,112 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements. See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership. The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License. You may obtain a copy of the License at
-//
-// http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied. See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-// Most of the cases are copied from
https://github.com/trinodb/trino/tree/master
-// /testing/trino-product-tests/src/main/resources/sql-tests/testcases
-// and modified by Doris.
-
-suite("load_four_step") {
- def url =
"https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com";
- def tables = ["customer":
["""c_custkey,c_name,c_address,c_city,c_nation,c_region,c_phone,c_mktsegment,no_use""",
30000, "c_custkey", 15000], "lineorder":
["""lo_orderkey,lo_linenumber,lo_custkey,lo_partkey,lo_suppkey,lo_orderdate,lo_orderpriority,
-
lo_shippriority,lo_quantity,lo_extendedprice,lo_ordtotalprice,lo_discount,
-
lo_revenue,lo_supplycost,lo_tax,lo_commitdate,lo_shipmode,lo_dummy""", 6001215,
"lo_orderkey", 4799919], "part":
["""p_partkey,p_name,p_mfgr,p_category,p_brand,p_color,p_type,p_size,p_container,p_dummy""",
200000, "p_partkey", 100000], "date":
["""d_datekey,d_date,d_dayofweek,d_month,d_year,d_yearmonthnum,d_yearmonth,
-
d_daynuminweek,d_daynuminmonth,d_daynuminyear,d_monthnuminyear,d_weeknuminyear,
-
d_sellingseason,d_lastdayinweekfl,d_lastdayinmonthfl,d_holidayfl,d_weekdayfl,d_dummy""",
2556, "d_datekey", 1462], "supplier":
["""s_suppkey,s_name,s_address,s_city,s_nation,s_region,s_phone,s_dummy""",
2000, "s_suppkey", 1000]]
-
- tables.each { tableName, rows ->
- String fileName =
"""${context.sf1DataPath}/ssb/sf1/${tableName}.tbl.gz"""
- if (!new File(fileName).isAbsolute()) {
- fileName = new File(context.dataPath, fileName).getAbsolutePath()
- }
- if (!new File(fileName).exists()) {
- fileName = """${url}/ssb/sf1/${tableName}.tbl.gz"""
- }
- sql """ DROP TABLE IF EXISTS $tableName """
- sql new
File("""${context.file.parent}/ddl/${tableName}_sequence_create.sql""").text
- for (j in 0..<2) {
- streamLoad {
- table tableName
- set 'column_separator', '|'
- set 'compress_type', 'GZ'
- set 'columns', rows[0]
- set 'function_column.sequence_col', rows[2]
- file fileName
-
- time 10000 // limit inflight 10s
-
- // stream load action will check result, include Success
status, and NumberTotalRows == NumberLoadedRows
-
- // if declared a check callback, the default check condition
will ignore.
- // So you must check all condition
- check { result, exception, startTime, endTime ->
- if (exception != null) {
- throw exception
- }
- log.info("Stream load result: ${result}".toString())
- def json = parseJson(result)
- assertEquals("success", json.Status.toLowerCase())
- assertEquals(json.NumberTotalRows, json.NumberLoadedRows)
- assertTrue(json.NumberLoadedRows > 0 && json.LoadBytes > 0)
- }
- }
- sql 'sync'
- for (int i = 1; i <= 5; i++) {
- def loadRowCount = sql "select count(1) from ${tableName}"
- logger.info("select ${tableName} numbers:
${loadRowCount[0][0]}".toString())
- assertTrue(loadRowCount[0][0] == rows[1])
- }
- }
- sql """ set delete_without_partition = true; """
- sql new
File("""${context.file.parent}/ddl/${tableName}_part_delete.sql""").text
- for (int i = 1; i <= 5; i++) {
- def loadRowCount = sql "select count(1) from ${tableName}"
- logger.info("select ${tableName} numbers:
${loadRowCount[0][0]}".toString())
- assertTrue(loadRowCount[0][0] == rows[3])
- }
- streamLoad {
- table tableName
- set 'column_separator', '|'
- set 'compress_type', 'GZ'
- set 'columns', rows[0]
- set 'function_column.sequence_col', rows[2]
- file """${getS3Url() + '/regression/ssb/sf1/' +
tableName}.tbl.gz"""
-
- time 10000 // limit inflight 10s
-
- // stream load action will check result, include Success status,
and NumberTotalRows == NumberLoadedRows
-
- // if declared a check callback, the default check condition will
ignore.
- // So you must check all condition
- check { result, exception, startTime, endTime ->
- if (exception != null) {
- throw exception
- }
- log.info("Stream load result: ${result}".toString())
- def json = parseJson(result)
- assertEquals("success", json.Status.toLowerCase())
- assertEquals(json.NumberTotalRows, json.NumberLoadedRows)
- assertTrue(json.NumberLoadedRows > 0 && json.LoadBytes > 0)
- }
- }
- sql 'sync'
- for (int i = 1; i <= 5; i++) {
- def loadRowCount = sql "select count(1) from ${tableName}"
- logger.info("select ${tableName} numbers:
${loadRowCount[0][0]}".toString())
- assertTrue(loadRowCount[0][0] == rows[1])
- }
- }
-}
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/load_one_step.groovy
b/regression-test/suites/ssb_sf1_unique_load_zstd/load_one_step.groovy
deleted file mode 100644
index c8acd0eaa4..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/load_one_step.groovy
+++ /dev/null
@@ -1,68 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements. See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership. The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License. You may obtain a copy of the License at
-//
-// http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied. See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-
-suite("load_one_step") {
- def url =
"https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com";
- def tables = ["customer":
["""c_custkey,c_name,c_address,c_city,c_nation,c_region,c_phone,c_mktsegment,no_use""",
30000], "lineorder":
["""lo_orderkey,lo_linenumber,lo_custkey,lo_partkey,lo_suppkey,lo_orderdate,lo_orderpriority,
-
lo_shippriority,lo_quantity,lo_extendedprice,lo_ordtotalprice,lo_discount,
-
lo_revenue,lo_supplycost,lo_tax,lo_commitdate,lo_shipmode,lo_dummy""",
6001215], "part":
["""p_partkey,p_name,p_mfgr,p_category,p_brand,p_color,p_type,p_size,p_container,p_dummy""",
200000], "date":
["""d_datekey,d_date,d_dayofweek,d_month,d_year,d_yearmonthnum,d_yearmonth,
-
d_daynuminweek,d_daynuminmonth,d_daynuminyear,d_monthnuminyear,d_weeknuminyear,
-
d_sellingseason,d_lastdayinweekfl,d_lastdayinmonthfl,d_holidayfl,d_weekdayfl,d_dummy""",
2556], "supplier":
["""s_suppkey,s_name,s_address,s_city,s_nation,s_region,s_phone,s_dummy""",
2000]]
-
- tables.each { tableName, rows ->
- String fileName =
"""${context.sf1DataPath}/ssb/sf1/${tableName}.tbl.gz"""
- if (!new File(fileName).isAbsolute()) {
- fileName = new File(context.dataPath, fileName).getAbsolutePath()
- }
- if (!new File(fileName).exists()) {
- fileName = """${url}/ssb/sf1/${tableName}.tbl.gz"""
- }
- sql """ DROP TABLE IF EXISTS $tableName """
- sql new
File("""${context.file.parent}/ddl/${tableName}_create.sql""").text
- streamLoad {
- table tableName
- set 'column_separator', '|'
- set 'compress_type', 'GZ'
- set 'columns', rows[0]
- file fileName
-
- time 10000 // limit inflight 10s
-
- // stream load action will check result, include Success status,
and NumberTotalRows == NumberLoadedRows
-
- // if declared a check callback, the default check condition will
ignore.
- // So you must check all condition
- check { result, exception, startTime, endTime ->
- if (exception != null) {
- throw exception
- }
- log.info("Stream load result: ${result}".toString())
- def json = parseJson(result)
- assertEquals("success", json.Status.toLowerCase())
- assertEquals(json.NumberTotalRows, json.NumberLoadedRows)
- assertTrue(json.NumberLoadedRows > 0 && json.LoadBytes > 0)
- }
- }
- sql 'sync'
- for (int i = 1; i <= 5; i++) {
- def loadRowCount = sql "select count(1) from ${tableName}"
- logger.info("select ${tableName} numbers:
${loadRowCount[0][0]}".toString())
- assertTrue(loadRowCount[0][0] == rows[1])
- }
- }
-}
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/load_three_step.groovy
b/regression-test/suites/ssb_sf1_unique_load_zstd/load_three_step.groovy
deleted file mode 100644
index 5294c3186b..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/load_three_step.groovy
+++ /dev/null
@@ -1,77 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements. See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership. The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License. You may obtain a copy of the License at
-//
-// http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied. See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-
-suite("load_three_step") {
- def url =
"https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com";
- def tables = ["customer":
["""c_custkey,c_name,c_address,c_city,c_nation,c_region,c_phone,c_mktsegment,no_use""",
30000, "c_custkey"], "lineorder":
["""lo_orderkey,lo_linenumber,lo_custkey,lo_partkey,lo_suppkey,lo_orderdate,lo_orderpriority,
-
lo_shippriority,lo_quantity,lo_extendedprice,lo_ordtotalprice,lo_discount,
-
lo_revenue,lo_supplycost,lo_tax,lo_commitdate,lo_shipmode,lo_dummy""", 6001215,
"lo_orderkey"], "part":
["""p_partkey,p_name,p_mfgr,p_category,p_brand,p_color,p_type,p_size,p_container,p_dummy""",
200000, "p_partkey"], "date":
["""d_datekey,d_date,d_dayofweek,d_month,d_year,d_yearmonthnum,d_yearmonth,
-
d_daynuminweek,d_daynuminmonth,d_daynuminyear,d_monthnuminyear,d_weeknuminyear,
-
d_sellingseason,d_lastdayinweekfl,d_lastdayinmonthfl,d_holidayfl,d_weekdayfl,d_dummy""",
2556, "d_datekey"], "supplier":
["""s_suppkey,s_name,s_address,s_city,s_nation,s_region,s_phone,s_dummy""",
2000, "s_suppkey"]]
-
- tables.each { tableName, rows ->
- String fileName =
"""${context.sf1DataPath}/ssb/sf1/${tableName}.tbl.gz"""
- if (!new File(fileName).isAbsolute()) {
- fileName = new File(context.dataPath, fileName).getAbsolutePath()
- }
- if (!new File(fileName).exists()) {
- fileName = """${url}/ssb/sf1/${tableName}.tbl.gz"""
- }
- sql """ DROP TABLE IF EXISTS $tableName """
- sql new
File("""${context.file.parent}/ddl/${tableName}_sequence_create.sql""").text
- for (j in 0..<2) {
- streamLoad {
- table tableName
- set 'column_separator', '|'
- set 'compress_type', 'GZ'
- set 'columns', rows[0]
- set 'function_column.sequence_col', rows[2]
- file fileName
-
- time 10000 // limit inflight 10s
-
- // stream load action will check result, include Success
status, and NumberTotalRows == NumberLoadedRows
-
- // if declared a check callback, the default check condition
will ignore.
- // So you must check all condition
- check { result, exception, startTime, endTime ->
- if (exception != null) {
- throw exception
- }
- log.info("Stream load result: ${result}".toString())
- def json = parseJson(result)
- assertEquals("success", json.Status.toLowerCase())
- assertEquals(json.NumberTotalRows, json.NumberLoadedRows)
- assertTrue(json.NumberLoadedRows > 0 && json.LoadBytes > 0)
- }
- }
- sql 'sync'
- for (int i = 1; i <= 5; i++) {
- def loadRowCount = sql "select count(1) from ${tableName}"
- logger.info("select ${tableName} numbers:
${loadRowCount[0][0]}".toString())
- assertTrue(loadRowCount[0][0] == rows[1])
- }
- }
- sql new
File("""${context.file.parent}/ddl/${tableName}_delete.sql""").text
- for (int i = 1; i <= 5; i++) {
- def loadRowCount = sql "select count(1) from ${tableName}"
- logger.info("select ${tableName} numbers:
${loadRowCount[0][0]}".toString())
- assertTrue(loadRowCount[0][0] == 0)
- }
- }
-}
diff --git
a/regression-test/suites/ssb_sf1_unique_load_zstd/load_two_step.groovy
b/regression-test/suites/ssb_sf1_unique_load_zstd/load_two_step.groovy
deleted file mode 100644
index b576deb4a3..0000000000
--- a/regression-test/suites/ssb_sf1_unique_load_zstd/load_two_step.groovy
+++ /dev/null
@@ -1,75 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements. See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership. The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License. You may obtain a copy of the License at
-//
-// http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied. See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-
-suite("load_two_step") {
- def url =
"https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com";
- def tables = ["customer":
["""c_custkey,c_name,c_address,c_city,c_nation,c_region,c_phone,c_mktsegment,no_use""",
30000, "c_custkey"], "lineorder":
["""lo_orderkey,lo_linenumber,lo_custkey,lo_partkey,lo_suppkey,lo_orderdate,lo_orderpriority,
-
lo_shippriority,lo_quantity,lo_extendedprice,lo_ordtotalprice,lo_discount,
-
lo_revenue,lo_supplycost,lo_tax,lo_commitdate,lo_shipmode,lo_dummy""", 6001215,
"lo_orderkey"], "part":
["""p_partkey,p_name,p_mfgr,p_category,p_brand,p_color,p_type,p_size,p_container,p_dummy""",
200000, "p_partkey"], "date":
["""d_datekey,d_date,d_dayofweek,d_month,d_year,d_yearmonthnum,d_yearmonth,
-
d_daynuminweek,d_daynuminmonth,d_daynuminyear,d_monthnuminyear,d_weeknuminyear,
-
d_sellingseason,d_lastdayinweekfl,d_lastdayinmonthfl,d_holidayfl,d_weekdayfl,d_dummy""",
2556, "d_datekey"], "supplier":
["""s_suppkey,s_name,s_address,s_city,s_nation,s_region,s_phone,s_dummy""",
2000, "s_suppkey"]]
-
- tables.each { tableName, rows ->
- String fileName =
"""${context.sf1DataPath}/ssb/sf1/${tableName}.tbl.gz"""
- if (!new File(fileName).isAbsolute()) {
- fileName = new File(context.dataPath, fileName).getAbsolutePath()
- }
- if (!new File(fileName).exists()) {
- fileName = """${url}/ssb/sf1/${tableName}.tbl.gz"""
- }
- sql """ DROP TABLE IF EXISTS $tableName """
- sql new
File("""${context.file.parent}/ddl/${tableName}_sequence_create.sql""").text
- streamLoad {
- table tableName
- set 'column_separator', '|'
- set 'compress_type', 'GZ'
- set 'columns', rows[0]
- set 'function_column.sequence_col', rows[2]
- file fileName
-
- time 10000 // limit inflight 10s
-
- // stream load action will check result, include Success status,
and NumberTotalRows == NumberLoadedRows
-
- // if declared a check callback, the default check condition will
ignore.
- // So you must check all condition
- check { result, exception, startTime, endTime ->
- if (exception != null) {
- throw exception
- }
- log.info("Stream load result: ${result}".toString())
- def json = parseJson(result)
- assertEquals("success", json.Status.toLowerCase())
- assertEquals(json.NumberTotalRows, json.NumberLoadedRows)
- assertTrue(json.NumberLoadedRows > 0 && json.LoadBytes > 0)
- }
- }
- sql 'sync'
- for (int i = 1; i <= 5; i++) {
- def loadRowCount = sql "select count(1) from ${tableName}"
- logger.info("select ${tableName} numbers:
${loadRowCount[0][0]}".toString())
- assertTrue(loadRowCount[0][0] == rows[1])
- }
- sql new
File("""${context.file.parent}/ddl/${tableName}_delete.sql""").text
- for (int i = 1; i <= 5; i++) {
- def loadRowCount = sql "select count(1) from ${tableName}"
- logger.info("select ${tableName} numbers:
${loadRowCount[0][0]}".toString())
- assertTrue(loadRowCount[0][0] == 0)
- }
- }
-}
diff --git
a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/customer_create.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/customer_create.sql
deleted file mode 100644
index d172400d82..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/customer_create.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-CREATE TABLE IF NOT EXISTS `customer` (
- `c_custkey` int(11) NOT NULL COMMENT "",
- `c_name` varchar(26) NOT NULL COMMENT "",
- `c_address` varchar(41) NOT NULL COMMENT "",
- `c_city` varchar(11) NOT NULL COMMENT "",
- `c_nation` varchar(16) NOT NULL COMMENT "",
- `c_region` varchar(13) NOT NULL COMMENT "",
- `c_phone` varchar(16) NOT NULL COMMENT "",
- `c_mktsegment` varchar(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`c_custkey`)
-DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
-PROPERTIES (
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/customer_delete.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/customer_delete.sql
deleted file mode 100644
index fe22a226fe..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/customer_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-truncate table customer;
\ No newline at end of file
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/date_create.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/date_create.sql
deleted file mode 100644
index 830ce3ce59..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/date_create.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-CREATE TABLE IF NOT EXISTS `date` (
- `d_datekey` int(11) NOT NULL COMMENT "",
- `d_date` varchar(20) NOT NULL COMMENT "",
- `d_dayofweek` varchar(10) NOT NULL COMMENT "",
- `d_month` varchar(11) NOT NULL COMMENT "",
- `d_year` int(11) NOT NULL COMMENT "",
- `d_yearmonthnum` int(11) NOT NULL COMMENT "",
- `d_yearmonth` varchar(9) NOT NULL COMMENT "",
- `d_daynuminweek` int(11) NOT NULL COMMENT "",
- `d_daynuminmonth` int(11) NOT NULL COMMENT "",
- `d_daynuminyear` int(11) NOT NULL COMMENT "",
- `d_monthnuminyear` int(11) NOT NULL COMMENT "",
- `d_weeknuminyear` int(11) NOT NULL COMMENT "",
- `d_sellingseason` varchar(14) NOT NULL COMMENT "",
- `d_lastdayinweekfl` int(11) NOT NULL COMMENT "",
- `d_lastdayinmonthfl` int(11) NOT NULL COMMENT "",
- `d_holidayfl` int(11) NOT NULL COMMENT "",
- `d_weekdayfl` int(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`d_datekey`)
-DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
-PROPERTIES (
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/date_delete.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/date_delete.sql
deleted file mode 100644
index 12933cbbad..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/date_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-truncate table `date`;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/lineorder_create.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/lineorder_create.sql
deleted file mode 100644
index d75a3f1ae3..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/lineorder_create.sql
+++ /dev/null
@@ -1,33 +0,0 @@
-CREATE TABLE IF NOT EXISTS `lineorder` (
- `lo_orderdate` int(11) NOT NULL COMMENT "",
- `lo_orderkey` bigint(20) NOT NULL COMMENT "",
- `lo_linenumber` bigint(20) NOT NULL COMMENT "",
- `lo_custkey` int(11) NOT NULL COMMENT "",
- `lo_partkey` int(11) NOT NULL COMMENT "",
- `lo_suppkey` int(11) NOT NULL COMMENT "",
- `lo_orderpriority` varchar(16) NOT NULL COMMENT "",
- `lo_shippriority` int(11) NOT NULL COMMENT "",
- `lo_quantity` bigint(20) NOT NULL COMMENT "",
- `lo_extendedprice` bigint(20) NOT NULL COMMENT "",
- `lo_ordtotalprice` bigint(20) NOT NULL COMMENT "",
- `lo_discount` bigint(20) NOT NULL COMMENT "",
- `lo_revenue` bigint(20) NOT NULL COMMENT "",
- `lo_supplycost` bigint(20) NOT NULL COMMENT "",
- `lo_tax` bigint(20) NOT NULL COMMENT "",
- `lo_commitdate` bigint(20) NOT NULL COMMENT "",
- `lo_shipmode` varchar(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`lo_orderdate`,`lo_orderkey`,`lo_linenumber`)
-PARTITION BY RANGE(`lo_orderdate`)
-(PARTITION p1992 VALUES [("-2147483648"), ("19930101")),
-PARTITION p1993 VALUES [("19930101"), ("19940101")),
-PARTITION p1994 VALUES [("19940101"), ("19950101")),
-PARTITION p1995 VALUES [("19950101"), ("19960101")),
-PARTITION p1996 VALUES [("19960101"), ("19970101")),
-PARTITION p1997 VALUES [("19970101"), ("19980101")),
-PARTITION p1998 VALUES [("19980101"), ("19990101")))
-DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48
-PROPERTIES (
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/lineorder_delete.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/lineorder_delete.sql
deleted file mode 100644
index 329e040060..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/lineorder_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-truncate table lineorder;
\ No newline at end of file
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/part_create.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/part_create.sql
deleted file mode 100644
index becc59157c..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/part_create.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-CREATE TABLE IF NOT EXISTS `part` (
- `p_partkey` int(11) NOT NULL COMMENT "",
- `p_name` varchar(23) NOT NULL COMMENT "",
- `p_mfgr` varchar(7) NOT NULL COMMENT "",
- `p_category` varchar(8) NOT NULL COMMENT "",
- `p_brand` varchar(10) NOT NULL COMMENT "",
- `p_color` varchar(12) NOT NULL COMMENT "",
- `p_type` varchar(26) NOT NULL COMMENT "",
- `p_size` int(11) NOT NULL COMMENT "",
- `p_container` varchar(11) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`p_partkey`)
-DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
-PROPERTIES (
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/part_delete.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/part_delete.sql
deleted file mode 100644
index 02c6abd253..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/part_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-truncate table `part`;
\ No newline at end of file
diff --git
a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/supplier_create.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/supplier_create.sql
deleted file mode 100644
index 7839462196..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/supplier_create.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-CREATE TABLE IF NOT EXISTS `supplier` (
- `s_suppkey` int(11) NOT NULL COMMENT "",
- `s_name` varchar(26) NOT NULL COMMENT "",
- `s_address` varchar(26) NOT NULL COMMENT "",
- `s_city` varchar(11) NOT NULL COMMENT "",
- `s_nation` varchar(16) NOT NULL COMMENT "",
- `s_region` varchar(13) NOT NULL COMMENT "",
- `s_phone` varchar(16) NOT NULL COMMENT ""
-)
-UNIQUE KEY (`s_suppkey`)
-DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
-PROPERTIES (
-"compression"="zstd",
-"replication_num" = "1"
-);
diff --git
a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/supplier_delete.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/supplier_delete.sql
deleted file mode 100644
index 39e663134c..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/ddl/supplier_delete.sql
+++ /dev/null
@@ -1 +0,0 @@
-truncate table `supplier`;
\ No newline at end of file
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/load.groovy
b/regression-test/suites/ssb_sf1_unique_sql_zstd/load.groovy
deleted file mode 100644
index db7104cf8e..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/load.groovy
+++ /dev/null
@@ -1,86 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements. See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership. The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License. You may obtain a copy of the License at
-//
-// http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied. See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-// Most of the cases are copied from
https://github.com/trinodb/trino/tree/master
-// /testing/trino-product-tests/src/main/resources/sql-tests/testcases
-// and modified by Doris.
-
-// Note: To filter out tables from sql files, use the following one-liner
comamnd
-// sed -nr 's/.*tables: (.*)$/\1/gp' /path/to/*.sql | sed -nr 's/,/\n/gp' |
sort | uniq
-suite("load") {
- def url =
"https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com";
- def tables = ["customer", "lineorder", "part", "date", "supplier"]
- def columns =
["""c_custkey,c_name,c_address,c_city,c_nation,c_region,c_phone,c_mktsegment,no_use""",
-
"""lo_orderkey,lo_linenumber,lo_custkey,lo_partkey,lo_suppkey,lo_orderdate,lo_orderpriority,
-
lo_shippriority,lo_quantity,lo_extendedprice,lo_ordtotalprice,lo_discount,
-
lo_revenue,lo_supplycost,lo_tax,lo_commitdate,lo_shipmode,lo_dummy""",
-
"""p_partkey,p_name,p_mfgr,p_category,p_brand,p_color,p_type,p_size,p_container,p_dummy""",
-
"""d_datekey,d_date,d_dayofweek,d_month,d_year,d_yearmonthnum,d_yearmonth,
-
d_daynuminweek,d_daynuminmonth,d_daynuminyear,d_monthnuminyear,d_weeknuminyear,
-
d_sellingseason,d_lastdayinweekfl,d_lastdayinmonthfl,d_holidayfl,d_weekdayfl,d_dummy""",
-
"""s_suppkey,s_name,s_address,s_city,s_nation,s_region,s_phone,s_dummy"""]
-
- for (String table in tables) {
- sql new File("""${context.file.parent}/ddl/${table}_create.sql""").text
- sql new File("""${context.file.parent}/ddl/${table}_delete.sql""").text
- }
- i = 0
- for (String tableName in tables) {
- String fileName =
"""${context.sf1DataPath}/ssb/sf1/${tableName}.tbl.gz"""
- if (!new File(fileName).isAbsolute()) {
- fileName = new File(context.dataPath, fileName).getAbsolutePath()
- }
- if (!new File(fileName).exists()) {
- fileName = """${url}/ssb/sf1/${tableName}.tbl.gz"""
- }
- streamLoad {
- // a default db 'regression_test' is specified in
- // ${DORIS_HOME}/conf/regression-conf.groovy
- table tableName
-
- // default label is UUID:
- // set 'label' UUID.randomUUID().toString()
-
- // default column_separator is specify in doris fe config, usually
is '\t'.
- // this line change to ','
- set 'column_separator', '|'
- set 'compress_type', 'GZ'
- set 'columns', columns[i]
- // relate to
${DORIS_HOME}/regression-test/data/demo/streamload_input.csv.
- // also, you can stream load a http stream, e.g.
http://xxx/some.csv
- file fileName
-
- time 10000 // limit inflight 10s
-
- // stream load action will check result, include Success status,
and NumberTotalRows == NumberLoadedRows
-
- // if declared a check callback, the default check condition will
ignore.
- // So you must check all condition
- check { result, exception, startTime, endTime ->
- if (exception != null) {
- throw exception
- }
- log.info("Stream load result: ${result}".toString())
- def json = parseJson(result)
- assertEquals("success", json.Status.toLowerCase())
- assertEquals(json.NumberTotalRows, json.NumberLoadedRows)
- assertTrue(json.NumberLoadedRows > 0 && json.LoadBytes > 0)
- }
- }
- i++
- }
-}
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q1.1.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q1.1.sql
deleted file mode 100644
index 4ef15e93ea..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q1.1.sql
+++ /dev/null
@@ -1,24 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT SUM(lo_extendedprice*lo_discount) AS
-REVENUE
-FROM lineorder, date
-WHERE lo_orderdate = d_datekey
-AND d_year = 1993
-AND lo_discount BETWEEN 1 AND 3
-AND lo_quantity < 25;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q1.2.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q1.2.sql
deleted file mode 100644
index 1b8442bd93..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q1.2.sql
+++ /dev/null
@@ -1,24 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT SUM(lo_extendedprice*lo_discount) AS
-REVENUE
-FROM lineorder, date
-WHERE lo_orderdate = d_datekey
-AND d_yearmonth = 'Jan1994'
-AND lo_discount BETWEEN 4 AND 6
-AND lo_quantity BETWEEN 26 AND 35;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q1.3.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q1.3.sql
deleted file mode 100644
index ed6e51b1cf..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q1.3.sql
+++ /dev/null
@@ -1,25 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT SUM(lo_extendedprice*lo_discount) AS
-REVENUE
-FROM lineorder, date
-WHERE lo_orderdate = d_datekey
-AND d_weeknuminyear= 6
-AND d_year = 1994
-AND lo_discount BETWEEN 5 AND 7
-AND lo_quantity BETWEEN 26 AND 35;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q2.1.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q2.1.sql
deleted file mode 100644
index e1a1f52d18..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q2.1.sql
+++ /dev/null
@@ -1,26 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT SUM(lo_revenue), d_year, p_brand
-FROM lineorder, date, part, supplier
-WHERE lo_orderdate = d_datekey
-AND lo_partkey = p_partkey
-AND lo_suppkey = s_suppkey
-AND p_category = 'MFGR#12'
-AND s_region = 'AMERICA'
-GROUP BY d_year, p_brand
-ORDER BY d_year, p_brand;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q2.2.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q2.2.sql
deleted file mode 100644
index 3db6170119..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q2.2.sql
+++ /dev/null
@@ -1,27 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT SUM(lo_revenue), d_year, p_brand
-FROM lineorder, date, part, supplier
-WHERE lo_orderdate = d_datekey
-AND lo_partkey = p_partkey
-AND lo_suppkey = s_suppkey
-AND p_brand BETWEEN 'MFGR#2221'
-AND 'MFGR#2228'
-AND s_region = 'ASIA'
-GROUP BY d_year, p_brand
-ORDER BY d_year, p_brand;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q2.3.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q2.3.sql
deleted file mode 100644
index b70ca90666..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q2.3.sql
+++ /dev/null
@@ -1,26 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT SUM(lo_revenue), d_year, p_brand
-FROM lineorder, date, part, supplier
-WHERE lo_orderdate = d_datekey
-AND lo_partkey = p_partkey
-AND lo_suppkey = s_suppkey
-AND p_brand = 'MFGR#2239'
-AND s_region = 'EUROPE'
-GROUP BY d_year, p_brand
-ORDER BY d_year, p_brand;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.1.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.1.sql
deleted file mode 100644
index 70f17d789b..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.1.sql
+++ /dev/null
@@ -1,28 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT c_nation, s_nation, d_year,
-SUM(lo_revenue) AS REVENUE
-FROM customer, lineorder, supplier, date
-WHERE lo_custkey = c_custkey
-AND lo_suppkey = s_suppkey
-AND lo_orderdate = d_datekey
-AND c_region = 'ASIA'
-AND s_region = 'ASIA'
-AND d_year >= 1992 AND d_year <= 1997
-GROUP BY c_nation, s_nation, d_year
-ORDER BY d_year ASC, REVENUE DESC;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.2.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.2.sql
deleted file mode 100644
index a416fbea8b..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.2.sql
+++ /dev/null
@@ -1,28 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT c_city, s_city, d_year, sum(lo_revenue)
-AS REVENUE
-FROM customer, lineorder, supplier, date
-WHERE lo_custkey = c_custkey
-AND lo_suppkey = s_suppkey
-AND lo_orderdate = d_datekey
-AND c_nation = 'UNITED STATES'
-AND s_nation = 'UNITED STATES'
-AND d_year >= 1992 AND d_year <= 1997
-GROUP BY c_city, s_city, d_year
-ORDER BY d_year ASC, REVENUE DESC;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.3.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.3.sql
deleted file mode 100644
index 98e29b72e7..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.3.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT c_city, s_city, d_year, SUM(lo_revenue)
-AS REVENUE
-FROM customer, lineorder, supplier, date
-WHERE lo_custkey = c_custkey
-AND lo_suppkey = s_suppkey
-AND lo_orderdate = d_datekey
-AND (c_city='UNITED KI1'
-OR c_city='UNITED KI5')
-AND (s_city='UNITED KI1'
-OR s_city='UNITED KI5')
-AND d_year >= 1992 AND d_year <= 1997
-GROUP BY c_city, s_city, d_year
-ORDER BY d_year ASC, REVENUE DESC;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.4.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.4.sql
deleted file mode 100644
index 65fe992ca4..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q3.4.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT c_city, s_city, d_year, SUM(lo_revenue)
-AS REVENUE
-FROM customer, lineorder, supplier, date
-WHERE lo_custkey = c_custkey
-AND lo_suppkey = s_suppkey
-AND lo_orderdate = d_datekey
-AND (c_city='UNITED KI1'
-OR c_city='UNITED KI5')
-AND (s_city='UNITED KI1'
-OR s_city='UNITED KI5')
-AND d_yearmonth = 'Dec1997'
-GROUP BY c_city, s_city, d_year
-ORDER BY d_year ASC, REVENUE DESC;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q4.1.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q4.1.sql
deleted file mode 100644
index bdcd730bf9..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q4.1.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT d_year, c_nation,
-SUM(lo_revenue - lo_supplycost) AS PROFIT
-FROM date, customer, supplier, part, lineorder
-WHERE lo_custkey = c_custkey
-AND lo_suppkey = s_suppkey
-AND lo_partkey = p_partkey
-AND lo_orderdate = d_datekey
-AND c_region = 'AMERICA'
-AND s_region = 'AMERICA'
-AND (p_mfgr = 'MFGR#1'
-OR p_mfgr = 'MFGR#2')
-GROUP BY d_year, c_nation
-ORDER BY d_year, c_nation;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q4.2.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q4.2.sql
deleted file mode 100644
index 24c82cf682..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q4.2.sql
+++ /dev/null
@@ -1,31 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT d_year, s_nation, p_category,
-SUM(lo_revenue - lo_supplycost) AS PROFIT
-FROM date, customer, supplier, part, lineorder
-WHERE lo_custkey = c_custkey
-AND lo_suppkey = s_suppkey
-AND lo_partkey = p_partkey
-AND lo_orderdate = d_datekey
-AND c_region = 'AMERICA'
-AND s_region = 'AMERICA'
-AND (d_year = 1997 OR d_year = 1998)
-AND (p_mfgr = 'MFGR#1'
-OR p_mfgr = 'MFGR#2')
-GROUP BY d_year, s_nation, p_category
-ORDER BY d_year, s_nation, p_category;
diff --git a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q4.3.sql
b/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q4.3.sql
deleted file mode 100644
index 0dcc08bd26..0000000000
--- a/regression-test/suites/ssb_sf1_unique_sql_zstd/sql/q4.3.sql
+++ /dev/null
@@ -1,29 +0,0 @@
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
-
-SELECT d_year, s_city, p_brand,
-SUM(lo_revenue - lo_supplycost) AS PROFIT
-FROM date, customer, supplier, part, lineorder
-WHERE lo_custkey = c_custkey
-AND lo_suppkey = s_suppkey
-AND lo_partkey = p_partkey
-AND lo_orderdate = d_datekey
-AND s_nation = 'UNITED STATES'
-AND (d_year = 1997 OR d_year = 1998)
-AND p_category = 'MFGR#14'
-GROUP BY d_year, s_city, p_brand
-ORDER BY d_year, s_city, p_brand;
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
