You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by kx...@apache.org on 2023/10/13 03:39:37 UTC
[doris] branch master updated: [FIX](regresstest) fix cases for test_nested_types_insert_into_with_s3 (#25228)
This is an automated email from the ASF dual-hosted git repository.
kxiao 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 509a79988ea [FIX](regresstest) fix cases for test_nested_types_insert_into_with_s3 (#25228)
509a79988ea is described below
commit 509a79988ea65827e1c5f7ce9a91c1021ea7e3bb
Author: amory <wa...@selectdb.com>
AuthorDate: Fri Oct 13 11:39:29 2023 +0800
[FIX](regresstest) fix cases for test_nested_types_insert_into_with_s3 (#25228)
---
.../test_nested_types_insert_into_with_s3.out | 95 ++--------------------
.../test_nested_types_insert_into_with_s3.groovy | 7 ++
2 files changed, 12 insertions(+), 90 deletions(-)
diff --git a/regression-test/data/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.out b/regression-test/data/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.out
index aaa91af32c0..ae5ccad04ac 100644
--- a/regression-test/data/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.out
+++ b/regression-test/data/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.out
@@ -15,13 +15,13 @@
0 [0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 1, 0, 0, 1, 1, 0, 1, 1, 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 1, 0, 1, 1, 0, 1, 1, 0, 1, 0, 1, 1, 1, 0, 1, 1, 1, 0, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 0, 0] [-1083129163, -963910427, 1519845280, -1958563757, 1057667264, 886496321, 662551246, 126037819, -469806662, -935616127, -1926402015, -1511954706, -1787866480, -80725363, -1564632457, -10507 [...]
-- !sql_arr_parquet_doris --
-0 [1, 1, 1, 1, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 1, 0, 0, 1, 1, 1, 1, 0, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 1, 1, 0, 1, 1, 0, 1, 1, 0, 1, 0, 1, 0, 1, 1, 0, 0, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1] [-110, -104, -65, -121, 110, 66, 55, 4, -114, 35, 39, -59, 13, 103, -123, 11, -94, 59, -88, -54, 31, 66, -66, 57, -7, 41, 93, 75, -73, 4, -23, 42, -124, -9, 42, -62, -93, -112, -65, 54, -14 [...]
+0 [0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 1, 0, 0, 1, 1, 0, 1, 1, 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 1, 0, 1, 1, 0, 1, 1, 0, 1, 0, 1, 1, 1, 0, 1, 1, 1, 0, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 0, 0] [-75, -27, -96, 83, -64, 65, -50, 59, -70, -127, 33, -18, -112, -115, 119, -8, -21, 105, 37, -79, -80, -75, 122, -34, -128, 44, 76, 20, 55, 36, 99, 81, 114, 22, 4, 94, -4, 12, 118, 110, 115 [...]
-- !sql_arr_parquet_s3 --
0 [[], [0], [0, 0, 1, 1, 1, 0, 1, 0, 0], [0, 0, 0, 1, 0, 1, 0], [1], [0, 0, 1, 0, 1, 0, 0], [0, 0], [0, 0, 1, 0, 0, 1, 0], [1, 0, 0, 0, 1, 1, 0], [0, 1, 0, 0], [1, 1, 0, 0, 0, 0, 1], [1, 1, 0, 0, 1, 0, 1], [1, 0, 1, 1, 1], [1, 0, 1, 0, 0, 1, 0, 0, 1], [0, 0, 1, 0, 0, 0], [0, 1, 1, 1], [0, 1, 0, 0, 0, 0], [1], [1, 0, 1, 1, 1, 1], [], [1, 1, 1, 1, 0], [0], [0, 1], [1, 1, 0, 1, 1], [0, 1, 0, 1, 1, 1, 1, 0, 0], [0, 1, 0, 0, 0, 1], [1, 0, 1, 0, 1], [0, 0, 0, 1], [0, 1], [], [1, 1, 1, 1, 1], [ [...]
-- !sql_arr_parquet_doris --
-0 [[0, 1], [0, 1, 0, 0, 1], [1, 1, 1, 1, 1, 0], [1, 1, 0, 0], [0], [1, 0, 0, 1, 0], [0, 1, 0], [1, 1, 0, 1, 1, 0, 1, 1], [1, 0, 1, 0, 1, 1], [], [0, 1, 1, 1, 0, 0, 1], [], [], [1, 0, 0, 1], [0, 1, 1, 0, 1, 1, 1, 1], [0, 0], [0, 0, 1, 0], [1, 0, 0], [1, 1, 1, 0, 0], [1, 1, 0], [], [0], [0, 1], [1, 0], [], [0, 1, 1, 0, 0], [], [1, 0, 0, 1, 0, 1], [1, 0, 1, 1, 0], [1, 1], [1, 1], [1, 1, 0, 1, 0, 1], [0, 0, 0, 1, 1, 1, 1, 1, 1], [1, 1, 1, 1], [0, 0, 1, 1, 1], [0], [0, 0, 0], [0, 0, 1, 0, 0, [...]
+0 [[], [0], [0, 0, 1, 1, 1, 0, 1, 0, 0], [0, 0, 0, 1, 0, 1, 0], [1], [0, 0, 1, 0, 1, 0, 0], [0, 0], [0, 0, 1, 0, 0, 1, 0], [1, 0, 0, 0, 1, 1, 0], [0, 1, 0, 0], [1, 1, 0, 0, 0, 0, 1], [1, 1, 0, 0, 1, 0, 1], [1, 0, 1, 1, 1], [1, 0, 1, 0, 0, 1, 0, 0, 1], [0, 0, 1, 0, 0, 0], [0, 1, 1, 1], [0, 1, 0, 0, 0, 0], [1], [1, 0, 1, 1, 1, 1], [], [1, 1, 1, 1, 0], [0], [0, 1], [1, 1, 0, 1, 1], [0, 1, 0, 1, 1, 1, 1, 0, 0], [0, 1, 0, 0, 0, 1], [1, 0, 1, 0, 1], [0, 0, 0, 1], [0, 1], [], [1, 1, 1, 1, 1], [ [...]
-- !sql_arr_orc_s3 --
[{0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, [...]
@@ -45,75 +45,25 @@
[{1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, [...]
-- !sql_arr_parquet_doris --
-[{0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, [...]
+[{1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, [...]
-- !sql_arr_parquet_s3 --
{0:1, 1:0} {9223372036854775807:-9223372036854775807, -9223372036854775808:-9223372036854775805, -9223372036854775807:-9223372036854775808, -9223372036854775806:-9223372036854775807, -9223372036854775805:-9223372036854775807} {1059.941:788218.105, 542258.211:951433.817, 854102.627:762104.404, 971920.736:69587.055, 739777.517:306829.134, 564657.809:169026.506, 796536.158:647878.524, 737096.019:797021.625, 163990.318:205839.086, 685585.822:253088.443, 185680.043:853018.363, 945924.048:2024 [...]
-- !sql_arr_parquet_doris --
-{0:1, 1:0} {-9223372036854775808:-9223372036854775807, -9223372036854775807:-9223372036854775805, -9223372036854775806:-9223372036854775807, -9223372036854775805:9223372036854775807, 9223372036854775807:-9223372036854775806} {1197.432:955434.191, 2220.680:624922.648, 2449.230:575914.155, 7803.790:278700.206, 43331.216:971641.903, 46014.780:271049.371, 58978.057:8615.804, 75724.725:533484.354, 76289.362:777656.860, 86530.261:848675.560, 94144.098:454944.688, 95938.056:649967.716, 108260.2 [...]
+{0:1, 1:0} {9223372036854775807:-9223372036854775807, -9223372036854775808:-9223372036854775805, -9223372036854775807:-9223372036854775808, -9223372036854775806:-9223372036854775807, -9223372036854775805:-9223372036854775807} {1059.941:788218.105, 542258.211:951433.817, 854102.627:762104.404, 971920.736:69587.055, 739777.517:306829.134, 564657.809:169026.506, 796536.158:647878.524, 737096.019:797021.625, 163990.318:205839.086, 685585.822:253088.443, 185680.043:853018.363, 945924.048:2024 [...]
-- !sql_arr_parquet_s3 --
{1:[0, 1, 1, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 1, 0, 1, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 1], 0:[1, 0, 1, 0, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 1, 1, 0, 1, 1, 0, 1, 0, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, 0, 0, 1, 1, 1, 1, 0, 0 [...]
-- !sql_arr_parquet_doris --
-{0:[0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 1, 0, 1, 1, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 1, 1, 1, 1, 0, 0, 1, 0, 0, 1, 1, 1, 1, 0, 0, 0, 1], 1:[1, 0, 0, 1, 0, 1, 0, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 1, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, 1, 1, 1 [...]
+{1:[0, 1, 1, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 1, 0, 1, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 1], 0:[1, 0, 1, 0, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 1, 1, 0, 1, 1, 0, 1, 0, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, 0, 0, 1, 1, 1, 1, 0, 0 [...]
-- !sql_arr --
100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-- !sql_arr --
100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-- !sql_arr --
100
@@ -142,43 +92,8 @@
100
100
100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-- !sql_map_arr --
-83
-84
-86
-81
-84
-78
-83
-86
-84
-81
84
83
82
diff --git a/regression-test/suites/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.groovy b/regression-test/suites/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.groovy
index ba7eb3e8010..2b59e76aa29 100644
--- a/regression-test/suites/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.groovy
+++ b/regression-test/suites/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.groovy
@@ -216,8 +216,13 @@ suite("test_nested_types_insert_into_with_s3", "p0") {
"""
qt_sql_arr_orc_doris """ select * from ${table_names[i]} order by k1 limit 1; """
+ sql "sync"
+ sql "truncate table ${table_names[i]} "
}
+ // here need truncate table for insert into same table with parquet file which data is not same with orc file,
+ // so select from parquet will fail
+
for (int i = 0; i < 2; ++i) {
qt_sql_arr_parquet_s3 """
@@ -256,6 +261,8 @@ suite("test_nested_types_insert_into_with_s3", "p0") {
"format" = "orc");"""
qt_sql_arr_orc_doris """ select c_bool,c_bigint,c_decimalv3,c_datetimev2 from ${table_names[i]} order by k1 limit 1; """
+ sql "sync"
+ sql "truncate table ${table_names[i]} "
}
for (int i = 2; i < parquetFiles.size(); ++i) {
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org