Skip to content

Instantly share code, notes, and snippets.

@den-crane
den-crane / gist:6eff375752a236a456e1b3dc2ca7db62
Last active May 23, 2024 18:27
Clickhouse example AggregatingMergeTree, (max, min, avg ) State / Merge
DROP TABLE IF EXISTS requests;
CREATE TABLE requests (
request_date Date,
request_time DateTime,
response_time Int,
request_uri String)
ENGINE = MergeTree(request_date, (request_time, request_uri), 8192);