#######创建表语句
########创建不为null的语句

CREATE TABLE default.ads_behavior_day_rention on cluster 'cluster_3shards_1replicas'(
`id` UInt64,
 `date` Date,
 `create_date` DateTime,
 `update_date` DateTime,
 `sdk_type` String,
 `day0_rention_rate` default NULLable Float64,
 `day1_rention_rate` Float64,
 `day2_rention_rate` Float64,
 `day3_rention_rate` Float64,
 `day4_rention_rate` Float64,
 `day5_rention_rate` Float64,
 `day6_rention_rate` Float64,
 `day7_rention_rate` Float64
) ENGINE = ReplicatedMergeTree('/clickhouse/tables/ads_behavior_day_rention', '{replica}', date, date, 8192)

########创建可以为null
主键，分区键不能为null

CREATE TABLE default.test_a on cluster 'cluster_3shards_1replicas'(
`id` UInt64,
 `date` Date,
 `create_date` Nullable(DateTime),
 `update_date` Nullable(DateTime),
 `sdk_type` Nullable(String),
 `day0_rention_rate` Nullable(Float64),
 `day1_rention_rate` Nullable(Float64),
 `day2_rention_rate` Nullable(Float64),
 `day3_rention_rate` Nullable(Float64),
 `day4_rention_rate` Nullable(Float64),
 `day5_rention_rate` Nullable(Float64),
 `day6_rention_rate` Nullable(Float64),
 `day7_rention_rate` Nullable(Float64)
) ENGINE = ReplicatedMergeTree('/clickhouse/tables/test_a', '{replica}', date, date, 8192)