CREATE TABLE site_access (
event_day DATETIME NOT NULL,
site_id INT DEFAULT ‘10’,
city_code VARCHAR(100),
user_name VARCHAR(32) DEFAULT ‘’,
pv BIGINT DEFAULT ‘0’
)
ORDER BY(event_day, site_id, city_code, user_name)
PARTITION BY date_trunc(‘month’, event_day)
DISTRIBUTED BY HASH(event_day, site_id)
PROPERTIES(
“partition_live_number” = “3” ,-- 只保留最近 3 个分区
“replication_num” = “2”
);
ORDER BY换成DUPLICATE KEY就可以了，但是ORDER BY和DUPLICATE KEY确实有点区别啊，
DUPLICATE KEY只能按照字段顺序写啊。