This is an automated email from the ASF dual-hosted git repository.
lijibing pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new fcd62328421 Fix hive p2 case. (#31073)
fcd62328421 is described below
commit fcd62328421af4047cb19732580c9d1b79b4f8a2
Author: Jibing-Li <64681310+jibing...@users.noreply.github.com>
AuthorDate: Sun Feb 18 22:31:52 2024 +0800
Fix hive p2 case. (#31073)
---
.../hive/test_hive_partition_column_analyze.groovy | 212 ++++++++++-----------
1 file changed, 106 insertions(+), 106 deletions(-)
diff --git
a/regression-test/suites/external_table_p2/hive/test_hive_partition_column_analyze.groovy
b/regression-test/suites/external_table_p2/hive/test_hive_partition_column_analyze.groovy
index 42aeea1524a..eb8a80a7118 100644
---
a/regression-test/suites/external_table_p2/hive/test_hive_partition_column_analyze.groovy
+++
b/regression-test/suites/external_table_p2/hive/test_hive_partition_column_analyze.groovy
@@ -41,24 +41,24 @@ suite("test_hive_partition_column_analyze",
"p2,external,hive,external_remote,ex
def result = sql """show column stats multi_partition_parquet
(event_day)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "event_day")
- assertTrue(result[0][1] == "3.83714205E8")
- assertTrue(result[0][2] == "99949.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "3.83714205E9")
- assertTrue(result[0][5] == "10.0")
- assertTrue(result[0][6] == "\'1749-09-24\'")
- assertTrue(result[0][7] == "\'2023-05-26\'")
+ assertTrue(result[0][2] == "3.83714205E8")
+ assertTrue(result[0][3] == "99949.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "3.83714205E9")
+ assertTrue(result[0][6] == "10.0")
+ assertTrue(result[0][7] == "\'1749-09-24\'")
+ assertTrue(result[0][8] == "\'2023-05-26\'")
result = sql """show column stats multi_partition_orc (event_day)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "event_day")
- assertTrue(result[0][1] == "1.9007155E8")
- assertTrue(result[0][2] == "99949.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "1.9007155E9")
- assertTrue(result[0][5] == "10.0")
- assertTrue(result[0][6] == "\'1749-09-24\'")
- assertTrue(result[0][7] == "\'2023-05-26\'")
+ assertTrue(result[0][2] == "1.9007155E8")
+ assertTrue(result[0][3] == "99949.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "1.9007155E9")
+ assertTrue(result[0][6] == "10.0")
+ assertTrue(result[0][7] == "\'1749-09-24\'")
+ assertTrue(result[0][8] == "\'2023-05-26\'")
sql """analyze table ${catalog_name}.partition_type.tinyint_partition
(tinyint_part) with sync"""
sql """analyze table ${catalog_name}.partition_type.smallint_partition
(smallint_part) with sync"""
@@ -78,151 +78,151 @@ suite("test_hive_partition_column_analyze",
"p2,external,hive,external_remote,ex
result = sql """show column stats tinyint_partition (tinyint_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "tinyint_part")
- assertTrue(result[0][1] == "141474.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "141474.0")
- assertTrue(result[0][5] == "1.0")
- assertTrue(result[0][6] == "1")
- assertTrue(result[0][7] == "100")
+ assertTrue(result[0][2] == "141474.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "141474.0")
+ assertTrue(result[0][6] == "1.0")
+ assertTrue(result[0][7] == "1")
+ assertTrue(result[0][8] == "100")
result = sql """show column stats smallint_partition (smallint_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "smallint_part")
- assertTrue(result[0][1] == "141474.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "282948.0")
- assertTrue(result[0][5] == "2.0")
- assertTrue(result[0][6] == "1")
- assertTrue(result[0][7] == "100")
+ assertTrue(result[0][2] == "141474.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "282948.0")
+ assertTrue(result[0][6] == "2.0")
+ assertTrue(result[0][7] == "1")
+ assertTrue(result[0][8] == "100")
result = sql """show column stats int_partition (int_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "int_part")
- assertTrue(result[0][1] == "141474.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "565896.0")
- assertTrue(result[0][5] == "4.0")
- assertTrue(result[0][6] == "1")
- assertTrue(result[0][7] == "100")
+ assertTrue(result[0][2] == "141474.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "565896.0")
+ assertTrue(result[0][6] == "4.0")
+ assertTrue(result[0][7] == "1")
+ assertTrue(result[0][8] == "100")
result = sql """show column stats bigint_partition (bigint_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "bigint_part")
- assertTrue(result[0][1] == "141474.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "1131792.0")
- assertTrue(result[0][5] == "8.0")
- assertTrue(result[0][6] == "1")
- assertTrue(result[0][7] == "100")
+ assertTrue(result[0][2] == "141474.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "1131792.0")
+ assertTrue(result[0][6] == "8.0")
+ assertTrue(result[0][7] == "1")
+ assertTrue(result[0][8] == "100")
result = sql """show column stats char_partition (char_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "char_part")
- assertTrue(result[0][1] == "141474.0")
- assertTrue(result[0][2] == "101.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "2829480.0")
- assertTrue(result[0][5] == "20.0")
- assertTrue(result[0][6] == "\'1 \'")
- assertTrue(result[0][7] == "\'a \'")
+ assertTrue(result[0][2] == "141474.0")
+ assertTrue(result[0][3] == "101.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "2829480.0")
+ assertTrue(result[0][6] == "20.0")
+ assertTrue(result[0][7] == "\'1 \'")
+ assertTrue(result[0][8] == "\'a \'")
result = sql """show column stats varchar_partition (varchar_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "varchar_part")
- assertTrue(result[0][1] == "141474.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "271630.0")
- assertTrue(result[0][5] == "1.9199994345250717")
- assertTrue(result[0][6] == "\'1\'")
- assertTrue(result[0][7] == "\'99\'")
+ assertTrue(result[0][2] == "141474.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "271630.0")
+ assertTrue(result[0][6] == "1.9199994345250717")
+ assertTrue(result[0][7] == "\'1\'")
+ assertTrue(result[0][8] == "\'99\'")
result = sql """show column stats string_partition (string_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "string_part")
- assertTrue(result[0][1] == "141474.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "271630.0")
- assertTrue(result[0][5] == "1.9199994345250717")
- assertTrue(result[0][6] == "\'1\'")
- assertTrue(result[0][7] == "\'99\'")
+ assertTrue(result[0][2] == "141474.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "271630.0")
+ assertTrue(result[0][6] == "1.9199994345250717")
+ assertTrue(result[0][7] == "\'1\'")
+ assertTrue(result[0][8] == "\'99\'")
result = sql """show column stats date_partition (date_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "date_part")
- assertTrue(result[0][1] == "141474.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "565896.0")
- assertTrue(result[0][5] == "4.0")
- assertTrue(result[0][6] == "\'2001-10-12\'")
- assertTrue(result[0][7] == "\'2100-10-12\'")
+ assertTrue(result[0][2] == "141474.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "565896.0")
+ assertTrue(result[0][6] == "4.0")
+ assertTrue(result[0][7] == "\'2001-10-12\'")
+ assertTrue(result[0][8] == "\'2100-10-12\'")
result = sql """show column stats float_partition (float_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "float_part")
- assertTrue(result[0][1] == "117416.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "469664.0")
- assertTrue(result[0][5] == "4.0")
- assertTrue(result[0][6] == "296.31")
- assertTrue(result[0][7] == "32585.627")
+ assertTrue(result[0][2] == "117416.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "469664.0")
+ assertTrue(result[0][6] == "4.0")
+ assertTrue(result[0][7] == "296.31")
+ assertTrue(result[0][8] == "32585.627")
result = sql """show column stats double_partition (double_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "double_part")
- assertTrue(result[0][1] == "16987.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "135896.0")
- assertTrue(result[0][5] == "8.0")
- assertTrue(result[0][6] == "115.145")
- assertTrue(result[0][7] == "32761.145")
+ assertTrue(result[0][2] == "16987.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "135896.0")
+ assertTrue(result[0][6] == "8.0")
+ assertTrue(result[0][7] == "115.145")
+ assertTrue(result[0][8] == "32761.145")
result = sql """show column stats decimal_partition (decimal_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "decimal_part")
- assertTrue(result[0][1] == "141474.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "1131792.0")
- assertTrue(result[0][5] == "8.0")
- assertTrue(result[0][6] == "243.2868")
- assertTrue(result[0][7] == "32527.1543")
+ assertTrue(result[0][2] == "141474.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "1131792.0")
+ assertTrue(result[0][6] == "8.0")
+ assertTrue(result[0][7] == "243.2868")
+ assertTrue(result[0][8] == "32527.1543")
sql """analyze table ${catalog_name}.partition_type.decimal_partition
(decimal_part) with sync with sql"""
result = sql """show column stats decimal_partition (decimal_part)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "decimal_part")
- assertTrue(result[0][1] == "100000.0")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][4] == "800000.0")
- assertTrue(result[0][5] == "8.0")
- assertTrue(result[0][6] == "243.2868")
- assertTrue(result[0][7] == "32527.1543")
+ assertTrue(result[0][2] == "100000.0")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][5] == "800000.0")
+ assertTrue(result[0][6] == "8.0")
+ assertTrue(result[0][7] == "243.2868")
+ assertTrue(result[0][8] == "32527.1543")
result = sql """show column stats two_partition (part1)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "part1")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][6] == "1")
- assertTrue(result[0][7] == "100")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][7] == "1")
+ assertTrue(result[0][8] == "100")
result = sql """show column stats two_partition (part2)"""
assertTrue(result.size() == 1)
assertTrue(result[0][0] == "part2")
- assertTrue(result[0][2] == "100.0")
- assertTrue(result[0][3] == "0.0")
- assertTrue(result[0][6] == "\'1\'")
- assertTrue(result[0][7] == "\'99\'")
+ assertTrue(result[0][3] == "100.0")
+ assertTrue(result[0][4] == "0.0")
+ assertTrue(result[0][7] == "\'1\'")
+ assertTrue(result[0][8] == "\'99\'")
sql """drop catalog ${catalog_name}"""
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
