kangpinghuang commented on a change in pull request #2573: implements create
drop show index syntax for bitmap index [#2487]
URL: https://github.com/apache/incubator-doris/pull/2573#discussion_r361600238
##########
File path: docs/documentation/cn/sql-reference/sql-statements/Data
Definition/CREATE TABLE.md
##########
@@ -156,260 +183,321 @@ under the License.
3) 分区为左闭右开区间，首个分区的左边界为做最小值
4) NULL 值只会存放在包含最小值的分区中。当包含最小值的分区被删除后，NULL 值将无法导入。
5) 可以指定一列或多列作为分区列。如果分区值缺省，则会默认填充最小值。
-
+
注意：
1) 分区一般用于时间维度的数据管理
2) 有数据回溯需求的，可以考虑首个分区为空分区，以便后续增加分区
-
- 2）Fixed Range
+
+ 2）Fixed Range
语法：
+ ```
PARTITION BY RANGE (k1, k2, k3, ...)
(
PARTITION partition_name1 VALUES [("k1-lower1", "k2-lower1",
"k3-lower1",...), ("k1-upper1", "k2-upper1", "k3-upper1", ...)),
PARTITION partition_name2 VALUES [("k1-lower1-2", "k2-lower1-2",
...), ("k1-upper1-2", MAXVALUE, ))
"k3-upper1-2", ...
)
+ ```
说明：
1）Fixed Range比LESS THAN相对灵活些，左右区间完全由用户自己确定
2）其他与LESS THAN保持同步
- 5. distribution_desc
+3. distribution_desc
1) Hash 分桶
语法：
- DISTRIBUTED BY HASH (k1[,k2 ...]) [BUCKETS num]
+ `DISTRIBUTED BY HASH (k1[,k2 ...]) [BUCKETS num]`
说明：
使用指定的 key 列进行哈希分桶。默认分区数为10
- 建议:建议使用Hash分桶方式
+ 建议:建议使用Hash分桶方式
- 6. PROPERTIES
+4. PROPERTIES
1) 如果 ENGINE 类型为 olap，则可以在 properties 中指定列存（目前我们仅支持列存）
-
- PROPERTIES (
+ ```
+ PROPERTIES (
"storage_type" = "[column]",
)
-
- 2) 如果 ENGINE 类型为 olap
+ ```
+ 1) 如果 ENGINE 类型为 olap
Review comment:
incorrect sequence id? 2)?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
