CREATE TABLE aggregates.events_hour_local (
    `stats_day` Date,
    `event_time` DateTime,
    `event_type` LowCardinality(String),
    `ad_type` LowCardinality(String),
    `domain_referrer` String,
    `campaign_id` UInt32,
    `spot_id` UInt32,
    `spot_size` UInt32,
    `country` LowCardinality(String),
    `os_type` LowCardinality(String),
    `os_family` LowCardinality(String),
    `browser_name` LowCardinality(String),
    `browser_family` LowCardinality(String),
    `utm_source` String,
    `utm_medium` String,
    `utm_campaign` String,
    `utm_content` String,
    `cpc_sum` AggregateFunction(sum, Float64),
    `cpm_sum` AggregateFunction(sum, Float64),
    `ecpm_sum` AggregateFunction(sum, Float64),
    `count` AggregateFunction(count)
)    ENGINE = ReplicatedAggregatingMergeTree('/clickhouse/{cluster}/tables/{shard}/aggregates/user_events_hour_local', '{replica}')
     PARTITION BY toYYYYMM(stats_day)
     ORDER BY (stats_day, event_time, event_type, ad_type, domain_referrer, country, campaign_id, spot_id, spot_size, browser_name, browser_family, os_type, os_family, utm_source, utm_medium, utm_campaign, utm_content)
     TTL stats_day + toIntervalMonth(6);