大多数用MergeTree的场景都建立分区表,不过MergeTree也可以创建非分区表的,下面就举例说明如何创建分区表和非分区表:
创建非分区表:
CREATE TABLE tabel(
orderid Int64 COMMENT '订单号',
orderstatus Nullable(String) COMMENT '订单状态'
incomeconfirmtime Nullable(String) COMMENT '收入确认时间'
)
ENGINE=MergeTree
ORDER BY orderid
SETTINGS index_granularity = 8192
创建分区表:其实就加partition,最后一行加分区信息就可以了
CREATE TABLE table(
orderid Int64 COMMENT '订单号',
orderstatus Nullable(String) COMMENT '订单状态',
incomeconfirmtime Nullable(String) COMMENT '收入确认时间',
d Date
)
ENGINE=MergeTree
PARTITION BY d
ORDER BY orderid
SETTINGS index_granularity = 8192