This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch branch-3.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.1 by this push:
new 1407212f5b1 branch-3.1: [fix](test) fix unstable hive test (#56018)
(#56484)
1407212f5b1 is described below
commit 1407212f5b13280a88a576fc851126dd6e093408
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Sat Sep 27 20:33:23 2025 -0700
branch-3.1: [fix](test) fix unstable hive test (#56018) (#56484)
#56018
---
.../cache/test_file_cache_statistics.out | 2 +-
.../hive/test_hive_basic_type.out | 4 ++--
.../hive/test_hive_get_schema_from_table.out | 4 ++--
.../cache/test_file_cache_statistics.groovy | 2 +-
.../hive/test_hive_basic_type.groovy | 22 +++++++++++-----------
.../hive/test_hive_get_schema_from_table.groovy | 2 +-
6 files changed, 18 insertions(+), 18 deletions(-)
diff --git
a/regression-test/data/external_table_p0/cache/test_file_cache_statistics.out
b/regression-test/data/external_table_p0/cache/test_file_cache_statistics.out
index 39444cdeb5c..52825dc649d 100644
---
a/regression-test/data/external_table_p0/cache/test_file_cache_statistics.out
+++
b/regression-test/data/external_table_p0/cache/test_file_cache_statistics.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !2 --
-1 7706 1 155190 17.00 21168.23 0.04 0.02 N
O 1996-03-13 1996-02-12 1996-03-22 DELIVER IN PERSON
TRUCK egular courts above the cn beijing
+1 638 6 15635 32.00 49620.16 0.07 0.02 N
O 1996-01-30 1996-02-07 1996-02-03 DELIVER IN PERSON
MAIL arefully slyly ex cn beijing
diff --git
a/regression-test/data/external_table_p0/hive/test_hive_basic_type.out
b/regression-test/data/external_table_p0/hive/test_hive_basic_type.out
index 727256096a5..3f1b48f2bb9 100644
--- a/regression-test/data/external_table_p0/hive/test_hive_basic_type.out
+++ b/regression-test/data/external_table_p0/hive/test_hive_basic_type.out
@@ -1,6 +1,6 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !2 --
-1 7706 1 155190 17.00 21168.23 0.04 0.02 N
O 1996-03-13 1996-02-12 1996-03-22 DELIVER IN PERSON
TRUCK egular courts above the cn beijing
+1 638 6 15635 32.00 49620.16 0.07 0.02 N
O 1996-01-30 1996-02-07 1996-02-03 DELIVER IN PERSON
MAIL arefully slyly ex cn beijing
-- !3 --
6374628540732951412 -77 -65 -70 -107 -215 65 0
-526 -1309 3750 8827 -19795 34647 57042 -1662 -138248 -890685
-228568 1633079 -2725524 6163040 -10491702 697237 74565050
127767368 93532213 -209675435 -32116110 -3624917040
-2927805617 15581947241 21893441661 24075494509 -116822110531
-59683724667 -146210393388 114424524398 1341560771667 -1638742564263
520137948334 -2927347587131 7415137351179 -7963937754617 52157548982266
140803519083304 -294675355729619 -868076759504942 181128508165910
-91 [...]
@@ -798,7 +798,7 @@ true
123.456
-- !2 --
-1 7706 1 155190 17.00 21168.23 0.04 0.02 N
O 1996-03-13 1996-02-12 1996-03-22 DELIVER IN PERSON
TRUCK egular courts above the cn beijing
+1 638 6 15635 32.00 49620.16 0.07 0.02 N
O 1996-01-30 1996-02-07 1996-02-03 DELIVER IN PERSON
MAIL arefully slyly ex cn beijing
-- !3 --
6374628540732951412 -77 -65 -70 -107 -215 65 0
-526 -1309 3750 8827 -19795 34647 57042 -1662 -138248 -890685
-228568 1633079 -2725524 6163040 -10491702 697237 74565050
127767368 93532213 -209675435 -32116110 -3624917040
-2927805617 15581947241 21893441661 24075494509 -116822110531
-59683724667 -146210393388 114424524398 1341560771667 -1638742564263
520137948334 -2927347587131 7415137351179 -7963937754617 52157548982266
140803519083304 -294675355729619 -868076759504942 181128508165910
-91 [...]
diff --git
a/regression-test/data/external_table_p0/hive/test_hive_get_schema_from_table.out
b/regression-test/data/external_table_p0/hive/test_hive_get_schema_from_table.out
index 2e190d329f1..c8a8365287e 100644
---
a/regression-test/data/external_table_p0/hive/test_hive_get_schema_from_table.out
+++
b/regression-test/data/external_table_p0/hive/test_hive_get_schema_from_table.out
@@ -1,6 +1,6 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !schema_1 --
-1 7706 1 155190 17.00 21168.23 0.04 0.02 N
O 1996-03-13 1996-02-12 1996-03-22 DELIVER IN PERSON
TRUCK egular courts above the cn beijing
+1 638 6 15635 32.00 49620.16 0.07 0.02 N
O 1996-01-30 1996-02-07 1996-02-03 DELIVER IN PERSON
MAIL arefully slyly ex cn beijing
-- !schema_2 --
6374628540732951412 -77 -65 -70 -107 -215 65 0
-526 -1309 3750 8827 -19795 34647 57042 -1662 -138248 -890685
-228568 1633079 -2725524 6163040 -10491702 697237 74565050
127767368 93532213 -209675435 -32116110 -3624917040
-2927805617 15581947241 21893441661 24075494509 -116822110531
-59683724667 -146210393388 114424524398 1341560771667 -1638742564263
520137948334 -2927347587131 7415137351179 -7963937754617 52157548982266
140803519083304 -294675355729619 -868076759504942 181128508165910
-91 [...]
@@ -27,7 +27,7 @@ true 8 8 8 80 8.8 80.8 7298
12/31/10 8 2010-12-31T12:08:13.780 2010 12
\N \N \N \N \N \N \N \N \N
test test test 1 2 3 4 5.1
6.2 true false 2011-05-06 2011-05-06T07:08:09.123 -1.2 12.30
-1234.5678 123456789.12340000 -1234567890.12345678
1234567890123456789012.1234567800000000 dGVzdDI=
-- !schema_1 --
-1 7706 1 155190 17.00 21168.23 0.04 0.02 N
O 1996-03-13 1996-02-12 1996-03-22 DELIVER IN PERSON
TRUCK egular courts above the cn beijing
+1 638 6 15635 32.00 49620.16 0.07 0.02 N
O 1996-01-30 1996-02-07 1996-02-03 DELIVER IN PERSON
MAIL arefully slyly ex cn beijing
-- !schema_2 --
6374628540732951412 -77 -65 -70 -107 -215 65 0
-526 -1309 3750 8827 -19795 34647 57042 -1662 -138248 -890685
-228568 1633079 -2725524 6163040 -10491702 697237 74565050
127767368 93532213 -209675435 -32116110 -3624917040
-2927805617 15581947241 21893441661 24075494509 -116822110531
-59683724667 -146210393388 114424524398 1341560771667 -1638742564263
520137948334 -2927347587131 7415137351179 -7963937754617 52157548982266
140803519083304 -294675355729619 -868076759504942 181128508165910
-91 [...]
diff --git
a/regression-test/suites/external_table_p0/cache/test_file_cache_statistics.groovy
b/regression-test/suites/external_table_p0/cache/test_file_cache_statistics.groovy
index a4796c73d4e..b62850037b6 100644
---
a/regression-test/suites/external_table_p0/cache/test_file_cache_statistics.groovy
+++
b/regression-test/suites/external_table_p0/cache/test_file_cache_statistics.groovy
@@ -42,7 +42,7 @@ suite("test_file_cache_statistics",
"external_docker,hive,external_docker_hive,p
sql """switch ${catalog_name}"""
- order_qt_2 """select * from
${catalog_name}.${ex_db_name}.parquet_partition_table order by l_orderkey limit
1;"""
+ order_qt_2 """select * from
${catalog_name}.${ex_db_name}.parquet_partition_table order by
l_orderkey,l_partkey limit 1;"""
// brpc metrics will be updated at most 20 seconds
Awaitility.await().atMost(30, TimeUnit.SECONDS).pollInterval(1,
TimeUnit.SECONDS).until{
def result = sql """select METRIC_VALUE from
information_schema.file_cache_statistics where METRIC_NAME like "%hits_ratio%"
order by METRIC_VALUE limit 1;"""
diff --git
a/regression-test/suites/external_table_p0/hive/test_hive_basic_type.groovy
b/regression-test/suites/external_table_p0/hive/test_hive_basic_type.groovy
index 4e258a30318..fda250fbce8 100644
--- a/regression-test/suites/external_table_p0/hive/test_hive_basic_type.groovy
+++ b/regression-test/suites/external_table_p0/hive/test_hive_basic_type.groovy
@@ -45,12 +45,12 @@ suite("test_hive_basic_type",
"external_docker,hive,external_docker_hive,p0,exte
sql """switch ${catalog_name}"""
def res_dbs_log = sql "show databases;"
- for (int i = 0; i < res_dbs_log.size(); i++) {
- def tbs = sql "show tables from `${res_dbs_log[i][0]}`"
- log.info("database = ${res_dbs_log[i][0]} => tables = " +
tbs.toString())
- }
+ // for (int i = 0; i < res_dbs_log.size(); i++) {
+ // def tbs = sql "show tables from `${res_dbs_log[i][0]}`"
+ // log.info("database = ${res_dbs_log[i][0]} => tables = " +
tbs.toString())
+ // }
try {
- order_qt_2 """select * from
${catalog_name}.${ex_db_name}.parquet_partition_table order by l_orderkey limit
1;"""
+ order_qt_2 """select * from
${catalog_name}.${ex_db_name}.parquet_partition_table order by
l_orderkey,l_partkey limit 1;"""
order_qt_3 """select * from
${catalog_name}.${ex_db_name}.parquet_delta_binary_packed order by int_value
limit 1;"""
order_qt_4 """select * from
${catalog_name}.${ex_db_name}.parquet_alltypes_tiny_pages order by id desc
limit 5;"""
order_qt_5 """select * from
${catalog_name}.${ex_db_name}.orc_all_types_partition order by bigint_col desc
limit 3;"""
@@ -148,12 +148,12 @@ suite("test_hive_basic_type",
"external_docker,hive,external_docker_hive,p0,exte
order_qt_parquet11 """ select decimals from
${catalog_name}.${ex_db_name}.parquet_decimal_bool
where decimals is not null and decimals
> 1 order by decimals limit 7 """
} finally {
- res_dbs_log = sql "show databases;"
- for (int i = 0; i < res_dbs_log.size(); i++) {
- def tbs = sql "show tables from `${res_dbs_log[i][0]}`"
- log
- .info("database = ${res_dbs_log[i][0]} => tables
= " + tbs.toString())
- }
+ // res_dbs_log = sql "show databases;"
+ // for (int i = 0; i < res_dbs_log.size(); i++) {
+ // def tbs = sql "show tables from `${res_dbs_log[i][0]}`"
+ // log
+ // .info("database = ${res_dbs_log[i][0]} =>
tables = " + tbs.toString())
+ // }
}
//sql """drop catalog if exists ${catalog_name} """
}
diff --git
a/regression-test/suites/external_table_p0/hive/test_hive_get_schema_from_table.groovy
b/regression-test/suites/external_table_p0/hive/test_hive_get_schema_from_table.groovy
index c07a0a763b0..5d6f78b6ae0 100644
---
a/regression-test/suites/external_table_p0/hive/test_hive_get_schema_from_table.groovy
+++
b/regression-test/suites/external_table_p0/hive/test_hive_get_schema_from_table.groovy
@@ -47,7 +47,7 @@ suite("test_hive_get_schema_from_table",
"external_docker,hive,external_docker_h
log.info("database = ${res_dbs_log[i][0]} => tables = " +
tbs.toString())
}
- order_qt_schema_1 """select * from
${catalog_name}.${ex_db_name}.parquet_partition_table order by l_orderkey limit
1;"""
+ order_qt_schema_1 """select * from
${catalog_name}.${ex_db_name}.parquet_partition_table order by
l_orderkey,l_partkey limit 1;"""
order_qt_schema_2 """select * from
${catalog_name}.${ex_db_name}.parquet_delta_binary_packed order by int_value
limit 1;"""
order_qt_schema_3 """select * from
${catalog_name}.${ex_db_name}.parquet_alltypes_tiny_pages order by id desc
limit 5;"""
order_qt_schema_4 """select * from
${catalog_name}.${ex_db_name}.orc_all_types_partition order by bigint_col desc
limit 3;"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
