CREATE TABLE test.site_access(
event_date INT,
site_id INT DEFAULT ‘10’,
city_code VARCHAR(100),
user_name VARCHAR(32) DEFAULT ‘’,
pv BIGINT DEFAULT ‘0’
)
DUPLICATE KEY(event_date, site_id, city_code, user_name)
PARTITION BY RANGE(event_date)(
PARTITION p20221201 VALUES LESS THAN (“20221202”),
PARTITION p20221202 VALUES LESS THAN (“20221203”)
)
DISTRIBUTED BY HASH(event_date, site_id) BUCKETS 12
PROPERTIES(
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.start” = “-2”,
“dynamic_partition.end” = “24”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.buckets” = “12”
);
使用动态分区时分区字段设置为INT类型，指定按DAY分区，看着分区都没问题，请问这样可以用于生产么？