Skip to content

Commit 1061662

Browse files
ByteYuepull[bot]
authored andcommitted
[chore](doc) fix mv doc typo and cold heat separation (#18892)
1 parent 181fac8 commit 1061662

4 files changed

Lines changed: 9 additions & 7 deletions

File tree

‎docs/en/docs/advanced/cold_hot_separation.md‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -46,6 +46,7 @@ The cold and hot separation supports all doris functions, but only places some d
4646
- Remote object space recycling recycler. If the table and partition are deleted, or the space is wasted due to abnormal conditions in the cold and hot separation process, the recycler thread will periodically recycle, saving storage resources
4747
- Cache optimization, which caches the accessed cold data to be local, achieving the query performance of non cold and hot separation
4848
- Be thread pool optimization, distinguish whether the data source is local or object storage, and prevent the delay of reading objects from affecting query performance
49+
- newly created materialized view would inherit storage policy from it's base table's correspoding partition
4950

5051
## Storage policy
5152

‎docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -115,8 +115,8 @@ attention:If the materialized view contains partitioned and distributed column
115115
1. Create a materialized view that contains only the columns of the original table (k1, k2)
116116

117117
```sql
118-
create materialized view k1_k2 as
119-
select k1, k2 from duplicate_table;
118+
create materialized view k2_k1 as
119+
select k2, k1 from duplicate_table;
120120
````
121121
122122
The schema of the materialized view is as follows, the materialized view contains only two columns k1, k2 without any aggregation
@@ -125,8 +125,8 @@ attention:If the materialized view contains partitioned and distributed column
125125
+-------+-------+--------+------+------+ ---------+-------+
126126
| IndexName | Field | Type | Null | Key | Default | Extra |
127127
+-------+-------+--------+------+------+ ---------+-------+
128-
| k1_k2 | k1 | INT | Yes | true | N/A | |
129-
| | k2 | INT | Yes | true | N/A | |
128+
| k2_k1 | k2 | INT | Yes | true | N/A | |
129+
| | k1 | INT | Yes | true | N/A | |
130130
+-------+-------+--------+------+------+ ---------+-------+
131131
````
132132

‎docs/zh-CN/docs/advanced/cold_hot_separation.md‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -46,6 +46,7 @@ under the License.
4646
- 远程对象空间回收recycler,若表、分区被删除,或者冷热分离过程中异常情况产生的空间浪费,则会有recycler线程周期性的回收,节约存储资源
4747
- cache优化,将访问过的冷数据cache到be本地,达到非冷热分离的查询性能
4848
- be线程池优化,区分数据来源是本地还是对象存储,防止读取对象延时影响查询性能
49+
- 新建的物化视图也会继承相同partition的存储策略
4950

5051
## Storage policy的使用
5152

‎docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -116,7 +116,7 @@ properties("replication_num" = "1");
116116

117117
```sql
118118
create materialized view k1_k2 as
119-
select k1, k2 from duplicate_table;
119+
select k2, k1 from duplicate_table;
120120
```
121121

122122
物化视图的 schema 如下图,物化视图仅包含两列 k1, k2 且不带任何聚合
@@ -125,8 +125,8 @@ properties("replication_num" = "1");
125125
+-----------------+-------+--------+------+------+---------+-------+
126126
| IndexName | Field | Type | Null | Key | Default | Extra |
127127
+-----------------+-------+--------+------+------+---------+-------+
128-
| k1_k2 | k1 | INT | Yes | true | N/A | |
129-
| | k2 | INT | Yes | true | N/A | |
128+
| k2_k1 | k2 | INT | Yes | true | N/A | |
129+
| | k1 | INT | Yes | true | N/A | |
130130
+-----------------+-------+--------+------+------+---------+-------+
131131
```
132132

0 commit comments

Comments
 (0)