ClickHouse创建表

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

创建本地表：<br>CREATE TABLE default.xx on cluster default (     `id` Int64 COMMENT 'id',     `plate_code` Nullable(String) COMMENT '板块编号',     `plate_name` Nullable(String) COMMENT '板块名称',     `date_time` Nullable(String) COMMENT '板块时间',     `code` Nullable(String) COMMENT '小区code',     `city_code` Nullable(String) COMMENT '城市code',     `channel` Nullable(String) COMMENT '航道',     `create_time` DateTime COMMENT '创建时间',     `update_time` Nullable(DateTime) COMMENT '更新时间',     `create_user` Nullable(String) COMMENT '创建人',     `update_user` Nullable(String) COMMENT '更新人',     `deleted` UInt8 COMMENT '是否删除 0:未删除,1:已删除',     `province` Nullable(String) COMMENT '贝壳-省份',     `community_name` Nullable(String) COMMENT '贝壳-小区名称',     `area` Nullable(String) COMMENT '区域' ) ENGINE = ReplicatedMergeTree('/clickhouse/tables/xx/{shard}', '{replica}') ORDER BY id SETTINGS index_granularity = 8192             CREATE TABLE default.xx on cluster default (     `id` Int64 COMMENT 'id',     `plate_code` Nullable(String) COMMENT '板块编号',     `plate_name` Nullable(String) COMMENT '板块名称',     `date_time` Nullable(String) COMMENT '板块时间',     `code` Nullable(String) COMMENT '小区code',     `city_code` Nullable(String) COMMENT '城市code',     `channel` Nullable(String) COMMENT '航道',     `create_time` DateTime COMMENT '创建时间',     `update_time` Nullable(DateTime) COMMENT '更新时间',     `create_user` Nullable(String) COMMENT '创建人',     `update_user` Nullable(String) COMMENT '更新人',     `deleted` UInt8 COMMENT '是否删除 0:未删除,1:已删除',     `province` Nullable(String) COMMENT '贝壳-省份',     `community_name` Nullable(String) COMMENT '贝壳-小区名称',     `area` Nullable(String) COMMENT '区域' ) ENGINE = ReplicatedMergeTree('/clickhouse/tables/xx/{shard}', '{replica}') ORDER BY id SETTINGS index_granularity = 8192

 

创建分布式表：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

CREATE TABLE default.xx (     `id` Int64 COMMENT 'id',     `plate_code` Nullable(String) COMMENT '板块编号',     `plate_name` Nullable(String) COMMENT '板块名称',     `date_time` Nullable(String) COMMENT '板块时间',     `code` Nullable(String) COMMENT '小区code',     `city_code` Nullable(String) COMMENT '城市code',     `channel` Nullable(String) COMMENT '航道',     `create_time` DateTime COMMENT '创建时间',     `update_time` Nullable(DateTime) COMMENT '更新时间',     `create_user` Nullable(String) COMMENT '创建人',     `update_user` Nullable(String) COMMENT '更新人',     `deleted` UInt8 COMMENT '是否删除 0:未删除,1:已删除',     `province` Nullable(String) COMMENT '贝壳-省份',        `community_name` Nullable(String) COMMENT '贝壳-小区名称',     `area` Nullable(String) COMMENT '区域' ) ENGINE = Distributed('default', 'default', 'falcon_beike_plate_relation', rand())       CREATE TABLE default.xx (     `id` Int64 COMMENT 'id',     `plate_code` Nullable(String) COMMENT '板块编号',     `plate_name` Nullable(String) COMMENT '板块名称',     `date_time` Nullable(String) COMMENT '板块时间',     `code` Nullable(String) COMMENT '小区code',     `city_code` Nullable(String) COMMENT '城市code',     `channel` Nullable(String) COMMENT '航道',     `create_time` DateTime COMMENT '创建时间',     `update_time` Nullable(DateTime) COMMENT '更新时间',     `create_user` Nullable(String) COMMENT '创建人',     `update_user` Nullable(String) COMMENT '更新人',     `deleted` UInt8 COMMENT '是否删除 0:未删除,1:已删除',     `province` Nullable(String) COMMENT '贝壳-省份',     `community_name` Nullable(String) COMMENT '贝壳-小区名称',     `area` Nullable(String) COMMENT '区域' ) ENGINE = Distributed('default', 'default', 'xx', rand())