This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 88d1aed3d0c [pick] pick table overview from dev to 3.0 and 2.1 (#1180)
88d1aed3d0c is described below
commit 88d1aed3d0c3c730f1e5f296dadb6df8c5cabe42
Author: Yongqiang YANG <98214048+dataroar...@users.noreply.github.com>
AuthorDate: Fri Oct 11 14:54:48 2024 +0800
[pick] pick table overview from dev to 3.0 and 2.1 (#1180)
# Versions
- [ ] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
# Languages
- [x] Chinese
- [x] English
---
.../version-2.1/table-design/overview.md | 48 ++++++++++++++++++++++
.../version-3.0/table-design/overview.md | 48 ++++++++++++++++++++++
.../version-2.1/table-design/overview.md | 48 ++++++++++++++++++++++
.../version-3.0/table-design/overview.md | 48 ++++++++++++++++++++++
versioned_sidebars/version-2.1-sidebars.json | 23 ++++++-----
versioned_sidebars/version-3.0-sidebars.json | 23 ++++++-----
6 files changed, 216 insertions(+), 22 deletions(-)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/overview.md
new file mode 100644
index 00000000000..500e72c98ca
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/overview.md
@@ -0,0 +1,48 @@
+---
+{
+ "title": "概览",
+ "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.
+-->
+
+## 创建表
+
+使用 [CREATE
TABLE](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md)
语句在 Doris 中创建一个表，也可以使用
[LIKE](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE-LIKE.md)
或
[AS](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md)
子句从另一个表派生表定义。
+
+## 表名
+
+Doris
中表名默认是大小写敏感的，可以在第一次初始化集群时配置[lower_case_table_names](../admin-manual/config/fe-config.md)为大小写不敏感的。默认的表名最大长度为
64
字节，可以通过配置[table_name_length_limit](../admin-manual/config/fe-config.md)更改，不建议配置过大。创建表的语法请参考[CREATE
TABLE](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md)。
+
+## 表属性
+
+Doris
的建表语句中可以指定[建表属性](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md#properties)，其中分桶数(buckets)、存储介质(storage_medium)、副本数(replication)、冷热分离存储策略(storage_policy)属性作用于分区，即分区创建之后，分区就会有自己的属性，修改表属性只对未来创建的分区生效，对已经创建好的分区不生效，关于属性更多的信息请参考[修改表属性](../sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md)
+
+
+## 注意事项
+
+1. 数据模型不可更改，因此建表时需要选择一个合适的[数据模型](../table-design/data-model/overview.md)。
+
+2. 已经创建的分区不能修改分桶数，可以通过[替换分区](../data-operate/delete/table-temp-partition.md)
来修改分桶数，可以修改动态分区未创建的分区分桶数。
+
+3. 加减 VALUE 列是轻量级实现，秒级别可以完成，加减 KEY 列或者修改数据类型是重量级操作，完成时间取决于数据量，大规模数据下尽量避免加减 KEY
列或者修改数据类型。
+
+4. 可以使用层级存储将冷数据保存到 HDD 或者 S3 / HDFS。
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/overview.md
new file mode 100644
index 00000000000..500e72c98ca
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/overview.md
@@ -0,0 +1,48 @@
+---
+{
+ "title": "概览",
+ "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.
+-->
+
+## 创建表
+
+使用 [CREATE
TABLE](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md)
语句在 Doris 中创建一个表，也可以使用
[LIKE](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE-LIKE.md)
或
[AS](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md)
子句从另一个表派生表定义。
+
+## 表名
+
+Doris
中表名默认是大小写敏感的，可以在第一次初始化集群时配置[lower_case_table_names](../admin-manual/config/fe-config.md)为大小写不敏感的。默认的表名最大长度为
64
字节，可以通过配置[table_name_length_limit](../admin-manual/config/fe-config.md)更改，不建议配置过大。创建表的语法请参考[CREATE
TABLE](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md)。
+
+## 表属性
+
+Doris
的建表语句中可以指定[建表属性](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md#properties)，其中分桶数(buckets)、存储介质(storage_medium)、副本数(replication)、冷热分离存储策略(storage_policy)属性作用于分区，即分区创建之后，分区就会有自己的属性，修改表属性只对未来创建的分区生效，对已经创建好的分区不生效，关于属性更多的信息请参考[修改表属性](../sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md)
+
+
+## 注意事项
+
+1. 数据模型不可更改，因此建表时需要选择一个合适的[数据模型](../table-design/data-model/overview.md)。
+
+2. 已经创建的分区不能修改分桶数，可以通过[替换分区](../data-operate/delete/table-temp-partition.md)
来修改分桶数，可以修改动态分区未创建的分区分桶数。
+
+3. 加减 VALUE 列是轻量级实现，秒级别可以完成，加减 KEY 列或者修改数据类型是重量级操作，完成时间取决于数据量，大规模数据下尽量避免加减 KEY
列或者修改数据类型。
+
+4. 可以使用层级存储将冷数据保存到 HDD 或者 S3 / HDFS。
\ No newline at end of file
diff --git a/versioned_docs/version-2.1/table-design/overview.md
b/versioned_docs/version-2.1/table-design/overview.md
new file mode 100644
index 00000000000..b62473fb6ee
--- /dev/null
+++ b/versioned_docs/version-2.1/table-design/overview.md
@@ -0,0 +1,48 @@
+---
+{
+ "title": "Overview",
+ "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.
+-->
+
+## Creating tables
+
+Users can use the [CREATE
TABLE](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md)
statement to create a table in Doris. You can also use the
[LIKE](./sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE-LIKE.md)
or
[AS](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md)
clause to derive the table definition from another table.
+
+## Table name
+
+In Doris, table names are case-sensitive by default. You can configure
[lower_case_table_names](../admin-manual/config/fe-config.md)to make them
case-insensitive during the initial cluster setup. The default maximum length
for table names is 64 bytes, but you can change this by configuring
[table_name_length_limit](../admin-manual/config/fe-config.md). It is not
recommended to set this value too high. For syntax on creating tables, please
refer to [CREATE TABLE](../sql-manual/sql-stateme [...]
+
+## Table property
+
+In the Doris CREATE TABLE statement, you can specify various [table
properties](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md#properties).
Among them, the number of buckets (buckets), storage medium (storage_medium),
replication num (replication_num), and hot/cold storage policy (storage_policy)
properties apply to the partitions. That is, once a partition is created, it
will have its own set of properties. Modifying the table properties will only
affect [...]
+
+
+## Notes
+
+1. The data model cannot be changed, so you need to choose an appropriate
[data model](../table-design/data-model/overview.md) when creating the table.
+
+2. The number of buckets for an existing partition cannot be modified. You can
change the number of buckets by [replacing the
partition](../data-operate/delete/table-temp-partition.md). However, you can
modify the number of buckets for partitions that have not yet been created
under dynamic partitioning.
+
+3. Adding or removing VALUE columns is a lightweight operation and can be
completed in seconds. Adding or removing KEY columns or modifying data types is
a heavyweight operation, and the completion time depends on the amount of data.
It is best to avoid adding or removing KEY columns or modifying data types with
large amounts of data.
+
+4. You can use tiered storage to save cold data to HDD or S3 / HDFS.
\ No newline at end of file
diff --git a/versioned_docs/version-3.0/table-design/overview.md
b/versioned_docs/version-3.0/table-design/overview.md
new file mode 100644
index 00000000000..b62473fb6ee
--- /dev/null
+++ b/versioned_docs/version-3.0/table-design/overview.md
@@ -0,0 +1,48 @@
+---
+{
+ "title": "Overview",
+ "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.
+-->
+
+## Creating tables
+
+Users can use the [CREATE
TABLE](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md)
statement to create a table in Doris. You can also use the
[LIKE](./sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE-LIKE.md)
or
[AS](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md)
clause to derive the table definition from another table.
+
+## Table name
+
+In Doris, table names are case-sensitive by default. You can configure
[lower_case_table_names](../admin-manual/config/fe-config.md)to make them
case-insensitive during the initial cluster setup. The default maximum length
for table names is 64 bytes, but you can change this by configuring
[table_name_length_limit](../admin-manual/config/fe-config.md). It is not
recommended to set this value too high. For syntax on creating tables, please
refer to [CREATE TABLE](../sql-manual/sql-stateme [...]
+
+## Table property
+
+In the Doris CREATE TABLE statement, you can specify various [table
properties](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md#properties).
Among them, the number of buckets (buckets), storage medium (storage_medium),
replication num (replication_num), and hot/cold storage policy (storage_policy)
properties apply to the partitions. That is, once a partition is created, it
will have its own set of properties. Modifying the table properties will only
affect [...]
+
+
+## Notes
+
+1. The data model cannot be changed, so you need to choose an appropriate
[data model](../table-design/data-model/overview.md) when creating the table.
+
+2. The number of buckets for an existing partition cannot be modified. You can
change the number of buckets by [replacing the
partition](../data-operate/delete/table-temp-partition.md). However, you can
modify the number of buckets for partitions that have not yet been created
under dynamic partitioning.
+
+3. Adding or removing VALUE columns is a lightweight operation and can be
completed in seconds. Adding or removing KEY columns or modifying data types is
a heavyweight operation, and the completion time depends on the amount of data.
It is best to avoid adding or removing KEY columns or modifying data types with
large amounts of data.
+
+4. You can use tiered storage to save cold data to HDD or S3 / HDFS.
\ No newline at end of file
diff --git a/versioned_sidebars/version-2.1-sidebars.json
b/versioned_sidebars/version-2.1-sidebars.json
index 1f8f0a89814..f23c190542b 100644
--- a/versioned_sidebars/version-2.1-sidebars.json
+++ b/versioned_sidebars/version-2.1-sidebars.json
@@ -55,7 +55,19 @@
"type": "category",
"label": "Data Table Design",
"items": [
+ "table-design/overview",
"table-design/data-type",
+ {
+ "type": "category",
+ "label": "Table Indexes",
+ "items": [
+ "table-design/index/index-overview",
+ "table-design/index/prefix-index",
+ "table-design/index/inverted-index",
+ "table-design/index/bloomfilter",
+ "table-design/index/ngram-bloomfilter-index"
+ ]
+ },
{
"type": "category",
"label": "Data Models",
@@ -71,17 +83,6 @@
"table-design/data-partition",
"table-design/schema-change",
"table-design/cold-hot-separation",
- {
- "type": "category",
- "label": "Table Indexes",
- "items": [
- "table-design/index/index-overview",
- "table-design/index/prefix-index",
- "table-design/index/inverted-index",
- "table-design/index/bloomfilter",
- "table-design/index/ngram-bloomfilter-index"
- ]
- },
"table-design/auto-increment",
"table-design/best-practice"
]
diff --git a/versioned_sidebars/version-3.0-sidebars.json
b/versioned_sidebars/version-3.0-sidebars.json
index 0931cf5037c..e8009af24a3 100644
--- a/versioned_sidebars/version-3.0-sidebars.json
+++ b/versioned_sidebars/version-3.0-sidebars.json
@@ -86,7 +86,19 @@
"type": "category",
"label": "Data Table Design",
"items": [
+ "table-design/overview",
"table-design/data-type",
+ {
+ "type": "category",
+ "label": "Table Indexes",
+ "items": [
+ "table-design/index/index-overview",
+ "table-design/index/prefix-index",
+ "table-design/index/inverted-index",
+ "table-design/index/bloomfilter",
+ "table-design/index/ngram-bloomfilter-index"
+ ]
+ },
{
"type": "category",
"label": "Data Models",
@@ -102,17 +114,6 @@
"table-design/data-partition",
"table-design/schema-change",
"table-design/cold-hot-separation",
- {
- "type": "category",
- "label": "Table Indexes",
- "items": [
- "table-design/index/index-overview",
- "table-design/index/prefix-index",
- "table-design/index/inverted-index",
- "table-design/index/bloomfilter",
- "table-design/index/ngram-bloomfilter-index"
- ]
- },
"table-design/auto-increment",
"table-design/best-practice"
]
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
