File size: 271 Bytes
c27e67a
 
 
 
 
 
1
2
3
4
5
6
7
CREATE TABLE IF NOT EXISTS
    tmp_events_v2 AS events_v2 ENGINE = MergeTree()
    ORDER BY (site_id, toDate(timestamp), name, user_id, timestamp)
    PRIMARY KEY (site_id, toDate(timestamp), name, user_id)
    PARTITION BY toYYYYMM(timestamp)
    <%= @table_settings %>