You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by ji...@apache.org on 2022/05/27 04:55:24 UTC
[incubator-doris] branch master updated: [doc]Remove tcp-h (#9794)
This is an automated email from the ASF dual-hosted git repository.
jiafengzheng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-doris.git
The following commit(s) were added to refs/heads/master by this push:
new add3f5da85 [doc]Remove tcp-h (#9794)
add3f5da85 is described below
commit add3f5da85e59f23e7ae352097b2e1f2c1e96218
Author: jiafeng.zhang <zh...@gmail.com>
AuthorDate: Fri May 27 12:55:19 2022 +0800
[doc]Remove tcp-h (#9794)
remove tcp-h
---
docs/.vuepress/sidebar/en.js | 3 +-
docs/.vuepress/sidebar/zh-CN.js | 3 +-
docs/en/benchmark/tpc-h.md | 109 ---------------------------------------
docs/zh-CN/benchmark/tpc-h.md | 110 ----------------------------------------
4 files changed, 2 insertions(+), 223 deletions(-)
diff --git a/docs/.vuepress/sidebar/en.js b/docs/.vuepress/sidebar/en.js
index c4fb6766b3..54fc65d747 100644
--- a/docs/.vuepress/sidebar/en.js
+++ b/docs/.vuepress/sidebar/en.js
@@ -1004,8 +1004,7 @@ module.exports = [
directoryPath: "benchmark/",
initialOpenGroupIndex: -1,
children: [
- "ssb",
- "tpc-h"
+ "ssb"
],
},
{
diff --git a/docs/.vuepress/sidebar/zh-CN.js b/docs/.vuepress/sidebar/zh-CN.js
index a950e1b167..4823046a19 100644
--- a/docs/.vuepress/sidebar/zh-CN.js
+++ b/docs/.vuepress/sidebar/zh-CN.js
@@ -1004,8 +1004,7 @@ module.exports = [
directoryPath: "benchmark/",
initialOpenGroupIndex: -1,
children: [
- "ssb",
- "tpc-h"
+ "ssb"
],
},
{
diff --git a/docs/en/benchmark/tpc-h.md b/docs/en/benchmark/tpc-h.md
deleted file mode 100644
index 594dd37657..0000000000
--- a/docs/en/benchmark/tpc-h.md
+++ /dev/null
@@ -1,109 +0,0 @@
----
-{
- "title": "TPC-H Benchmark Test",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-# TPC-H Benchmark
-
-[TPC-H](https://www.tpc.org/tpch/) is a test set developed by the Transaction Processing Performance Council (TPC) to simulate decision support applications. The TPC-H query contains 8 data tables, and the data volume can be set from 1GB to 3TB. Contains 22 complex SQL queries, most of which include several table joins, subqueries, and group-by aggregations.
-
-The TPC-H benchmark test includes 22 queries (Q1~Q22), and its main evaluation index is the response time of each query, that is, the time from submitting the query to returning the result. The measurement unit of the TPC-H benchmark test is performed per hour Number of queries.
-
-## Test Process
-
-The test scripts are in the directory [tpch-tools](https://github.com/apache/incubator-doris/tree/master/tools/tpch-tools)
-
-### 1. Compile the TPC-H generation tool
-
-````
-./build-tpch-dbgen.sh
-````
-
-### 2. Generate data
-
-````
-./gen-tpch-data.sh -s 1
-````
-
-### 3. Create a table in the doris cluster
-
-```shell
-#Doris-cluster.conf cluster configuration needs to be modified before execution
-./create-tpch-tables.sh
-````
-
-### 4. Import data
-
-````
-./load-tpch-data.sh
-````
-
-### 5. Execute the query
-
-````
-./run-tpch-queries.sh
-````
-
-## Testing Report
-
-The following test report is based on the Doris1.0 test and is for reference only.
-
-1. Hardware environment
-
- - 1 FE + 3 BE
- - CPU: 16 core CPU
- - Memory: 64GB
- - Hard disk: SSD 1T
- - Network card: 10 Gigabit network card
-
-2. Dataset
-
- The TPC-H test set scale is 100, and the generated raw data file is about 107G.
-
-3. Test results
-
- | Unit (ms) | doris 1.0 (ms) |
- | --------- | -------------- |
- | q1 | 4215 |
- | q2 | 13633 |
- | q3 | 9677 |
- | q4 | 7087 |
- | q5 | 4290 |
- | q6 | 1045 |
- | q7 | 2147 |
- | q8 | 3073 |
- | q9 | 33064 |
- | q10 | 5733 |
- | q11 | 2598 |
- | q12 | 4998 |
- | q13 | 10798 |
- | q14 | 11786 |
- | q15 | 2038 |
- | q16 | 3313 |
- | q17 | 20340 |
- | q18 | 23277 |
- | q19 | 1645 |
- | q20 | 5738 |
- | q21 | 18520 |
- | q22 | 1041 |
diff --git a/docs/zh-CN/benchmark/tpc-h.md b/docs/zh-CN/benchmark/tpc-h.md
deleted file mode 100644
index b2982a5cde..0000000000
--- a/docs/zh-CN/benchmark/tpc-h.md
+++ /dev/null
@@ -1,110 +0,0 @@
----
-{
- "title": "TPC-H Benchmark 测试",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-# TPC-H Benchmark
-
-[TPC-H](https://www.tpc.org/tpch/) 是美国交易处理效能委员会 TPC（Transaction Processing Performance Council）组织制定的用来模拟决策支持类应用的测试集。TPC-H查询包含8张数据表，数据量可设定从1GB~3TB 不等。包含22条复杂的SQL查询，大多数查询包含若干表Join、子查询和Group-by聚合等。
-
-TPC-H 基准测试包括 22 个查询（Q1~Q22）,其主要评价指标是各个查询的响应时间,即从提交查询到结果返回所需时间.TPC-H 基准测试的度量单位是每小时执行的查询数。
-
-## 测试流程
-
-测试脚本均在目录 [tpch-tools](https://github.com/apache/incubator-doris/tree/master/tools/tpch-tools)
-
-### 1.编译TPC-H生成工具
-
-```
-./build-tpch-dbgen.sh
-```
-
-### 2.生成数据
-
-```
-./gen-tpch-data.sh -s 1
-```
-
-### 3.在doris集群中创建表
-
-```shell
-#执行前需要修改doris-cluster.conf集群配置
-./create-tpch-tables.sh
-```
-
-### 4.导入数据
-
-```
-./load-tpch-data.sh
-```
-
-### 5.执行查询
-
-```
-./run-tpch-queries.sh
-```
-
-## 测试报告
-
-以下测试报告基于 Doris1.0 测试，仅供参考。
-
-1. 硬件环境
-
- - 1 FE + 3 BE
- - CPU：16核CPU
- - 内存：64GB
- - 硬盘：SSD 1T
- - 网卡：万兆网卡
-
-2. 数据集
-
- TPC-H测试集scale 100，生成的原始数据文件大约107G。
-
-3. 测试结果
-
- | 单位（ms） | doris 1.0（ms） |
- | ---------- | --------------- |
- | q1 | 4215 |
- | q2 | 13633 |
- | q3 | 9677 |
- | q4 | 7087 |
- | q5 | 4290 |
- | q6 | 1045 |
- | q7 | 2147 |
- | q8 | 3073 |
- | q9 | 33064 |
- | q10 | 5733 |
- | q11 | 2598 |
- | q12 | 4998 |
- | q13 | 10798 |
- | q14 | 11786 |
- | q15 | 2038 |
- | q16 | 3313 |
- | q17 | 20340 |
- | q18 | 23277 |
- | q19 | 1645 |
- | q20 | 5738 |
- | q21 | 18520 |
- | q22 | 1041 |
-
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org