This is an automated email from the ASF dual-hosted git repository.
panxiaolei 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 9fdcd552f5f [Chore](tool) enlarge tpch sf1000 supplier buckets number
(#62214)
9fdcd552f5f is described below
commit 9fdcd552f5f9cb05f25fbb3f3a1663f15cd5733a
Author: Pxl <[email protected]>
AuthorDate: Fri Apr 10 10:18:21 2026 +0800
[Chore](tool) enlarge tpch sf1000 supplier buckets number (#62214)
This pull request increases the number of buckets for the `supplier`
table in the TPC-H schema to improve data distribution and potentially
query performance.
Table distribution changes:
* In `tools/tpch-tools/ddl/create-tpch-tables-sf1000.sql`, the
`supplier` table's `DISTRIBUTED BY HASH` clause is updated to use 48
buckets instead of 24.
---
tools/tpch-tools/ddl/create-tpch-tables-sf1000.sql | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/tools/tpch-tools/ddl/create-tpch-tables-sf1000.sql
b/tools/tpch-tools/ddl/create-tpch-tables-sf1000.sql
index a2c35ccfd17..0ff768b20ae 100644
--- a/tools/tpch-tools/ddl/create-tpch-tables-sf1000.sql
+++ b/tools/tpch-tools/ddl/create-tpch-tables-sf1000.sql
@@ -128,7 +128,7 @@ CREATE TABLE supplier (
)ENGINE=OLAP
DUPLICATE KEY(`s_suppkey`)
COMMENT "OLAP"
-DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 24
+DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 48
PROPERTIES (
"replication_num" = "1"
);
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
