This is an automated email from the ASF dual-hosted git repository.
englefly 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 4c05a699dfa [tools] update tools schema (#34628)
4c05a699dfa is described below
commit 4c05a699dfaab2dbfed0b60d5399fd6165cf9c66
Author: xzj7019 <[email protected]>
AuthorDate: Fri May 10 18:43:23 2024 +0800
[tools] update tools schema (#34628)
update tools schema, tpcds table item bucket number changes to 32.
---
tools/tpcds-tools/ddl/create-tpcds-tables-sf100.sql | 2 +-
tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/tools/tpcds-tools/ddl/create-tpcds-tables-sf100.sql
b/tools/tpcds-tools/ddl/create-tpcds-tables-sf100.sql
index 6ed0f820eeb..b1da868e632 100644
--- a/tools/tpcds-tools/ddl/create-tpcds-tables-sf100.sql
+++ b/tools/tpcds-tools/ddl/create-tpcds-tables-sf100.sql
@@ -351,7 +351,7 @@ CREATE TABLE IF NOT EXISTS item (
i_product_name char(50)
)
DUPLICATE KEY(i_item_sk)
-DISTRIBUTED BY HASH(i_item_sk) BUCKETS 12
+DISTRIBUTED BY HASH(i_item_sk) BUCKETS 32
PROPERTIES (
"replication_num" = "1"
);
diff --git a/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql
b/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql
index 5601e159231..8c1dd77ebad 100644
--- a/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql
+++ b/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql
@@ -543,7 +543,7 @@ CREATE TABLE IF NOT EXISTS item (
i_product_name char(50)
)
DUPLICATE KEY(i_item_sk)
-DISTRIBUTED BY HASH(i_item_sk) BUCKETS 24
+DISTRIBUTED BY HASH(i_item_sk) BUCKETS 32
PROPERTIES (
"replication_num" = "1"
);
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
