Table with partitioning key

ddl.sql

CREATE TABLE default.upclick_metrics
(
    `target` String,
    `status_code` UInt8,
    `latency` UInt16,
    `continent_code` String,
    `country_iso_code` String,
    `country_name_en` String,
    `city_name_en` String,
    `latitude` Float64,
    `longitude` Float64,
    `receive_timestamp` DateTime64 MATERIALIZED now64()
)
ENGINE = ReplicatedMergeTree
PARTITION BY continent_code
ORDER BY (target, status_code, continent_code, country_iso_code, country_name_en, city_name_en)
SETTINGS old_parts_lifetime = 86400; -- for getting the part names from system.parts table for a bit longer than 8 minutes