You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2023/06/29 03:50:11 UTC
[doris] branch master updated: [fix](doc) Fix table typo in star schema benchmark documentation and join optimization (#19181)
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 f5668ac1a0 [fix](doc) Fix table typo in star schema benchmark documentation and join optimization (#19181)
f5668ac1a0 is described below
commit f5668ac1a0c8575653f8314bd8dde75dfe61e37c
Author: Houliang Qi <ne...@163.com>
AuthorDate: Thu Jun 29 11:50:04 2023 +0800
[fix](doc) Fix table typo in star schema benchmark documentation and join optimization (#19181)
---
docs/en/docs/benchmark/ssb.md | 8 ++++----
.../join-optimization/doris-join-optimization.md | 2 +-
docs/zh-CN/docs/benchmark/ssb.md | 8 ++++----
.../join-optimization/doris-join-optimization.md | 2 +-
4 files changed, 10 insertions(+), 10 deletions(-)
diff --git a/docs/en/docs/benchmark/ssb.md b/docs/en/docs/benchmark/ssb.md
index 7d3720eeca..acb9b06c11 100644
--- a/docs/en/docs/benchmark/ssb.md
+++ b/docs/en/docs/benchmark/ssb.md
@@ -67,7 +67,7 @@ On the SQL test with standard SSB, the overall performance of Apache Doris 1.2.0
| customer | 3,000,000 | Customer Information |
| part | 1,400,000 | Parts Information |
| supplier | 200,000 | Supplier Information |
-| date | 2,556 | Date |
+| dates | 2,556 | Date |
| lineorder_flat | 600,037,902 | Wide Table after Data Flattening |
## 4. Test Results
@@ -169,7 +169,7 @@ With the `-s 100` parameter, the resulting dataset size is:
| customer | 3,000,000 | 277M | 1 |
| part | 1,400,000 | 116M | 1 |
| supplier | 200,000 | 17M | 1 |
-| date | 2,556 | 228K | 1 |
+| dates | 2,556 | 228K | 1 |
### 7.3 Create Table
@@ -283,7 +283,7 @@ We use the following command to complete all data import of SSB test set and SSB
select count(*) from part;
select count(*) from customer;
select count(*) from supplier;
-select count(*) from date;
+select count(*) from dates;
select count(*) from lineorder;
select count(*) from lineorder_flat;
```
@@ -297,7 +297,7 @@ The amount of data should be consistent with the number of rows of generated dat
| customer | 3,000,000 | 277 MB | 138.247 MB |
| part | 1,400,000 | 116 MB | 12.759 MB |
| supplier | 200,000 | 17 MB | 9.143 MB |
-| date | 2,556 | 228 KB | 34.276 KB |
+| dates | 2,556 | 228 KB | 34.276 KB |
### 7.6 Query Test
diff --git a/docs/en/docs/query-acceleration/join-optimization/doris-join-optimization.md b/docs/en/docs/query-acceleration/join-optimization/doris-join-optimization.md
index 057975f7a7..2c3d8266d3 100644
--- a/docs/en/docs/query-acceleration/join-optimization/doris-join-optimization.md
+++ b/docs/en/docs/query-acceleration/join-optimization/doris-join-optimization.md
@@ -48,7 +48,7 @@ As a distributed MPP database, data shuffle needs to be performed during the Joi
When Hash Join is performed, the corresponding Hash value can be calculated through the Join column, and Hash bucketing can be performed.
- Its network overhead is: T(R) + T(N), but it can only support Hash Join, because it also calculates buckets according to the conditions of Join.
+ Its network overhead is: T(S) + T(R), but it can only support Hash Join, because it also calculates buckets according to the conditions of Join.
diff --git a/docs/zh-CN/docs/benchmark/ssb.md b/docs/zh-CN/docs/benchmark/ssb.md
index 9c567a6dae..118c28537d 100644
--- a/docs/zh-CN/docs/benchmark/ssb.md
+++ b/docs/zh-CN/docs/benchmark/ssb.md
@@ -71,7 +71,7 @@ under the License.
| customer | 3,000,000 | 客户信息表 |
| part | 1,400,000 | 零件信息表 |
| supplier | 200,000 | 供应商信息表 |
-| date | 2,556 | 日期表 |
+| dates | 2,556 | 日期表 |
| lineorder_flat | 600,037,902 | 数据展平后的宽表 |
## 4. SSB 宽表测试结果
@@ -170,7 +170,7 @@ sh gen-ssb-data.sh -s 100 -c 100
| customer | 300万（3000000） | 277M | 1 |
| part | 140万（1400000） | 116M | 1 |
| supplier | 20万（200000） | 17M | 1 |
-| date | 2556 | 228K | 1 |
+| dates | 2556 | 228K | 1 |
### 7.3 建表
@@ -284,7 +284,7 @@ sh bin/load-ssb-data.sh -c 10
select count(*) from part;
select count(*) from customer;
select count(*) from supplier;
-select count(*) from date;
+select count(*) from dates;
select count(*) from lineorder;
select count(*) from lineorder_flat;
```
@@ -298,7 +298,7 @@ select count(*) from lineorder_flat;
| customer | 300万（3000000） | 277 MB | 138.247 MB |
| part | 140万（1400000） | 116 MB | 12.759 MB |
| supplier | 20万（200000） | 17 MB | 9.143 MB |
-| date | 2556 | 228 KB | 34.276 KB |
+| dates | 2556 | 228 KB | 34.276 KB |
### 7.6 查询测试
diff --git a/docs/zh-CN/docs/query-acceleration/join-optimization/doris-join-optimization.md b/docs/zh-CN/docs/query-acceleration/join-optimization/doris-join-optimization.md
index 98ad05f5ce..8f2b28560f 100644
--- a/docs/zh-CN/docs/query-acceleration/join-optimization/doris-join-optimization.md
+++ b/docs/zh-CN/docs/query-acceleration/join-optimization/doris-join-optimization.md
@@ -55,7 +55,7 @@ Doris 支持 4 种 Shuffle 方式
当进行 Hash Join 时候，可以通过 Join 列计算对应的 Hash 值，并进行 Hash 分桶。
- 它的网络开销则是：T（R） + T（N），但它只能支持 Hash Join，因为它是根据 Join 的条件也去做计算分桶的。
+ 它的网络开销则是：T（S） + T（R），但它只能支持 Hash Join，因为它是根据 Join 的条件也去做计算分桶的。
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org