Skip to content

armgit / Cap

Public Imported from GitHub
0

Open source Loom alternative. Beautiful, shareable screen recordings.

468 B
Raw Blame
DESCRIPTION >
    Aggregated page views per tenant/path.

SCHEMA >
	tenant_id LowCardinality(String),
	date Date,
	pathname String,
	country LowCardinality(String),
	region LowCardinality(String),
	city LowCardinality(String),
	visits AggregateFunction(uniq, String)

ENGINE AggregatingMergeTree
ENGINE_PARTITION_KEY toYYYYMM(date)
ENGINE_SORTING_KEY (tenant_id, date, country, city, pathname)
ENGINE_TTL date + INTERVAL 90 DAY
ENGINE_SETTINGS index_granularity = 256