This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 3fc12915249 [opt](tools) update bucket number in schema file (#34561)
3fc12915249 is described below
commit 3fc12915249e727a6818b57848c575a6847e27cf
Author: xzj7019 <131111794+xzj7...@users.noreply.github.com>
AuthorDate: Thu May 9 10:27:03 2024 +0800
[opt](tools) update bucket number in schema file (#34561)
update tpcds sf1000 bucket number from 64 to 32, for workarounding fdb
issue under storage-compute separation arch.
Co-authored-by: zhongjian.xzj
<zhongjian.xzj@zhongjianxzjdeMacBook-Pro.local>
---
tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql | 16 ++++++++--------
1 file changed, 8 insertions(+), 8 deletions(-)
diff --git a/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql
b/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql
index fa7d1f8768a..5601e159231 100644
--- a/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql
+++ b/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql
@@ -213,7 +213,7 @@ PARTITION `p70` VALUES LESS THAN ("2452945"),
PARTITION `p71` VALUES LESS THAN ("2452975"),
PARTITION `p72` VALUES LESS THAN (MAXVALUE)
)
-DISTRIBUTED BY HASH(cs_item_sk, cs_order_number) BUCKETS 64
+DISTRIBUTED BY HASH(cs_item_sk, cs_order_number) BUCKETS 32
PROPERTIES (
"replication_num" = "1",
"colocate_with" = "catalog"
@@ -340,7 +340,7 @@ PARTITION `p70` VALUES LESS THAN ("2452945"),
PARTITION `p71` VALUES LESS THAN ("2452975"),
PARTITION `p72` VALUES LESS THAN (MAXVALUE)
)
-DISTRIBUTED BY HASH(inv_item_sk, inv_warehouse_sk) BUCKETS 64
+DISTRIBUTED BY HASH(inv_item_sk, inv_warehouse_sk) BUCKETS 32
PROPERTIES (
"replication_num" = "1"
);
@@ -450,7 +450,7 @@ PARTITION `p70` VALUES LESS THAN ("2452945"),
PARTITION `p71` VALUES LESS THAN ("2452975"),
PARTITION `p72` VALUES LESS THAN (MAXVALUE)
)
-DISTRIBUTED BY HASH(cr_item_sk, cr_order_number) BUCKETS 64
+DISTRIBUTED BY HASH(cr_item_sk, cr_order_number) BUCKETS 32
PROPERTIES (
"replication_num" = "1",
"colocate_with" = "catalog"
@@ -485,7 +485,7 @@ CREATE TABLE IF NOT EXISTS customer_address (
ca_location_type char(20)
)
DUPLICATE KEY(ca_address_sk)
-DISTRIBUTED BY HASH(ca_address_sk) BUCKETS 64
+DISTRIBUTED BY HASH(ca_address_sk) BUCKETS 32
PROPERTIES (
"replication_num" = "1"
);
@@ -650,7 +650,7 @@ PARTITION `p70` VALUES LESS THAN ("2452945"),
PARTITION `p71` VALUES LESS THAN ("2452975"),
PARTITION `p72` VALUES LESS THAN (MAXVALUE)
)
-DISTRIBUTED BY HASH(wr_item_sk, wr_order_number) BUCKETS 64
+DISTRIBUTED BY HASH(wr_item_sk, wr_order_number) BUCKETS 32
PROPERTIES (
"replication_num" = "1",
"colocate_with" = "web"
@@ -829,7 +829,7 @@ PARTITION `p70` VALUES LESS THAN ("2452945"),
PARTITION `p71` VALUES LESS THAN ("2452975"),
PARTITION `p72` VALUES LESS THAN (MAXVALUE)
)
-DISTRIBUTED BY HASH(ws_item_sk, ws_order_number) BUCKETS 64
+DISTRIBUTED BY HASH(ws_item_sk, ws_order_number) BUCKETS 32
PROPERTIES (
"replication_num" = "1",
"colocate_with" = "web"
@@ -1010,7 +1010,7 @@ PARTITION `p70` VALUES LESS THAN ("2452945"),
PARTITION `p71` VALUES LESS THAN ("2452975"),
PARTITION `p72` VALUES LESS THAN (MAXVALUE)
)
-DISTRIBUTED BY HASH(sr_item_sk, sr_ticket_number) BUCKETS 64
+DISTRIBUTED BY HASH(sr_item_sk, sr_ticket_number) BUCKETS 32
PROPERTIES (
"replication_num" = "1",
"colocate_with" = "store"
@@ -1117,7 +1117,7 @@ PARTITION `p70` VALUES LESS THAN ("2452945"),
PARTITION `p71` VALUES LESS THAN ("2452975"),
PARTITION `p72` VALUES LESS THAN (MAXVALUE)
)
-DISTRIBUTED BY HASH(ss_item_sk, ss_ticket_number) BUCKETS 64
+DISTRIBUTED BY HASH(ss_item_sk, ss_ticket_number) BUCKETS 32
PROPERTIES (
"replication_num" = "1",
"colocate_with" = "store"
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
