This is an automated email from the ASF dual-hosted git repository.
Gabriel39 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 2854a8f8329 [test](maxcompute) Trim MaxCompute regression cases
(#69132)
2854a8f8329 is described below
commit 2854a8f832907dd2ce559f32f18b89aedd2d0d48
Author: daidai <[email protected]>
AuthorDate: Fri Oct 16 09:35:59 2026 +0800
[test](maxcompute) Trim MaxCompute regression cases (#69132)
### What problem does this PR solve?
Problem Summary:
Trim the MC regression cases (partition_prune / all_type / timestamp /
schema) to cut their run time, and retry `USE` after `CREATE DATABASE`
in the MC write cases to avoid the transient `Unknown database` failure.
The removed queries are a subset of the previous ones, so the type
decoding and the operator coverage are kept.
### Release note
None
### Check List (For Author)
- Test
- [x] Regression test
- [ ] Unit Test
- [x] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason
Ran the trimmed schema / all_type suites against a real MaxCompute
project on a local cluster: 1 suite, 0 failed.
- Behavior changed:
- [x] No.
- [ ] Yes.
- Does this need documentation?
- [x] No.
- [ ] Yes.
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label
---
.../maxcompute/test_max_compute_all_type.out | 432 +-----
.../test_max_compute_partition_prune.out | 1388 --------------------
.../maxcompute/test_max_compute_schema.out | 74 --
.../maxcompute/test_max_compute_timestamp.out | 177 ---
.../maxcompute/test_max_compute_all_type.groovy | 99 +-
.../test_max_compute_partition_prune.groovy | 358 +++--
.../maxcompute/test_max_compute_schema.groovy | 27 -
.../maxcompute/test_max_compute_timestamp.groovy | 82 +-
.../write/test_mc_limit_split_optimization.groovy | 2 +-
.../write/test_mc_write_catalog_block_bytes.groovy | 2 +-
.../maxcompute/write/test_mc_write_ctas.groovy | 2 +-
.../maxcompute/write/test_mc_write_insert.groovy | 2 +-
.../write/test_mc_write_large_data.groovy | 2 +-
.../write/test_mc_write_partitions.groovy | 2 +-
.../write/test_mc_write_static_partitions.groovy | 2 +-
.../maxcompute/write/test_mc_write_types.groovy | 2 +-
16 files changed, 158 insertions(+), 2495 deletions(-)
diff --git
a/regression-test/data/external_table_p2/maxcompute/test_max_compute_all_type.out
b/regression-test/data/external_table_p2/maxcompute/test_max_compute_all_type.out
index 4431c7b8a58..7697b5cdbe1 100644
---
a/regression-test/data/external_table_p2/maxcompute/test_max_compute_all_type.out
+++
b/regression-test/data/external_table_p2/maxcompute/test_max_compute_all_type.out
@@ -80,7 +80,7 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
3 -7
4 -128
--- !test_5 --
+-- !test_6 --
4 -128
-- !test_7 --
@@ -102,10 +102,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
1 16
3 16
--- !test_11 --
-2 2147483647
-4 -2147483647
-
-- !test_12 --
1 -9223372036854775807
2 9223372036854775807
@@ -115,12 +111,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
-- !test_13 --
2 9223372036854775807
--- !test_14 --
-1 -9223372036854775807
-2 9223372036854775807
-3 -9223372036854775807
-4 -9223372036854775807
-
-- !test_15 --
1 -123.45
2 123.45
@@ -130,32 +120,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
-- !test_16 --
2 123.45
--- !test_17 --
-
--- !test_18 --
-1 -123.45
-3 -123.45
-4 -123.45
-
--- !test_19 --
-1 -123.45
-2 123.45
-3 -123.45
-4 -123.45
-
--- !test_20 --
-1 -123.45
-3 -123.45
-4 -123.45
-
--- !test_21 --
-1 -123.45
-3 -123.45
-4 -123.45
-
--- !test_22 --
-2 123.45
-
-- !test_23 --
1 -123456.789
2 123456.789
@@ -167,19 +131,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
3 -123456.789
4 -123456.789
--- !test_25 --
-2 123456.789
-
--- !test_26 --
-1 -123456.789
-3 -123456.789
-4 -123456.789
-
--- !test_27 --
-1 -123456.789
-3 -123456.789
-4 -123456.789
-
-- !test_28 --
1 123456789
2 123456789
@@ -200,11 +151,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
3 -1234.5678
4 -1234.5678
--- !test_32 --
-1 -1234.5678
-3 -1234.5678
-4 -1234.5678
-
-- !test_33 --
2 1234.5678
@@ -219,213 +165,78 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
3 -123456.789012
4 -123456.789012
--- !test_36 --
-2 123456.789012
-
-- !test_37 --
1 -123456789.012345700000
2 123456789.012345700000
3 -123456789.012345700000
4 -123456789.012345700000
--- !test_38 --
-1 -123456789.012345700000
-3 -123456789.012345700000
-4 -123456789.012345700000
-
--- !test_39 --
-2 123456789.012345700000
-
-- !test_40 --
1 -123456789.012345700000
2 123456789.012345700000
3 -123456789.012345700000
4 -123456789.012345700000
--- !test_41 --
-2 123456789.012345700000
-
-- !test_42 --
1 str
2 string_value
3 str
4 string_value
--- !test_43 --
-1 str
-3 str
-
-- !test_44 --
1 str
3 str
--- !test_45 --
-2 string_value
-4 string_value
-
--- !test_46 --
-1 str
-2 string_value
-3 str
-4 string_value
-
--- !test_47 --
-
-- !test_48 --
1 2024-03-25
2 2024-03-20
3 2024-03-25
4 2024-03-21
--- !test_49 --
-1 2024-03-25
-3 2024-03-25
-
-- !test_50 --
1 2024-03-25
3 2024-03-25
--- !test_51 --
-1 2024-03-25
-3 2024-03-25
-4 2024-03-21
-
-- !test_52 --
1 2024-03-25T12:00
2 2024-03-20T12:00
3 2024-03-25T12:00
4 2024-03-21T12:00
--- !test_53 --
-2 2024-03-20T12:00
-4 2024-03-21T12:00
-
-- !test_54 --
1 2024-03-25T12:00
3 2024-03-25T12:00
--- !test_55 --
-
--- !test_56 --
-2 2024-03-20T12:00
-4 2024-03-21T12:00
-
--- !test_57 --
-1 2024-03-25T12:00
-2 2024-03-20T12:00
-3 2024-03-25T12:00
-4 2024-03-21T12:00
-
-- !test_2_52 --
1 2024-03-25T04:00
2 2024-03-20T04:00
3 2024-03-25T04:00
4 2024-03-21T04:00
--- !test_2_53 --
-2 2024-03-20T04:00
-4 2024-03-21T04:00
-
--- !test_2_54 --
-1 2024-03-25T04:00
-3 2024-03-25T04:00
-
--- !test_2_55 --
-
--- !test_2_56 --
-2 2024-03-20T04:00
-4 2024-03-21T04:00
-
--- !test_2_57 --
-1 2024-03-25T04:00
-2 2024-03-20T04:00
-3 2024-03-25T04:00
-4 2024-03-21T04:00
-
-- !test_58 --
1 2024-03-25T12:00:00.123456
2 2024-03-20T12:00:00.123456
3 2024-03-25T12:00:00.123456
4 2024-03-21T12:00:00.123456
--- !test_59 --
-2 2024-03-20T12:00:00.123456
-4 2024-03-21T12:00:00.123456
-
--- !test_60 --
-1 2024-03-25T12:00:00.123456
-3 2024-03-25T12:00:00.123456
-
-- !test_61 --
--- !test_62 --
-2 2024-03-20T12:00:00.123456
-4 2024-03-21T12:00:00.123456
-
--- !test_63 --
-1 2024-03-25T12:00:00.123456
-2 2024-03-20T12:00:00.123456
-3 2024-03-25T12:00:00.123456
-4 2024-03-21T12:00:00.123456
-
-- !test_64 --
1 2024-03-25T12:00:00.123456
2 2024-03-20T12:00:00.123456
3 2024-03-25T12:00:00.123456
4 2024-03-21T12:00:00.123456
--- !test_65 --
-2 2024-03-20T12:00:00.123456
-4 2024-03-21T12:00:00.123456
-
-- !test_66 --
2 2024-03-20T12:00:00.123456
4 2024-03-21T12:00:00.123456
--- !test_67 --
-1 2024-03-25T12:00:00.123456
-3 2024-03-25T12:00:00.123456
-
--- !test_68 --
-
--- !test_69 --
-1 2024-03-25T12:00:00.123456
-2 2024-03-20T12:00:00.123456
-3 2024-03-25T12:00:00.123456
-4 2024-03-21T12:00:00.123456
-
--- !test_70 --
-1 2024-03-25T12:00:00.123456
-2 2024-03-20T12:00:00.123456
-3 2024-03-25T12:00:00.123456
-4 2024-03-21T12:00:00.123456
-
--- !test_71 --
-1 2024-03-25T12:00:00.123456
-2 2024-03-20T12:00:00.123456
-3 2024-03-25T12:00:00.123456
-4 2024-03-21T12:00:00.123456
-
--- !test_72 --
-
--- !test_73 --
-
--- !test_74 --
-1 2024-03-25T12:00:00.123456
-2 2024-03-20T12:00:00.123456
-3 2024-03-25T12:00:00.123456
-4 2024-03-21T12:00:00.123456
-
-- !test_75 --
1 char_value11111
2 char_value1
3 char_value11111
4 char_value1
--- !test_76 --
-1 char_value11111
-3 char_value11111
-
-- !test_77 --
2 char_value1
4 char_value1
@@ -434,22 +245,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
1 char_value11111
3 char_value11111
--- !test_79 --
-2 char_value1
-4 char_value1
-
--- !test_80 --
-1 char_value11111
-3 char_value11111
-
--- !test_81 --
-1 char_value11111
-2 char_value1
-3 char_value11111
-4 char_value1
-
--- !test_82 --
-
-- !test_83 --
1 char_value22222
2 char_value2
@@ -460,30 +255,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
1 char_value22222
3 char_value22222
--- !test_85 --
-2 char_value2
-4 char_value2
-
--- !test_86 --
-1 char_value22222
-3 char_value22222
-
--- !test_87 --
-2 char_value2
-4 char_value2
-
--- !test_88 --
-1 char_value22222
-3 char_value22222
-
--- !test_89 --
-1 char_value22222
-2 char_value2
-3 char_value22222
-4 char_value2
-
--- !test_90 --
-
-- !test_91 --
1 char_value33333
2 char_value3
@@ -494,30 +265,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
1 char_value33333
3 char_value33333
--- !test_93 --
-2 char_value3
-4 char_value3
-
--- !test_94 --
-1 char_value33333
-3 char_value33333
-
--- !test_95 --
-2 char_value3
-4 char_value3
-
--- !test_96 --
-1 char_value33333
-3 char_value33333
-
--- !test_97 --
-1 char_value33333
-2 char_value3
-3 char_value33333
-4 char_value3
-
--- !test_98 --
-
-- !test_99 --
1 varchar_value11111
2 varchar_value1
@@ -532,26 +279,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
2 varchar_value1
4 varchar_value1
--- !test_102 --
-1 varchar_value11111
-3 varchar_value11111
-
--- !test_103 --
-2 varchar_value1
-4 varchar_value1
-
--- !test_104 --
-1 varchar_value11111
-3 varchar_value11111
-
--- !test_105 --
-1 varchar_value11111
-2 varchar_value1
-3 varchar_value11111
-4 varchar_value1
-
--- !test_106 --
-
-- !test_107 --
1 varchar_value22222
2 varchar_value2
@@ -562,30 +289,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
1 varchar_value22222
3 varchar_value22222
--- !test_109 --
-2 varchar_value2
-4 varchar_value2
-
--- !test_110 --
-1 varchar_value22222
-3 varchar_value22222
-
--- !test_111 --
-2 varchar_value2
-4 varchar_value2
-
--- !test_112 --
-1 varchar_value22222
-3 varchar_value22222
-
--- !test_113 --
-1 varchar_value22222
-2 varchar_value2
-3 varchar_value22222
-4 varchar_value2
-
--- !test_114 --
-
-- !test_115 --
1 varchar_value33333
2 varchar_value3
@@ -596,72 +299,18 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
1 varchar_value33333
3 varchar_value33333
--- !test_117 --
-2 varchar_value3
-4 varchar_value3
-
--- !test_118 --
-1 varchar_value33333
-3 varchar_value33333
-
--- !test_119 --
-2 varchar_value3
-4 varchar_value3
-
--- !test_120 --
-1 varchar_value33333
-3 varchar_value33333
-
--- !test_121 --
-1 varchar_value33333
-2 varchar_value3
-3 varchar_value33333
-4 varchar_value3
-
--- !test_122 --
-
-- !test_123 --
1 {"key7":"value1"}
2 {"key1":"value1"}
3 {"key7":"value1"}
4 {"key1":"value1"}
--- !test_124 --
-1 {"key7":"value1"}
-2 {"key1":"value1"}
-3 {"key7":"value1"}
-4 {"key1":"value1"}
-
--- !test_125 --
-1 {"x":"y"}
-2 {"a":"b"}
-3 {"x":"y"}
-4 {"x":"y"}
-
-- !test_126 --
1 {3:20}
2 {1:10}
3 {3:20}
4 {2:20}
--- !test_127 --
-1 {3:200000000000}
-2 {1:100000000000}
-3 {3:200000000000}
-4 {2:200000000000}
-
--- !test_128 --
-1 {3.2:20.2}
-2 {1.1:10.1}
-3 {3.2:20.2}
-4 {2.2:20.2}
-
--- !test_129 --
-1 {3.2:20.2}
-2 {1.1:10.1}
-3 {3.2:20.2}
-4 {2.2:20.2}
-
-- !test_130 --
1 {0:1}
2 {1:0}
@@ -680,78 +329,18 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
3 [4, 5, 6]
4 [4, 5, 6]
--- !test_133 --
-1 [300000000000, 400000000000]
-2 [100000000000, 200000000000]
-3 [300000000000, 400000000000]
-4 [300000000000, 400000000000]
-
--- !test_134 --
-1 [3.3, 4.4]
-2 [1.1, 2.2]
-3 [3.3, 4.4]
-4 [3.3, 4.4]
-
-- !test_135 --
1 [3.123456789, 4.123456789]
2 [1.123456789, 2.123456789]
3 [3.123456789, 4.123456789]
4 [3.123456789, 4.123456789]
--- !test_136 --
-1 [0, 1]
-2 [1, 0]
-3 [0, 1]
-4 [0, 1]
-
--- !test_137 --
-1 ["varchar1", "varchar2"]
-2 ["varchar1", "varchar2"]
-3 ["varchar1", "varchar2"]
-4 ["varchar1", "varchar2"]
-
--- !test_138 --
-1 ["char1", "char2"]
-2 ["char1", "char2"]
-3 ["char1", "char2"]
-4 ["char1", "char2"]
-
-- !test_139 --
1 [3.3, 4.4]
2 [1.1, 2.2]
3 [3.3, 4.4]
4 [3.3, 4.4]
--- !test_140 --
-1 [3.45, 4.56]
-2 [1.23, 2.34]
-3 [3.45, 4.56]
-4 [3.45, 4.56]
-
--- !test_141 --
-1 [9.4567, 4.5678]
-2 [1.2345, 2.3456]
-3 [9.4567, 4.5678]
-4 [3.4567, 4.5678]
-
--- !test_142 --
-1 [6.45678901, 4.56789012]
-2 [1.23456789, 2.34567891]
-3 [6.45678901, 4.56789012]
-4 [3.45678901, 4.56789012]
-
--- !test_143 --
-1 [3.45678901, 4.56789012]
-2 [1.23456789, 2.34567891]
-3 [3.45678901, 4.56789012]
-4 [3.45678901, 4.56789012]
-
--- !test_144 --
-1 [3.45, 4.56]
-2 [1.23, 2.34]
-3 [3.45, 4.56]
-4 [3.45, 4.56]
-
-- !test_145 --
1 [3.4567890123456790, 4.5678901234567890]
2 [1.2345678901234570, 2.3456789012345680]
@@ -776,12 +365,6 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
3 {"struct_field":["value1", "value2"]}
4 {"struct_field":["value1", "value2"]}
--- !test_149 --
-1 {"struct_non_nulls_after_nulls1":-123,
"struct_non_nulls_after_nulls2":"value"}
-2 {"struct_non_nulls_after_nulls1":123,
"struct_non_nulls_after_nulls2":"value"}
-3 {"struct_non_nulls_after_nulls1":-123,
"struct_non_nulls_after_nulls2":"value"}
-4 {"struct_non_nulls_after_nulls1":-123,
"struct_non_nulls_after_nulls2":"value"}
-
-- !test_150 --
1 {"struct_field1":-123, "struct_field2":"value",
"strict_field3":{"nested_struct_field1":-123,
"nested_struct_field2":"nested_value"}}
2 {"struct_field1":123, "struct_field2":"value",
"strict_field3":{"nested_struct_field1":123,
"nested_struct_field2":"nested_value"}}
@@ -794,21 +377,8 @@ t_array_string_ending_with_nulls array<text> Yes
true \N
3 [null, "value1", "value2"]
4 [null, "value1", "value2"]
--- !test_152 --
-1 ["value1", null, "value2"]
-2 ["value1", null, "value2"]
-3 ["value1", null, "value2"]
-4 ["value1", null, "value2"]
-
-- !test_153 --
1 ["value11", "value2", null]
2 ["value1", "value2", null]
3 ["value11", "value2", null]
4 ["value1", "value2", null]
-
--- !test_154 --
-1 {"x":"y"}
-2 {"a":"b"}
-3 {"x":"y"}
-4 {"x":"y"}
-
diff --git
a/regression-test/data/external_table_p2/maxcompute/test_max_compute_partition_prune.out
b/regression-test/data/external_table_p2/maxcompute/test_max_compute_partition_prune.out
index d6c23e6b5ab..6de7cdfcabc 100644
---
a/regression-test/data/external_table_p2/maxcompute/test_max_compute_partition_prune.out
+++
b/regression-test/data/external_table_p2/maxcompute/test_max_compute_partition_prune.out
@@ -4,1374 +4,6 @@
2 Bob 2024
3 Charlie 2024
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
--- !one_partition_3_all --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-4 David 2025
-5 Eva 2025
-
--- !one_partition_4_all --
-5 Eva 2025
-
--- !one_partition_5_1 --
-3 Charlie 2024
-
--- !two_partition_1_1 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-
--- !two_partition_2_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_3_2 --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-
--- !two_partition_4_all --
-1 Alice US 1
-2 Bob US 1
-3 Charlie US 1
-4 David US 2
-5 Eva US 2
-6 Frank EU 1
-7 Grace EU 1
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !two_partition_5_1 --
-
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
--- !three_partition_1_1 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
--- !three_partition_3_3 --
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_4_2 --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-6 Frank US 2025 Q1
-
--- !three_partition_5_all --
-1 Alice US 2024 Q1
-2 Bob US 2024 Q1
-3 Charlie US 2024 Q1
-4 David US 2024 Q2
-5 Eva US 2024 Q2
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
--- !three_partition_7_7 --
-6 Frank US 2025 Q1
-7 Grace US 2025 Q2
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-12 Mia EU 2025 Q3
-13 Nina AS 2025 Q1
-14 Oscar AS 2025 Q2
-15 Paul AS 2025 Q3
-
--- !three_partition_8_2 --
-7 Grace US 2025 Q2
-
--- !one_partition_6_0 --
-
--- !two_partition_7_0 --
-
--- !two_partition_8_0 --
-
--- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
--- !one_partition_1_1 --
-1 Alice 2024
-2 Bob 2024
-3 Charlie 2024
-
--- !one_partition_2_1 --
-4 David 2025
-5 Eva 2025
-
-- !one_partition_3_all --
1 Alice 2024
2 Bob 2024
@@ -1416,20 +48,11 @@
-- !two_partition_5_1 --
--- !two_partition_6_1 --
-8 Hannah EU 2
-9 Ivy EU 2
-10 Jack EU 2
-
-- !three_partition_1_1 --
1 Alice US 2024 Q1
2 Bob US 2024 Q1
3 Charlie US 2024 Q1
--- !three_partition_2_1 --
-10 Jack EU 2025 Q2
-11 Leo EU 2025 Q2
-
-- !three_partition_3_3 --
13 Nina AS 2025 Q1
14 Oscar AS 2025 Q2
@@ -1458,10 +81,6 @@
14 Oscar AS 2025 Q2
15 Paul AS 2025 Q3
--- !three_partition_6_1 --
-8 Hannah EU 2024 Q1
-9 Ivy EU 2024 Q1
-
-- !three_partition_7_7 --
6 Frank US 2025 Q1
7 Grace US 2025 Q2
@@ -1479,11 +98,4 @@
-- !two_partition_7_0 --
--- !two_partition_8_0 --
-
-- !three_partition_9_0 --
-
--- !three_partition_10_0 --
-
--- !three_partition_11_0 --
-
diff --git
a/regression-test/data/external_table_p2/maxcompute/test_max_compute_schema.out
b/regression-test/data/external_table_p2/maxcompute/test_max_compute_schema.out
index adbcd23b668..69b6d75e035 100644
---
a/regression-test/data/external_table_p2/maxcompute/test_max_compute_schema.out
+++
b/regression-test/data/external_table_p2/maxcompute/test_max_compute_schema.out
@@ -79,43 +79,14 @@ user_info
-- !show_db_analytics --
analytics
--- !show_db_default --
-default
-
--- !show_db_information_schema --
-information_schema
-
--- !show_db_iot --
-iot
-
--- !show_db_mysql --
-mysql
-
-- !show_tb_order_detail --
order_detail
--- !show_tb_user_info --
-user_info
-
--- !show_tb_product_sales --
-product_sales
-
--- !show_tb_web_log --
-web_log
-
--- !show_tb_employee_salary --
-employee_salary
-
-- !show_par --
ds1=202510
ds1=202511
ds1=202512
--- !show_par2 --
-ds2=20251015/hour=10
-ds2=20251016/hour=09
-ds2=20251017/hour=08
-
-- !desc --
id int Yes true \N
emp_name text Yes true \N
@@ -221,67 +192,22 @@ Lucy 13500.00
1 Alice ORD001 500
2 Bob ORD002 899.9
--- !mc_join_q22 --
-1 Alice Keyboard 199.9
-2 Bob Mouse 99.5
-3 Carol Monitor 899
-4 David Laptop 5699
-
-- !mc_join_q23 --
Alice click https://site.com/page1
Bob view https://site.com/page2
Carol buy https://site.com/page3
--- !mc_join_q24 --
-Tom Keyboard 2025-10-15T10:00
-Jerry Mouse 2025-10-15T11:00
-Mike Monitor 2025-10-15T12:00
-Lucy Laptop 2025-10-15T13:00
-
--- !mc_join_q25 --
-Alice Finance 12000.00
-Bob IT 15000.50
-Carol HR 9800.00
-David IT 13500.00
-
-- !mc_join_q26 --
ORD003 120.5 Monitor 899
ORD004 350 Laptop 5699
ORD005 780 USB Cable 25
--- !mc_join_q27 --
-ORD006 https://site.com/page6 click
-
--- !mc_join_q28 --
-ORD003 Mike HR
-ORD004 Lucy IT
-
--- !mc_join_q29 --
-
-- !mc_join_q30 --
Alice Keyboard 12000.00
Bob Mouse 15000.50
Carol Monitor 9800.00
David Laptop 13500.00
--- !mc_join_q31 --
-Carol ORD003 https://site.com/page3
-
--- !mc_join_q32 --
-Lucy Laptop logout
-
--- !mc_join_q33 --
-Alice Tom Finance
-Bob Jerry IT
-Carol Mike HR
-David Lucy IT
-
--- !mc_join_q34 --
-Keyboard Finance 12000.00
-Mouse IT 15000.50
-Monitor HR 9800.00
-Laptop IT 13500.00
-
-- !mc_join_q35 --
ORD001 Keyboard Tom
ORD002 Mouse Jerry
diff --git
a/regression-test/data/external_table_p2/maxcompute/test_max_compute_timestamp.out
b/regression-test/data/external_table_p2/maxcompute/test_max_compute_timestamp.out
index 9d3aae331b4..d74ff3a3c86 100644
---
a/regression-test/data/external_table_p2/maxcompute/test_max_compute_timestamp.out
+++
b/regression-test/data/external_table_p2/maxcompute/test_max_compute_timestamp.out
@@ -43,50 +43,29 @@
-- !1_2 --
--- !1_3 --
-2023-02-02T00:00
-
-- !1_4 --
2023-02-02T00:00
-- !1_5 --
2023-02-02T00:00
--- !1_6 --
-
--- !1_7 --
-
-- !2_1 --
2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
--- !2_2 --
-
-- !2_3 --
2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-- !2_4 --
2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
--- !2_5 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
-- !2_6 --
--- !2_7 --
-
--- !2_8 --
-
--- !2_9 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
-- !2_10 --
2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-- !2_11 --
2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
--- !2_12 --
-
-- !2_13 --
-- !3_1 --
@@ -94,48 +73,25 @@
-- !3_2 --
--- !3_3 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
--- !3_4 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
-- !3_5 --
2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
--- !3_6 --
-
-- !3_7 --
--- !3_8 --
-
-- !3_9 --
2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-- !3_10 --
2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
--- !3_11 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
-- !3_12 --
--- !3_13 --
-
-- !4_1 --
2023-02-01T16:00
--- !4_2 --
-
-- !4_3 --
2023-02-01T16:00
--- !4_4 --
-2023-02-01T16:00
-
--- !4_5 --
-2023-02-01T16:00
-
-- !4_6 --
-- !4_7 --
@@ -148,27 +104,12 @@
-- !5_3 --
2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
--- !5_4 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
-- !5_5 --
2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
--- !5_6 --
-
--- !5_7 --
-
--- !5_8 --
-
--- !5_9 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
-- !5_10 --
2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
--- !5_11 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
-- !5_12 --
-- !5_13 --
@@ -178,133 +119,15 @@
-- !6_2 --
--- !6_3 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
-- !6_4 --
2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
--- !6_5 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
--- !6_6 --
-
-- !6_7 --
--- !6_8 --
-
-- !6_9 --
2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
--- !6_10 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
-- !6_11 --
2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-- !6_12 --
-
--- !6_13 --
-
--- !7_1 --
-2023-02-02T00:00
-
--- !7_2 --
-
--- !7_3 --
-2023-02-02T00:00
-
--- !7_4 --
-2023-02-02T00:00
-
--- !7_5 --
-2023-02-02T00:00
-
--- !7_6 --
-
--- !7_7 --
-
--- !8_1 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
--- !8_2 --
-
--- !8_3 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
--- !8_4 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
--- !8_5 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
--- !8_6 --
-
--- !8_7 --
-
--- !8_8 --
-
--- !8_9 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
--- !8_10 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
--- !8_11 --
-2023-02-02 00:00:00.123456+08:00 2023-02-02T00:00:00.123456
-
--- !8_12 --
-
--- !8_13 --
-
--- !9_1 --
-2023-02-01T16:00
-
--- !9_2 --
-
--- !9_3 --
-2023-02-01T16:00
-
--- !9_4 --
-2023-02-01T16:00
-
--- !9_5 --
-2023-02-01T16:00
-
--- !9_6 --
-
--- !9_7 --
-
--- !10_1 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
--- !10_2 --
-
--- !10_3 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
--- !10_4 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
--- !10_5 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
--- !10_6 --
-
--- !10_7 --
-
--- !10_8 --
-
--- !10_9 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
--- !10_10 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
--- !10_11 --
-2023-02-01 16:00:00.123456+00:00 2023-02-02T00:00:00.123456
-
--- !10_12 --
-
--- !10_13 --
-
diff --git
a/regression-test/suites/external_table_p2/maxcompute/test_max_compute_all_type.groovy
b/regression-test/suites/external_table_p2/maxcompute/test_max_compute_all_type.groovy
index f84ddb78104..4b444e3656b 100644
---
a/regression-test/suites/external_table_p2/maxcompute/test_max_compute_all_type.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/test_max_compute_all_type.groovy
@@ -349,205 +349,109 @@ suite("test_max_compute_all_type", "p2,external") {
qt_test_4 """ select id,boolean_col from ${table_name} where
boolean_col is false order by id; """
qt_test_5 """ select id,tinyint_col from ${table_name} order by id """
- qt_test_5 """ select id,tinyint_col from ${table_name} where
tinyint_col in (-127,-128) order by id """
+ qt_test_6 """ select id,tinyint_col from ${table_name} where
tinyint_col in (-127,-128) order by id """
qt_test_7 """ select id,smallint_col from ${table_name} order by id
"""
qt_test_8 """ select id,smallint_col from ${table_name} where
smallint_col > 16 order by id """
qt_test_9 """ select id,int_col from ${table_name} order by id """
qt_test_10 """ select id,int_col from ${table_name} where int_col = 16
order by id """
- qt_test_11 """ select id,int_col from ${table_name} where int_col !=
16 order by id """
qt_test_12 """ select id,bigint_col from ${table_name} order by id
"""
qt_test_13 """ select id,bigint_col from ${table_name} where
bigint_col > -9223372036854775807 order by id """
- qt_test_14 """ select id,bigint_col from ${table_name} where
bigint_col >= -9223372036854775807 order by id """
qt_test_15 """ select id,float_col from ${table_name} order by id """
qt_test_16 """ select id,float_col from ${table_name} where
round(float_col,2) > -123.45 order by id """
- qt_test_17 """ select id,float_col from ${table_name} where
round(float_col,2) < -123.45 order by id """
- qt_test_18 """ select id,float_col from ${table_name} where
round(float_col,2) = -123.45 order by id """
- qt_test_19 """ select id,float_col from ${table_name} where
round(float_col,2) >= -123.45 order by id """
- qt_test_20 """ select id,float_col from ${table_name} where
round(float_col,2) <= -123.45 order by id """
- qt_test_21 """ select id,float_col from ${table_name} where
round(float_col,2) in (-123.45,0.123) order by id """
- qt_test_22 """ select id,float_col from ${table_name} where
round(float_col,2) not in (-123.45, 0.1) order by id """
qt_test_23 """ select id,double_col from ${table_name} order by id
"""
qt_test_24 """ select id,double_col from ${table_name} where
double_col in ( -123456.789 ,0.123) order by id """
- qt_test_25 """ select id,double_col from ${table_name} where
double_col != -123456.789 order by id """
- qt_test_26 """ select id,double_col from ${table_name} where
double_col = -123456.789 order by id """
- qt_test_27 """ select id,double_col from ${table_name} where
-123456.789 = double_col order by id """
qt_test_28 """ select id,decimal_col1 from ${table_name} order by id
"""
qt_test_29 """ select id,decimal_col1 from ${table_name} where
decimal_col1 is null order by id """
qt_test_30 """ select id,decimal_col1 from ${table_name} where
decimal_col1 is not null order by id """
qt_test_31 """ select id,decimal_col2 from ${table_name} order by id
"""
- qt_test_32 """ select id,decimal_col2 from ${table_name} where
decimal_col2 = -1234.5678 order by id """
qt_test_33 """ select id,decimal_col2 from ${table_name} where
decimal_col2 != -1234.5678 order by id"""
qt_test_34 """ select id,decimal_col3 from ${table_name} order by id
"""
qt_test_35 """ select id,decimal_col3 from ${table_name} where
decimal_col3 = -123456.789012 order by id """
- qt_test_36 """ select id,decimal_col3 from ${table_name} where
decimal_col3 != -123456.789012 order by id """
qt_test_37 """ select id,decimal_col4 from ${table_name} order by id
"""
- qt_test_38 """ select id,decimal_col4 from ${table_name} where
decimal_col4 = -123456789.0123457 order by id """
- qt_test_39 """ select id,decimal_col4 from ${table_name} where
decimal_col4 != -123456789.0123457 order by id """
qt_test_40 """ select id,decimal_col4 from ${table_name} where
decimal_col4 >= -123456789.0123457 order by id """
- qt_test_41 """ select id,decimal_col4 from ${table_name} where
decimal_col4 > -123456789.0123457 order by id """
qt_test_42 """ select id,string_col from ${table_name} order by id
"""
- qt_test_43 """ select id,string_col from ${table_name} where
string_col in ("str") order by id """
qt_test_44 """ select id,string_col from ${table_name} where
string_col = "str" order by id """
- qt_test_45 """ select id,string_col from ${table_name} where
string_col != "str" order by id """
- qt_test_46 """ select id,string_col from ${table_name} where
string_col in ("str","string_value") order by id """
- qt_test_47 """ select id,string_col from ${table_name} where
string_col not in ("str","string_value") order by id """
qt_test_48 """ select id,date_col from ${table_name} order by id """
- qt_test_49 """ select id,date_col from ${table_name} where date_col
= "2024-03-25" order by id """
qt_test_50 """ select id,date_col from ${table_name} where date_col
>= "2024-03-25" order by id """
- qt_test_51 """ select id,date_col from ${table_name} where date_col
!= "2024-03-20" order by id """
sql """ set time_zone = "Asia/Shanghai" """
qt_test_52 """ select id,datetime_col from ${table_name} order by id
"""
- qt_test_53 """ select id,datetime_col from ${table_name} where
datetime_col != "2024-03-25 12:00:00" order by id """
qt_test_54 """ select id,datetime_col from ${table_name} where
datetime_col = "2024-03-25 12:00:00" order by id """
- qt_test_55 """ select id,datetime_col from ${table_name} where
datetime_col > "2024-03-25 12:00:00" order by id """
- qt_test_56 """ select id,datetime_col from ${table_name} where
datetime_col < "2024-03-25 12:00:00" order by id """
- qt_test_57 """ select id,datetime_col from ${table_name} where
datetime_col <= "2024-03-25 12:00:00" order by id """
sql """ set time_zone = "UTC" """
qt_test_2_52 """ select id,datetime_col from ${table_name} order by
id """
- qt_test_2_53 """ select id,datetime_col from ${table_name} where
datetime_col != "2024-03-25 04:00:00" order by id """
- qt_test_2_54 """ select id,datetime_col from ${table_name} where
datetime_col = "2024-03-25 04:00:00" order by id """
- qt_test_2_55 """ select id,datetime_col from ${table_name} where
datetime_col > "2024-03-25 04:00:00" order by id """
- qt_test_2_56 """ select id,datetime_col from ${table_name} where
datetime_col < "2024-03-25 04:00:00" order by id """
- qt_test_2_57 """ select id,datetime_col from ${table_name} where
datetime_col <= "2024-03-25 04:00:00" order by id """
sql """ set time_zone = "Asia/Shanghai" """
qt_test_58 """ select id,timestamp_ntz_col2 from ${table_name} order
by id """
- qt_test_59 """ select id,timestamp_ntz_col2 from ${table_name} where
timestamp_ntz_col2 != "2024-03-25 12:00:00.123456" order by id """
- qt_test_60 """ select id,timestamp_ntz_col2 from ${table_name} where
timestamp_ntz_col2 = "2024-03-25 12:00:00.123456" order by id """
qt_test_61 """ select id,timestamp_ntz_col2 from ${table_name} where
timestamp_ntz_col2 > "2024-03-25 12:00:00.123456" order by id """
- qt_test_62 """ select id,timestamp_ntz_col2 from ${table_name} where
timestamp_ntz_col2 < "2024-03-25 12:00:00.123456" order by id """
- qt_test_63 """ select id,timestamp_ntz_col2 from ${table_name} where
timestamp_ntz_col2 <= "2024-03-25 12:00:00.123456" order by id """
qt_test_64 """ select id,timestamp_ntz_col3 from ${table_name} order
by id """
- qt_test_65 """ select id,timestamp_ntz_col3 from ${table_name} where
timestamp_ntz_col3 != "2024-03-25 12:00:00.123456" order by id """
qt_test_66 """ select id,timestamp_ntz_col3 from ${table_name} where
timestamp_ntz_col3 < "2024-03-25 12:00:00.123456" order by id """
- qt_test_67 """ select id,timestamp_ntz_col3 from ${table_name} where
timestamp_ntz_col3 = "2024-03-25 12:00:00.123456" order by id """
- qt_test_68 """ select id,timestamp_ntz_col3 from ${table_name} where
timestamp_ntz_col3 > "2024-03-25 12:00:00.123456" order by id """
- qt_test_69 """ select id,timestamp_ntz_col3 from ${table_name} where
timestamp_ntz_col3 <= "2024-03-25 12:00:00.123456" order by id """
- qt_test_70 """ select id,timestamp_ntz_col3 from ${table_name} where
timestamp_ntz_col3 != "2024-03-25 12:00:00.124" order by id """
- qt_test_71 """ select id,timestamp_ntz_col3 from ${table_name} where
timestamp_ntz_col3 < "2024-03-25 12:00:00.124" order by id """
- qt_test_72 """ select id,timestamp_ntz_col3 from ${table_name} where
timestamp_ntz_col3 = "2024-03-25 12:00:00.124" order by id """
- qt_test_73 """ select id,timestamp_ntz_col3 from ${table_name} where
timestamp_ntz_col3 > "2024-03-25 12:00:00.124" order by id """
- qt_test_74 """ select id,timestamp_ntz_col3 from ${table_name} where
timestamp_ntz_col3 <= "2024-03-25 12:00:00.124" order by id """
qt_test_75 """ select id,char_col1 from ${table_name} order by id """
- qt_test_76 """ select id,char_col1 from ${table_name} where char_col1
= "char_value11111" order by id """
qt_test_77 """ select id,char_col1 from ${table_name} where char_col1
!= "char_value11111" order by id """
qt_test_78 """ select id,char_col1 from ${table_name} where char_col1
!= "char_value1" order by id """
- qt_test_79 """ select id,char_col1 from ${table_name} where char_col1
in ("char_value1") order by id """
- qt_test_80 """ select id,char_col1 from ${table_name} where char_col1
not in ("char_value1") order by id """
- qt_test_81 """ select id,char_col1 from ${table_name} where char_col1
in ("char_value1","char_value11111") order by id """
- qt_test_82 """ select id,char_col1 from ${table_name} where char_col1
not in ("char_value1","char_value11111") order by id """
qt_test_83 """ select id,char_col2 from ${table_name} order by id """
qt_test_84 """ select id,char_col2 from ${table_name} where char_col2
= "char_value22222" order by id """
- qt_test_85 """ select id,char_col2 from ${table_name} where char_col2
!= "char_value22222" order by id """
- qt_test_86 """ select id,char_col2 from ${table_name} where char_col2
!= "char_value2" order by id """
- qt_test_87 """ select id,char_col2 from ${table_name} where char_col2
in ("char_value2") order by id """
- qt_test_88 """ select id,char_col2 from ${table_name} where char_col2
not in ("char_value2") order by id """
- qt_test_89 """ select id,char_col2 from ${table_name} where char_col2
in ("char_value2","char_value22222") order by id """
- qt_test_90 """ select id,char_col2 from ${table_name} where char_col2
not in ("char_value2","char_value22222") order by id """
qt_test_91 """ select id,char_col3 from ${table_name} order by id """
qt_test_92 """ select id,char_col3 from ${table_name} where char_col3
= "char_value33333" order by id """
- qt_test_93 """ select id,char_col3 from ${table_name} where char_col3
!= "char_value33333" order by id """
- qt_test_94 """ select id,char_col3 from ${table_name} where char_col3
!= "char_value3" order by id """
- qt_test_95 """ select id,char_col3 from ${table_name} where char_col3
in ("char_value3") order by id """
- qt_test_96 """ select id,char_col3 from ${table_name} where char_col3
not in ("char_value3") order by id """
- qt_test_97 """ select id,char_col3 from ${table_name} where char_col3
in ("char_value3","char_value33333") order by id """
- qt_test_98 """ select id,char_col3 from ${table_name} where char_col3
not in ("char_value3","char_value33333") order by id """
qt_test_99 """ select id,varchar_col1 from ${table_name} order by id
"""
qt_test_100 """ select id,varchar_col1 from ${table_name} where
varchar_col1 = "varchar_value11111" order by id """
qt_test_101 """ select id,varchar_col1 from ${table_name} where
varchar_col1 != "varchar_value11111" order by id """
- qt_test_102 """ select id,varchar_col1 from ${table_name} where
varchar_col1 != "varchar_value1" order by id """
- qt_test_103 """ select id,varchar_col1 from ${table_name} where
varchar_col1 in ("varchar_value1") order by id """
- qt_test_104 """ select id,varchar_col1 from ${table_name} where
varchar_col1 not in ("varchar_value1") order by id """
- qt_test_105 """ select id,varchar_col1 from ${table_name} where
varchar_col1 in ("varchar_value1","varchar_value11111") order by id """
- qt_test_106 """ select id,varchar_col1 from ${table_name} where
varchar_col1 not in ("varchar_value1","varchar_value11111") order by id """
qt_test_107 """ select id,varchar_col2 from ${table_name} order by id
"""
qt_test_108 """ select id,varchar_col2 from ${table_name} where
varchar_col2 = "varchar_value22222" order by id """
- qt_test_109 """ select id,varchar_col2 from ${table_name} where
varchar_col2 != "varchar_value22222" order by id """
- qt_test_110 """ select id,varchar_col2 from ${table_name} where
varchar_col2 != "varchar_value2" order by id """
- qt_test_111 """ select id,varchar_col2 from ${table_name} where
varchar_col2 in ("varchar_value2") order by id """
- qt_test_112 """ select id,varchar_col2 from ${table_name} where
varchar_col2 not in ("varchar_value2") order by id """
- qt_test_113 """ select id,varchar_col2 from ${table_name} where
varchar_col2 in ("varchar_value2","varchar_value22222") order by id """
- qt_test_114 """ select id,varchar_col2 from ${table_name} where
varchar_col2 not in ("varchar_value2","varchar_value22222") order by id """
qt_test_115 """ select id,varchar_col3 from ${table_name} order by id
"""
qt_test_116 """ select id,varchar_col3 from ${table_name} where
varchar_col3 = "varchar_value33333" order by id """
- qt_test_117 """ select id,varchar_col3 from ${table_name} where
varchar_col3 != "varchar_value33333" order by id """
- qt_test_118 """ select id,varchar_col3 from ${table_name} where
varchar_col3 != "varchar_value3" order by id """
- qt_test_119 """ select id,varchar_col3 from ${table_name} where
varchar_col3 in ("varchar_value3") order by id """
- qt_test_120 """ select id,varchar_col3 from ${table_name} where
varchar_col3 not in ("varchar_value3") order by id """
- qt_test_121 """ select id,varchar_col3 from ${table_name} where
varchar_col3 in ("varchar_value3","varchar_value33333") order by id """
- qt_test_122 """ select id,varchar_col3 from ${table_name} where
varchar_col3 not in ("varchar_value3","varchar_value33333") order by id """
qt_test_123 """ select id,t_map_string from ${table_name} order by id
"""
- qt_test_124 """ select id,t_map_varchar from ${table_name} order by id
"""
- qt_test_125 """ select id,t_map_char from ${table_name} order by id """
qt_test_126 """ select id,t_map_int from ${table_name} order by id """
- qt_test_127 """ select id,t_map_bigint from ${table_name} order by id
"""
- qt_test_128 """ select id,t_map_float from ${table_name} order by id
"""
- qt_test_129 """ select id,t_map_double from ${table_name} order by id
"""
qt_test_130 """ select id,t_map_boolean from ${table_name} order by id
"""
qt_test_131 """ select id,t_array_string from ${table_name} order by
id """
qt_test_132 """ select id,t_array_int from ${table_name} order by id
"""
- qt_test_133 """ select id,t_array_bigint from ${table_name} order by
id """
- qt_test_134 """ select id,t_array_float from ${table_name} order by id
"""
qt_test_135 """ select id,t_array_double from ${table_name} order by
id """
- qt_test_136 """ select id,t_array_boolean from ${table_name} order by
id """
- qt_test_137 """ select id,t_array_varchar from ${table_name} order by
id """
- qt_test_138 """ select id,t_array_char from ${table_name} order by id
"""
qt_test_139 """ select id,t_array_decimal_precision_2 from
${table_name} order by id """
- qt_test_140 """ select id,t_array_decimal_precision_4 from
${table_name} order by id """
- qt_test_141 """ select id,t_array_decimal_precision_8 from
${table_name} order by id """
- qt_test_142 """ select id,t_array_decimal_precision_17 from
${table_name} order by id """
- qt_test_143 """ select id,t_array_decimal_precision_18 from
${table_name} order by id """
- qt_test_144 """ select id,t_array_decimal_precision_4 from
${table_name} order by id """
qt_test_145 """ select id,t_array_decimal_precision_38 from
${table_name} order by id """
qt_test_146 """ select id,t_struct_bigint from ${table_name} order by
id """
qt_test_147 """ select id,t_complex from ${table_name} order by id """
qt_test_148 """ select id,t_struct_nested from ${table_name} order by
id """
- qt_test_149 """ select id,t_struct_non_nulls_after_nulls from
${table_name} order by id """
qt_test_150 """ select id,t_nested_struct_non_nulls_after_nulls from
${table_name} order by id """
qt_test_151 """ select id,t_array_string_starting_with_nulls from
${table_name} order by id """
- qt_test_152 """ select id,t_array_string_with_nulls_in_between from
${table_name} order by id """
qt_test_153 """ select id,t_array_string_ending_with_nulls from
${table_name} order by id """
- qt_test_154 """ select id,t_map_char from ${table_name} order by id """
@@ -555,4 +459,3 @@ suite("test_max_compute_all_type", "p2,external") {
sql """drop catalog ${mc_catalog_name};"""
}
}
-
diff --git
a/regression-test/suites/external_table_p2/maxcompute/test_max_compute_partition_prune.groovy
b/regression-test/suites/external_table_p2/maxcompute/test_max_compute_partition_prune.groovy
index db07df02cc8..bee93310576 100644
---
a/regression-test/suites/external_table_p2/maxcompute/test_max_compute_partition_prune.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/test_max_compute_partition_prune.groovy
@@ -87,7 +87,6 @@ suite("test_max_compute_partition_prune", "p2,external") {
def one_partition_1_1 = """SELECT * FROM one_partition_tb WHERE part1 =
2024 ORDER BY id;"""
- def one_partition_2_1 = """SELECT * FROM one_partition_tb WHERE part1 =
2025 ORDER BY id;"""
def one_partition_3_all = """SELECT * FROM one_partition_tb ORDER BY id;"""
def one_partition_4_all = """SELECT * FROM one_partition_tb WHERE id = 5
ORDER BY id;"""
def one_partition_5_1 = """SELECT * FROM one_partition_tb WHERE part1 =
2024 AND id >= 3 ORDER BY id;"""
@@ -97,14 +96,11 @@ suite("test_max_compute_partition_prune", "p2,external") {
def two_partition_3_2 = """SELECT * FROM two_partition_tb WHERE part1 =
'US' ORDER BY id;"""
def two_partition_4_all = """SELECT * FROM two_partition_tb ORDER BY id;"""
def two_partition_5_1 = """SELECT * FROM two_partition_tb WHERE part1 =
'US' AND part2 = 2 AND id > 5 ORDER BY id;"""
- def two_partition_6_1 = """SELECT * FROM two_partition_tb WHERE part1 =
'EU' AND part2 = 2 ORDER BY id;"""
def three_partition_1_1 = """SELECT * FROM three_partition_tb WHERE part1
= 'US' AND part2 = 2024 AND part3 = 'Q1' ORDER BY id;"""
- def three_partition_2_1 = """SELECT * FROM three_partition_tb WHERE part1
= 'EU' AND part2 = 2025 AND part3 = 'Q2' ORDER BY id;"""
def three_partition_3_3 = """SELECT * FROM three_partition_tb WHERE part1
= 'AS' AND part2 = 2025 ORDER BY id;"""
def three_partition_4_2 = """SELECT * FROM three_partition_tb WHERE part1
= 'US' AND part3 = 'Q1' ORDER BY id;"""
def three_partition_5_all = """SELECT * FROM three_partition_tb ORDER BY
id;"""
- def three_partition_6_1 = """SELECT * FROM three_partition_tb WHERE part1
= 'EU' AND part2 = 2024 AND part3 = 'Q1' ORDER BY id;"""
def three_partition_7_7 = """SELECT * FROM three_partition_tb WHERE part2
= 2025 ORDER BY id;"""
def three_partition_8_2 = """SELECT * FROM three_partition_tb WHERE part1
= 'US' AND part3 = 'Q2' AND id BETWEEN 6 AND 10 ORDER BY id;"""
@@ -117,213 +113,153 @@ suite("test_max_compute_partition_prune",
"p2,external") {
String mc_catalog_name = "test_max_compute_partition_prune"
- for (String enable_profile : ["true","false"] ) {
- sql """set enable_profile = ${enable_profile} """;
- sql """set fetch_splits_max_wait_time_ms = 10000 """;
-
- for (String num_partitions : ["1","10","100"] ) {
- sql "set num_partitions_in_batch_mode = ${num_partitions} "
-
- for (String cross_partition : ["true","false"] ) {
-
- sql """drop catalog if exists ${mc_catalog_name};"""
- sql """
- create catalog if not exists ${mc_catalog_name}
properties (
- "type" = "max_compute",
- "mc.default.project" = "${mc_db}",
- "mc.access_key" = "${ak}",
- "mc.secret_key" = "${sk}",
- "mc.endpoint" =
"http://service.cn-beijing-vpc.maxcompute.aliyun-inc.com/api";,
- "mc.split_cross_partition" = "${cross_partition}"
- );
- """
- sql """ switch ${mc_catalog_name} """
- sql """ use ${mc_db}"""
-
- qt_one_partition_1_1 one_partition_1_1
- explain {
- sql("${one_partition_1_1}")
- contains "partition=1/2"
- // VPluginDrivenScanNode surfaces the backing
connector/catalog type
- contains "CONNECTOR: max_compute"
- }
-
- qt_one_partition_2_1 one_partition_2_1
- explain {
- sql("${one_partition_2_1}")
- contains "partition=1/2"
- }
-
- qt_one_partition_3_all one_partition_3_all
- explain {
- sql("${one_partition_3_all}")
- contains "partition=2/2"
- }
-
- qt_one_partition_4_all one_partition_4_all
- explain {
- sql("${one_partition_4_all}")
- contains "partition=2/2"
- }
-
- qt_one_partition_5_1 one_partition_5_1
- explain {
- sql("${one_partition_5_1}")
- contains "partition=1/2"
- }
-
-
- qt_two_partition_1_1 two_partition_1_1
- explain {
- sql("${two_partition_1_1}")
- contains "partition=1/4"
- }
-
- qt_two_partition_2_1 two_partition_2_1
- explain {
- sql("${two_partition_2_1}")
- contains "partition=1/4"
- }
-
- qt_two_partition_3_2 two_partition_3_2
- explain {
- sql("${two_partition_3_2}")
- contains "partition=2/4"
- }
-
- qt_two_partition_4_all two_partition_4_all
- explain {
- sql("${two_partition_4_all}")
- contains "partition=4/4"
- }
-
- qt_two_partition_5_1 two_partition_5_1
- explain {
- sql("${two_partition_5_1}")
- contains "partition=1/4"
- }
-
- qt_two_partition_6_1 two_partition_6_1
- explain {
- sql("${two_partition_6_1}")
- contains "partition=1/4"
- }
-
-
-
- qt_three_partition_1_1 three_partition_1_1
- explain {
- sql("${three_partition_1_1}")
- contains "partition=1/10"
- }
-
- qt_three_partition_2_1 three_partition_2_1
- explain {
- sql("${three_partition_2_1}")
- contains "partition=1/10"
- }
-
- qt_three_partition_3_3 three_partition_3_3
- explain {
- sql("${three_partition_3_3}")
- contains "partition=3/10"
- }
-
- qt_three_partition_4_2 three_partition_4_2
- explain {
- sql("${three_partition_4_2}")
- contains "partition=2/10"
- }
-
- qt_three_partition_5_all three_partition_5_all
- explain {
- sql("${three_partition_5_all}")
- contains "partition=10/10"
- }
-
- qt_three_partition_6_1 three_partition_6_1
- explain {
- sql("${three_partition_6_1}")
- contains "partition=1/10"
- }
-
- qt_three_partition_7_7 three_partition_7_7
- explain {
- sql("${three_partition_7_7}")
- contains "partition=7/10"
- }
-
- qt_three_partition_8_2 three_partition_8_2
- explain {
- sql("${three_partition_8_2}")
- contains "partition=2/10"
- }
-
-
- // 0 partitions
- def one_partition_6_0 = """SELECT * FROM one_partition_tb
WHERE part1 = 2023 ORDER BY id;"""
- qt_one_partition_6_0 one_partition_6_0
- explain {
- sql("${one_partition_6_0}")
- contains "partition=0/2"
- }
-
- def two_partition_7_0 = """SELECT * FROM two_partition_tb
WHERE part1 = 'CN' AND part2 = 1 ORDER BY id;"""
- qt_two_partition_7_0 two_partition_7_0
- explain {
- sql("${two_partition_7_0}")
- contains "partition=0/4"
- }
-
- def two_partition_8_0 = """SELECT * FROM two_partition_tb
WHERE part1 = 'US' AND part2 = 3 ORDER BY id;"""
- qt_two_partition_8_0 two_partition_8_0
- explain {
- sql("${two_partition_8_0}")
- contains "partition=0/4"
- }
-
- def three_partition_9_0 = """SELECT * FROM
three_partition_tb WHERE part1 = 'US' AND part2 = 2023 AND part3 = 'Q1' ORDER
BY id;"""
- qt_three_partition_9_0 three_partition_9_0
- explain {
- sql("${three_partition_9_0}")
- contains "partition=0/10"
- }
-
- def three_partition_10_0 = """SELECT * FROM
three_partition_tb WHERE part1 = 'EU' AND part2 = 2024 AND part3 = 'Q4' ORDER
BY id;"""
- qt_three_partition_10_0 three_partition_10_0
- explain {
- sql("${three_partition_10_0}")
- contains "partition=0/10"
- }
-
- def three_partition_11_0 = """SELECT * FROM
three_partition_tb WHERE part1 = 'AS' AND part2 = 2025 AND part3 = 'Q4' ORDER
BY id;"""
- qt_three_partition_11_0 three_partition_11_0
- explain {
- sql("${three_partition_11_0}")
- contains "partition=0/10"
- }
-
- // FIX-NONPART-PRUNE-DATALOSS truth-gate: a filtered query
over a NON-partitioned
- // table must return its matching rows, NOT zero. Before
the fix
- // (supportInternalPartitionPruned gated on partition
columns) PruneFileScanPartition
- // overwrote the selection with isPruned=true+empty for
non-partitioned tables, so
- // PluginDrivenScanNode short-circuited to no splits and
these queries silently
- // returned 0 rows. Asserted directly (no .out dependency)
so the count is unambiguous.
- def no_part_filtered = sql """SELECT id, name FROM
no_partition_tb WHERE id = 5;"""
- assertEquals(1, no_part_filtered.size(),
- "non-partitioned MC table WHERE id=5 must return
exactly its 1 matching row, "
- + "not zero (FIX-NONPART-PRUNE-DATALOSS)")
- assertEquals("5", no_part_filtered[0][0].toString())
-
- def no_part_range = sql """SELECT id FROM no_partition_tb
WHERE id >= 3 ORDER BY id;"""
- assertEquals(3, no_part_range.size(),
- "non-partitioned MC table WHERE id>=3 must return
3 rows (id 3,4,5), not zero")
-
- def no_part_all = sql """SELECT id FROM no_partition_tb
ORDER BY id;"""
- assertEquals(5, no_part_all.size(),
- "non-partitioned MC table full scan must return
all 5 rows")
- }
- }
+ sql """drop catalog if exists ${mc_catalog_name};"""
+ sql """
+ create catalog if not exists ${mc_catalog_name} properties (
+ "type" = "max_compute",
+ "mc.default.project" = "${mc_db}",
+ "mc.access_key" = "${ak}",
+ "mc.secret_key" = "${sk}",
+ "mc.endpoint" =
"http://service.cn-beijing-vpc.maxcompute.aliyun-inc.com/api";
+ );
+ """
+ sql """ switch ${mc_catalog_name} """
+ sql """ use ${mc_db}"""
+
+ qt_one_partition_1_1 one_partition_1_1
+ explain {
+ sql("${one_partition_1_1}")
+ contains "partition=1/2"
+ // VPluginDrivenScanNode surfaces the backing connector/catalog
type
+ contains "CONNECTOR: max_compute"
}
+
+ qt_one_partition_3_all one_partition_3_all
+ explain {
+ sql("${one_partition_3_all}")
+ contains "partition=2/2"
+ }
+
+ qt_one_partition_4_all one_partition_4_all
+ explain {
+ sql("${one_partition_4_all}")
+ contains "partition=2/2"
+ }
+
+ qt_one_partition_5_1 one_partition_5_1
+ explain {
+ sql("${one_partition_5_1}")
+ contains "partition=1/2"
+ }
+
+
+ qt_two_partition_1_1 two_partition_1_1
+ explain {
+ sql("${two_partition_1_1}")
+ contains "partition=1/4"
+ }
+
+ qt_two_partition_2_1 two_partition_2_1
+ explain {
+ sql("${two_partition_2_1}")
+ contains "partition=1/4"
+ }
+
+ qt_two_partition_3_2 two_partition_3_2
+ explain {
+ sql("${two_partition_3_2}")
+ contains "partition=2/4"
+ }
+
+ qt_two_partition_4_all two_partition_4_all
+ explain {
+ sql("${two_partition_4_all}")
+ contains "partition=4/4"
+ }
+
+ qt_two_partition_5_1 two_partition_5_1
+ explain {
+ sql("${two_partition_5_1}")
+ contains "partition=1/4"
+ }
+
+ qt_three_partition_1_1 three_partition_1_1
+ explain {
+ sql("${three_partition_1_1}")
+ contains "partition=1/10"
+ }
+
+ qt_three_partition_3_3 three_partition_3_3
+ explain {
+ sql("${three_partition_3_3}")
+ contains "partition=3/10"
+ }
+
+ qt_three_partition_4_2 three_partition_4_2
+ explain {
+ sql("${three_partition_4_2}")
+ contains "partition=2/10"
+ }
+
+ qt_three_partition_5_all three_partition_5_all
+ explain {
+ sql("${three_partition_5_all}")
+ contains "partition=10/10"
+ }
+
+ qt_three_partition_7_7 three_partition_7_7
+ explain {
+ sql("${three_partition_7_7}")
+ contains "partition=7/10"
+ }
+
+ qt_three_partition_8_2 three_partition_8_2
+ explain {
+ sql("${three_partition_8_2}")
+ contains "partition=2/10"
+ }
+
+
+ // 0 partitions
+ def one_partition_6_0 = """SELECT * FROM one_partition_tb WHERE part1
= 2023 ORDER BY id;"""
+ qt_one_partition_6_0 one_partition_6_0
+ explain {
+ sql("${one_partition_6_0}")
+ contains "partition=0/2"
+ }
+
+ def two_partition_7_0 = """SELECT * FROM two_partition_tb WHERE part1
= 'CN' AND part2 = 1 ORDER BY id;"""
+ qt_two_partition_7_0 two_partition_7_0
+ explain {
+ sql("${two_partition_7_0}")
+ contains "partition=0/4"
+ }
+
+ def three_partition_9_0 = """SELECT * FROM three_partition_tb WHERE
part1 = 'US' AND part2 = 2023 AND part3 = 'Q1' ORDER BY id;"""
+ qt_three_partition_9_0 three_partition_9_0
+ explain {
+ sql("${three_partition_9_0}")
+ contains "partition=0/10"
+ }
+
+ // FIX-NONPART-PRUNE-DATALOSS truth-gate: a filtered query over a
NON-partitioned
+ // table must return its matching rows, NOT zero. Before the fix
+ // (supportInternalPartitionPruned gated on partition columns)
PruneFileScanPartition
+ // overwrote the selection with isPruned=true+empty for
non-partitioned tables, so
+ // PluginDrivenScanNode short-circuited to no splits and these queries
silently
+ // returned 0 rows. Asserted directly (no .out dependency) so the
count is unambiguous.
+ def no_part_filtered = sql """SELECT id, name FROM no_partition_tb
WHERE id = 5;"""
+ assertEquals(1, no_part_filtered.size(),
+ "non-partitioned MC table WHERE id=5 must return exactly its 1
matching row, "
+ + "not zero (FIX-NONPART-PRUNE-DATALOSS)")
+ assertEquals("5", no_part_filtered[0][0].toString())
+
+ def no_part_range = sql """SELECT id FROM no_partition_tb WHERE id >=
3 ORDER BY id;"""
+ assertEquals(3, no_part_range.size(),
+ "non-partitioned MC table WHERE id>=3 must return 3 rows (id
3,4,5), not zero")
+
+ def no_part_all = sql """SELECT id FROM no_partition_tb ORDER BY id;"""
+ assertEquals(5, no_part_all.size(),
+ "non-partitioned MC table full scan must return all 5 rows")
}
}
diff --git
a/regression-test/suites/external_table_p2/maxcompute/test_max_compute_schema.groovy
b/regression-test/suites/external_table_p2/maxcompute/test_max_compute_schema.groovy
index bb283936fa5..edb06514de2 100644
---
a/regression-test/suites/external_table_p2/maxcompute/test_max_compute_schema.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/test_max_compute_schema.groovy
@@ -147,30 +147,13 @@ suite("test_max_compute_schema", "p2,external") {
qt_mc_old_q2 """ SELECT * FROM order_detail ORDER BY id;"""
sql """ alter catalog ${mc_catalog_name} set
PROPERTIES("mc.enable.namespace.schema" = "true"); """
-
-
order_qt_show_db_analytics """ show databases like "analytics"; """
- order_qt_show_db_default """ show databases like "default"; """
- order_qt_show_db_information_schema """ show databases like
"information\\_schema"; """
- order_qt_show_db_iot """ show databases like "iot"; """
- order_qt_show_db_mysql """ show databases like "mysql"; """
sql """ use `default`; """
order_qt_show_tb_order_detail """ show tables like "order\\_detail";
"""
- order_qt_show_tb_user_info """ show tables like "user\\_info"; """
-
-
- sql """ use `analytics`; """
- order_qt_show_tb_product_sales """ show tables like "product\\_sales";
"""
- order_qt_show_tb_web_log """ show tables like "web\\_log"; """
-
-
- sql """ use `iot`; """
- order_qt_show_tb_employee_salary """ show tables like
"employee\\_salary"; """
order_qt_show_par """ show partitions from `default`.order_detail; """
- order_qt_show_par2 """ show partitions from analytics.web_log; """
qt_desc """ desc iot.employee_salary; """
@@ -237,19 +220,9 @@ suite("test_max_compute_schema", "p2,external") {
qt_mc_q20 """SELECT * FROM iot.employee_salary WHERE salary BETWEEN
9000 AND 16000 ORDER BY id;"""
qt_mc_join_q21 """SELECT u.id, u.name, o.order_id, o.amount FROM
`default`.user_info u JOIN `default`.order_detail o ON u.name=o.buyer WHERE
o.ds1='202510' ORDER BY u.id;"""
- qt_mc_join_q22 """SELECT u.id, u.name, p.product_name, p.price FROM
`default`.user_info u JOIN analytics.product_sales p ON u.id=p.id ORDER BY
u.id;"""
qt_mc_join_q23 """SELECT u.name, w.action, w.url FROM
`default`.user_info u JOIN analytics.web_log w ON u.id=w.user_id-1000 WHERE
w.ds2='20251015' AND w.hour='10' ORDER BY u.id;"""
- qt_mc_join_q24 """SELECT e.emp_name, p.product_name, p.sale_time FROM
iot.employee_salary e JOIN analytics.product_sales p ON e.id=p.id ORDER BY
e.id;"""
- qt_mc_join_q25 """SELECT u.name, e.department, e.salary FROM
`default`.user_info u JOIN iot.employee_salary e ON u.id=e.id ORDER BY u.id;"""
qt_mc_join_q26 """SELECT o.order_id, o.amount, p.product_name,
p.price FROM `default`.order_detail o JOIN analytics.product_sales p ON
o.id=p.id WHERE o.ds1='202511' ORDER BY o.id;"""
- qt_mc_join_q27 """SELECT o.order_id, w.url, w.action FROM
`default`.order_detail o JOIN analytics.web_log w ON o.id=w.id WHERE
o.ds1='202512' AND w.ds2='20251016' AND w.hour='09' ORDER BY o.id;"""
- qt_mc_join_q28 """SELECT o.order_id, e.emp_name, e.department FROM
`default`.order_detail o JOIN iot.employee_salary e ON o.id=e.id WHERE
o.ds1='202511' ORDER BY o.id;"""
- qt_mc_join_q29 """SELECT p.product_name, w.url, w.action FROM
analytics.product_sales p JOIN analytics.web_log w ON p.id=w.id WHERE
w.ds2='20251017' AND w.hour='08' ORDER BY p.id;"""
qt_mc_join_q30 """SELECT u.name, p.product_name, e.salary FROM
`default`.user_info u JOIN analytics.product_sales p ON u.id=p.id JOIN
iot.employee_salary e ON u.id=e.id ORDER BY u.id;"""
- qt_mc_join_q31 """SELECT u.name, o.order_id, w.url FROM
`default`.user_info u JOIN `default`.order_detail o ON u.id=o.id JOIN
analytics.web_log w ON u.id=w.id WHERE o.ds1='202511' AND w.ds2='20251015' AND
w.hour='10' ORDER BY u.id;"""
- qt_mc_join_q32 """SELECT e.emp_name, p.product_name, w.action FROM
iot.employee_salary e JOIN analytics.product_sales p ON e.id=p.id JOIN
analytics.web_log w ON e.id=w.id WHERE w.ds2='20251016' AND w.hour='09' ORDER
BY e.id;"""
- qt_mc_join_q33 """SELECT u.name, e.emp_name, e.department FROM
`default`.user_info u JOIN iot.employee_salary e ON u.id=e.id ORDER BY u.id;"""
- qt_mc_join_q34 """SELECT p.product_name, e.department, e.salary FROM
analytics.product_sales p JOIN iot.employee_salary e ON p.id=e.id ORDER BY
p.id;"""
qt_mc_join_q35 """SELECT o.order_id, p.product_name, e.emp_name FROM
`default`.order_detail o JOIN analytics.product_sales p ON o.id=p.id JOIN
iot.employee_salary e ON o.id=e.id WHERE o.ds1='202510' ORDER BY o.id;"""
}
}
diff --git
a/regression-test/suites/external_table_p2/maxcompute/test_max_compute_timestamp.groovy
b/regression-test/suites/external_table_p2/maxcompute/test_max_compute_timestamp.groovy
index 7d23c40e1f6..a80e687218d 100644
---
a/regression-test/suites/external_table_p2/maxcompute/test_max_compute_timestamp.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/test_max_compute_timestamp.groovy
@@ -115,52 +115,34 @@ suite("test_max_compute_timestamp", "p2,external") {
sql """ set time_zone = "Asia/Shanghai" """
qt_1_1 """ select * from datetime_tb1;"""
qt_1_2 """ select * from datetime_tb1 where col1 > "2023-02-02
00:00:00.000";"""
- qt_1_3 """ select * from datetime_tb1 where col1 >= "2023-02-02
00:00:00.000";"""
qt_1_4 """ select * from datetime_tb1 where col1 = "2023-02-02
00:00:00.000";"""
qt_1_5 """ select * from datetime_tb1 where col1 <= "2023-02-02
00:00:00.000";"""
- qt_1_6 """ select * from datetime_tb1 where col1 < "2023-02-02
00:00:00.000";"""
- qt_1_7 """ select * from datetime_tb1 where col1 != "2023-02-02
00:00:00.000";"""
qt_2_1 """select * from timestamp_tb1;"""
- qt_2_2 """select * from timestamp_tb1 where col1 > "2023-02-02
00:00:00.123456";"""
qt_2_3 """select * from timestamp_tb1 where col1 >= "2023-02-02
00:00:00.123456";"""
qt_2_4 """select * from timestamp_tb1 where col1 = "2023-02-02
00:00:00.123456";"""
- qt_2_5 """select * from timestamp_tb1 where col1 <= "2023-02-02
00:00:00.123456";"""
qt_2_6 """select * from timestamp_tb1 where col1 < "2023-02-02
00:00:00.123456";"""
- qt_2_7 """select * from timestamp_tb1 where col1 != "2023-02-02
00:00:00.123456"; """
- qt_2_8 """ select * from timestamp_tb1 where col2 > "2023-02-02
00:00:00.123456"; """
- qt_2_9 """ select * from timestamp_tb1 where col2 >= "2023-02-02
00:00:00.123456"; """
qt_2_10 """ select * from timestamp_tb1 where col2 = "2023-02-02
00:00:00.123456"; """
qt_2_11 """ select * from timestamp_tb1 where col2 <= "2023-02-02
00:00:00.123456"; """
- qt_2_12 """ select * from timestamp_tb1 where col2 < "2023-02-02
00:00:00.123456"; """
qt_2_13 """ select * from timestamp_tb1 where col2 != "2023-02-02
00:00:00.123456"; """
qt_3_1 """ select * from timestamp_tb2;"""
qt_3_2 """ select * from timestamp_tb2 where col1 > "2023-02-02
00:00:00.123456";"""
- qt_3_3 """ select * from timestamp_tb2 where col1 >= "2023-02-02
00:00:00.123456";"""
- qt_3_4 """ select * from timestamp_tb2 where col1 = "2023-02-02
00:00:00.123456";"""
qt_3_5 """ select * from timestamp_tb2 where col1 <= "2023-02-02
00:00:00.123456";"""
- qt_3_6 """ select * from timestamp_tb2 where col1 < "2023-02-02
00:00:00.123456";"""
qt_3_7 """ select * from timestamp_tb2 where col1 != "2023-02-02
00:00:00.123456";"""
- qt_3_8 """ select * from timestamp_tb2 where col2 > "2023-02-02
00:00:00.123456";"""
qt_3_9 """ select * from timestamp_tb2 where col2 >= "2023-02-02
00:00:00.123456";"""
qt_3_10 """ select * from timestamp_tb2 where col2 = "2023-02-02
00:00:00.123456";"""
- qt_3_11 """ select * from timestamp_tb2 where col2 <= "2023-02-02
00:00:00.123456";"""
qt_3_12 """ select * from timestamp_tb2 where col2 < "2023-02-02
00:00:00.123456";"""
- qt_3_13 """ select * from timestamp_tb2 where col2 != "2023-02-02
00:00:00.123456";"""
sql """ set time_zone = "UTC" """
qt_4_1 """ select * from datetime_tb1;"""
- qt_4_2 """ select * from datetime_tb1 where col1 > "2023-02-01
16:00:00.000";"""
qt_4_3 """ select * from datetime_tb1 where col1 >= "2023-02-01
16:00:00.000";"""
- qt_4_4 """ select * from datetime_tb1 where col1 = "2023-02-01
16:00:00.000";"""
- qt_4_5 """ select * from datetime_tb1 where col1 <= "2023-02-01
16:00:00.000";"""
qt_4_6 """ select * from datetime_tb1 where col1 < "2023-02-01
16:00:00.000";"""
qt_4_7 """ select * from datetime_tb1 where col1 != "2023-02-01
16:00:00.000";"""
@@ -168,15 +150,9 @@ suite("test_max_compute_timestamp", "p2,external") {
qt_5_1 """select * from timestamp_tb1;"""
qt_5_2 """select * from timestamp_tb1 where col1 > "2023-02-01
16:00:00.123456";"""
qt_5_3 """select * from timestamp_tb1 where col1 >= "2023-02-01
16:00:00.123456";"""
- qt_5_4 """select * from timestamp_tb1 where col1 = "2023-02-01
16:00:00.123456";"""
qt_5_5 """select * from timestamp_tb1 where col1 <= "2023-02-01
16:00:00.123456";"""
- qt_5_6 """select * from timestamp_tb1 where col1 < "2023-02-01
16:00:00.123456";"""
- qt_5_7 """select * from timestamp_tb1 where col1 != "2023-02-01
16:00:00.123456"; """
- qt_5_8 """ select * from timestamp_tb1 where col2 > "2023-02-02
00:00:00.123456"; """
- qt_5_9 """ select * from timestamp_tb1 where col2 >= "2023-02-02
00:00:00.123456"; """
qt_5_10 """ select * from timestamp_tb1 where col2 = "2023-02-02
00:00:00.123456"; """
- qt_5_11 """ select * from timestamp_tb1 where col2 <= "2023-02-02
00:00:00.123456"; """
qt_5_12 """ select * from timestamp_tb1 where col2 < "2023-02-02
00:00:00.123456"; """
qt_5_13 """ select * from timestamp_tb1 where col2 != "2023-02-02
00:00:00.123456"; """
@@ -186,18 +162,12 @@ suite("test_max_compute_timestamp", "p2,external") {
qt_6_1 """ select * from timestamp_tb2;"""
qt_6_2 """ select * from timestamp_tb2 where col1 > "2023-02-01
16:00:00.123456";"""
- qt_6_3 """ select * from timestamp_tb2 where col1 >= "2023-02-01
16:00:00.123456";"""
qt_6_4 """ select * from timestamp_tb2 where col1 = "2023-02-01
16:00:00.123456";"""
- qt_6_5 """ select * from timestamp_tb2 where col1 <= "2023-02-01
16:00:00.123456";"""
- qt_6_6 """ select * from timestamp_tb2 where col1 < "2023-02-01
16:00:00.123456";"""
qt_6_7 """ select * from timestamp_tb2 where col1 != "2023-02-01
16:00:00.123456";"""
- qt_6_8 """ select * from timestamp_tb1 where col2 > "2023-02-02
00:00:00.123456"; """
qt_6_9 """ select * from timestamp_tb1 where col2 >= "2023-02-02
00:00:00.123456"; """
- qt_6_10 """ select * from timestamp_tb1 where col2 = "2023-02-02
00:00:00.123456"; """
qt_6_11 """ select * from timestamp_tb1 where col2 <= "2023-02-02
00:00:00.123456"; """
qt_6_12 """ select * from timestamp_tb1 where col2 < "2023-02-02
00:00:00.123456"; """
- qt_6_13 """ select * from timestamp_tb1 where col2 != "2023-02-02
00:00:00.123456"; """
@@ -216,56 +186,6 @@ suite("test_max_compute_timestamp", "p2,external") {
sql """ use ${mc_db}"""
- sql """ set time_zone = "Asia/Shanghai" """
- qt_7_1 """ select * from datetime_tb1;"""
- qt_7_2 """ select * from datetime_tb1 where col1 > "2023-02-02
00:00:00.000";"""
- qt_7_3 """ select * from datetime_tb1 where col1 >= "2023-02-02
00:00:00.000";"""
- qt_7_4 """ select * from datetime_tb1 where col1 = "2023-02-02
00:00:00.000";"""
- qt_7_5 """ select * from datetime_tb1 where col1 <= "2023-02-02
00:00:00.000";"""
- qt_7_6 """ select * from datetime_tb1 where col1 < "2023-02-02
00:00:00.000";"""
- qt_7_7 """ select * from datetime_tb1 where col1 != "2023-02-02
00:00:00.000";"""
-
-
- qt_8_1 """ select * from timestamp_tb2;"""
- qt_8_2 """ select * from timestamp_tb2 where col1 > "2023-02-02
00:00:00.123456";"""
- qt_8_3 """ select * from timestamp_tb2 where col1 >= "2023-02-02
00:00:00.123456";"""
- qt_8_4 """ select * from timestamp_tb2 where col1 = "2023-02-02
00:00:00.123456";"""
- qt_8_5 """ select * from timestamp_tb2 where col1 <= "2023-02-02
00:00:00.123456";"""
- qt_8_6 """ select * from timestamp_tb2 where col1 < "2023-02-02
00:00:00.123456";"""
- qt_8_7 """ select * from timestamp_tb2 where col1 != "2023-02-02
00:00:00.123456";"""
- qt_8_8 """ select * from timestamp_tb2 where col2 > "2023-02-02
00:00:00.123456";"""
- qt_8_9 """ select * from timestamp_tb2 where col2 >= "2023-02-02
00:00:00.123456";"""
- qt_8_10 """ select * from timestamp_tb2 where col2 = "2023-02-02
00:00:00.123456";"""
- qt_8_11 """ select * from timestamp_tb2 where col2 <= "2023-02-02
00:00:00.123456";"""
- qt_8_12 """ select * from timestamp_tb2 where col2 < "2023-02-02
00:00:00.123456";"""
- qt_8_13 """ select * from timestamp_tb2 where col2 != "2023-02-02
00:00:00.123456";"""
-
- sql """ set time_zone = "UTC" """
-
- qt_9_1 """ select * from datetime_tb1;"""
- qt_9_2 """ select * from datetime_tb1 where col1 > "2023-02-01
16:00:00.000";"""
- qt_9_3 """ select * from datetime_tb1 where col1 >= "2023-02-01
16:00:00.000";"""
- qt_9_4 """ select * from datetime_tb1 where col1 = "2023-02-01
16:00:00.000";"""
- qt_9_5 """ select * from datetime_tb1 where col1 <= "2023-02-01
16:00:00.000";"""
- qt_9_6 """ select * from datetime_tb1 where col1 < "2023-02-01
16:00:00.000";"""
- qt_9_7 """ select * from datetime_tb1 where col1 != "2023-02-01
16:00:00.000";"""
-
-
-
- qt_10_1 """ select * from timestamp_tb2;"""
- qt_10_2 """ select * from timestamp_tb2 where col1 > "2023-02-01
16:00:00.123456";"""
- qt_10_3 """ select * from timestamp_tb2 where col1 >= "2023-02-01
16:00:00.123456";"""
- qt_10_4 """ select * from timestamp_tb2 where col1 = "2023-02-01
16:00:00.123456";"""
- qt_10_5 """ select * from timestamp_tb2 where col1 <= "2023-02-01
16:00:00.123456";"""
- qt_10_6 """ select * from timestamp_tb2 where col1 < "2023-02-01
16:00:00.123456";"""
- qt_10_7 """ select * from timestamp_tb2 where col1 != "2023-02-01
16:00:00.123456";"""
-
- qt_10_8 """ select * from timestamp_tb1 where col2 > "2023-02-02
00:00:00.123456"; """
- qt_10_9 """ select * from timestamp_tb1 where col2 >= "2023-02-02
00:00:00.123456"; """
- qt_10_10 """ select * from timestamp_tb1 where col2 = "2023-02-02
00:00:00.123456"; """
- qt_10_11 """ select * from timestamp_tb1 where col2 <= "2023-02-02
00:00:00.123456"; """
- qt_10_12 """ select * from timestamp_tb1 where col2 < "2023-02-02
00:00:00.123456"; """
- qt_10_13 """ select * from timestamp_tb1 where col2 != "2023-02-02
00:00:00.123456"; """
}
-}
\ No newline at end of file
+}
diff --git
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_limit_split_optimization.groovy
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_limit_split_optimization.groovy
index e2e4972e36a..6ace9e5aa28 100644
---
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_limit_split_optimization.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_limit_split_optimization.groovy
@@ -48,7 +48,7 @@ suite("test_mc_limit_split_optimization",
"p2,external,maxcompute,external_remot
sql """drop database if exists ${db}"""
sql """create database ${db}"""
- sql """use ${db}"""
+ retry(10, 1000) { sql """use ${db}""" }
try {
// ==================== Step 1: Create partition table and insert data
====================
diff --git
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_catalog_block_bytes.groovy
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_catalog_block_bytes.groovy
index 5557cae9091..ec5d8af7229 100644
---
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_catalog_block_bytes.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_catalog_block_bytes.groovy
@@ -123,7 +123,7 @@ suite("test_mc_write_catalog_block_bytes", "p2,external") {
sql """SWITCH ${catalogName}"""
sql """DROP DATABASE IF EXISTS ${db}"""
sql """CREATE DATABASE ${db}"""
- sql """USE ${db}"""
+ retry(10, 1000) { sql """USE ${db}""" }
sql """DROP TABLE IF EXISTS ${tb}"""
sql """
CREATE TABLE ${tb} (
diff --git
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_ctas.groovy
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_ctas.groovy
index 6ccae3bb8e9..f4ad69c149f 100644
---
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_ctas.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_ctas.groovy
@@ -49,7 +49,7 @@ suite("test_mc_write_ctas", "p2,external") {
sql """drop database if exists ${db}"""
sql """create database ${db}"""
- sql """use ${db}"""
+ retry(10, 1000) { sql """use ${db}""" }
try {
// Prepare source table
diff --git
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_insert.groovy
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_insert.groovy
index 686f7fec093..a7ff446aed6 100644
---
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_insert.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_insert.groovy
@@ -47,7 +47,7 @@ suite("test_mc_write_insert", "p2,external") {
sql """drop database if exists ${db}"""
sql """create database ${db}"""
- sql """use ${db}"""
+ retry(10, 1000) { sql """use ${db}""" }
try {
// Test 1: Basic INSERT INTO with VALUES
diff --git
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_large_data.groovy
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_large_data.groovy
index 6897a01125c..3bd61371461 100644
---
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_large_data.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_large_data.groovy
@@ -74,7 +74,7 @@ suite("test_mc_write_large_data", "p2,external") {
String db = "mc_large_data_${uuid}"
sql """drop database if exists ${db}"""
sql """create database ${db}"""
- sql """use ${db}"""
+ retry(10, 1000) { sql """use ${db}""" }
try {
// Non-partition table
diff --git
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_partitions.groovy
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_partitions.groovy
index acc696b0fae..463dfb1503e 100644
---
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_partitions.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_partitions.groovy
@@ -47,7 +47,7 @@ suite("test_mc_write_partitions", "p2,external") {
sql """drop database if exists ${db}"""
sql """create database ${db}"""
- sql """use ${db}"""
+ retry(10, 1000) { sql """use ${db}""" }
try {
// Test 1: Single partition column INSERT
diff --git
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_static_partitions.groovy
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_static_partitions.groovy
index 0e4aafe7389..a5f2e7318cd 100644
---
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_static_partitions.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_static_partitions.groovy
@@ -47,7 +47,7 @@ suite("test_mc_write_static_partitions", "p2,external") {
sql """drop database if exists ${db}"""
sql """create database ${db}"""
- sql """use ${db}"""
+ retry(10, 1000) { sql """use ${db}""" }
try {
// Test 1: Single partition column static partition INSERT INTO
diff --git
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_types.groovy
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_types.groovy
index a6699e85129..e18c1ba43cb 100644
---
a/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_types.groovy
+++
b/regression-test/suites/external_table_p2/maxcompute/write/test_mc_write_types.groovy
@@ -47,7 +47,7 @@ suite("test_mc_write_types", "p2,external") {
sql """drop database if exists ${db}"""
sql """create database ${db}"""
- sql """use ${db}"""
+ retry(10, 1000) { sql """use ${db}""" }
try {
// Test 1: Basic numeric types
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
