analytics / priv /data_migrations /NumericIDs /sql /create-tmp-events-v2.sql.eex
Leon4gr45's picture
Upload folder using huggingface_hub (part 4)
c27e67a verified
Raw
History Blame Contribute Delete
271 Bytes
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 %>