This is an automated email from the ASF dual-hosted git repository.
lijibing 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 1b2091eaa0d [fix](regression)Fix external table cardinality case.
(#39603)
1b2091eaa0d is described below
commit 1b2091eaa0dc722faadbe2bc56e3423195bc8da3
Author: Jibing-Li <[email protected]>
AuthorDate: Wed Aug 21 07:52:10 2024 +0800
[fix](regression)Fix external table cardinality case. (#39603)
Fix external table cardinality case.
---
.../hive/test_hive_statistics_p0.groovy | 18 +++++++++++++-----
1 file changed, 13 insertions(+), 5 deletions(-)
diff --git
a/regression-test/suites/external_table_p0/hive/test_hive_statistics_p0.groovy
b/regression-test/suites/external_table_p0/hive/test_hive_statistics_p0.groovy
index cca546cb013..71a43d2aec9 100644
---
a/regression-test/suites/external_table_p0/hive/test_hive_statistics_p0.groovy
+++
b/regression-test/suites/external_table_p0/hive/test_hive_statistics_p0.groovy
@@ -36,11 +36,19 @@ suite("test_hive_statistics_p0",
"all_types,p0,external,hive,external_docker,ext
sql """use `${catalog_name}`.`stats_test`"""
sql """analyze database stats_test with sync"""
- // Test hive scan node cardinality.
- sql """analyze table `${catalog_name}`.`statistics`.`statistics`
with sync"""
- explain {
- sql "select count(2) from
`${catalog_name}`.`statistics`.`statistics`;"
- contains "cardinality=100"
+ // Test hive scan node cardinality. Estimated row count.
+ for (int i = 0; i < 60; i++) {
+ def result = sql """show table stats
`${catalog_name}`.`statistics`.`statistics`"""
+ logger.info("Table stats " + result)
+ if (!"66".equalsIgnoreCase(result[0][2])) {
+ Thread.sleep(1000)
+ } else {
+ explain {
+ sql "select count(2) from
`${catalog_name}`.`statistics`.`statistics`;"
+ contains "cardinality=66"
+ }
+ break;
+ }
}
def result = sql """show catalog ${catalog_name}"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
