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 987638bf64a [opt](tools) update tools schema (#35873)
987638bf64a is described below
commit 987638bf64adfc31abaae012d939b435823da603
Author: xzj7019 <[email protected]>
AuthorDate: Wed Jun 5 17:56:22 2024 +0800
[opt](tools) update tools schema (#35873)
Update tpcds tools table customer_demographics's bucket column as its
primary key column, avoid performance issue due to data skew.
---
tools/tpcds-tools/ddl/create-tpcds-tables-sf1.sql | 2 +-
tools/tpcds-tools/ddl/create-tpcds-tables-sf100.sql | 2 +-
tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql | 2 +-
tools/tpcds-tools/ddl/create-tpcds-tables-sf10000.sql | 2 +-
4 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/tools/tpcds-tools/ddl/create-tpcds-tables-sf1.sql
b/tools/tpcds-tools/ddl/create-tpcds-tables-sf1.sql
index c29db69a2d8..084ae989a3a 100644
--- a/tools/tpcds-tools/ddl/create-tpcds-tables-sf1.sql
+++ b/tools/tpcds-tools/ddl/create-tpcds-tables-sf1.sql
@@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS customer_demographics (
cd_dep_college_count integer
)
DUPLICATE KEY(cd_demo_sk)
-DISTRIBUTED BY HASH(cd_gender) BUCKETS 12
+DISTRIBUTED BY HASH(cd_demo_sk) BUCKETS 12
PROPERTIES (
"replication_num" = "1"
);
diff --git a/tools/tpcds-tools/ddl/create-tpcds-tables-sf100.sql
b/tools/tpcds-tools/ddl/create-tpcds-tables-sf100.sql
index b1da868e632..c76c15ca4b2 100644
--- a/tools/tpcds-tools/ddl/create-tpcds-tables-sf100.sql
+++ b/tools/tpcds-tools/ddl/create-tpcds-tables-sf100.sql
@@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS customer_demographics (
cd_dep_college_count integer
)
DUPLICATE KEY(cd_demo_sk)
-DISTRIBUTED BY HASH(cd_gender) BUCKETS 12
+DISTRIBUTED BY HASH(cd_demo_sk) BUCKETS 12
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 8c1dd77ebad..a8a0b4c0779 100644
--- a/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql
+++ b/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql
@@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS customer_demographics (
cd_dep_college_count integer
)
DUPLICATE KEY(cd_demo_sk)
-DISTRIBUTED BY HASH(cd_gender) BUCKETS 12
+DISTRIBUTED BY HASH(cd_demo_sk) BUCKETS 12
PROPERTIES (
"replication_num" = "1"
);
diff --git a/tools/tpcds-tools/ddl/create-tpcds-tables-sf10000.sql
b/tools/tpcds-tools/ddl/create-tpcds-tables-sf10000.sql
index 760672922c4..20574ca5348 100644
--- a/tools/tpcds-tools/ddl/create-tpcds-tables-sf10000.sql
+++ b/tools/tpcds-tools/ddl/create-tpcds-tables-sf10000.sql
@@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS customer_demographics (
cd_dep_college_count integer
)
DUPLICATE KEY(cd_demo_sk)
-DISTRIBUTED BY HASH(cd_gender) BUCKETS 12
+DISTRIBUTED BY HASH(cd_demo_sk) BUCKETS 12
PROPERTIES (
"replication_num" = "1"
);
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
