ClickHouse Analytics

Extrem schnell für analytische Abfragen.

Installation¶

docker run -d --name ch -p 8123:8123 -p 9000:9000 clickhouse/clickhouse-server

Tabelle¶

CREATE TABLE events (
    event_date Date,
    user_id UInt64,
    event_type String
) ENGINE=MergeTree()
PARTITION BY toYYYYMM(event_date)
ORDER BY (event_type,event_date);

Abfragen¶

SELECT event_type, count(), uniq(user_id)
FROM events
WHERE event_date>='2024-01-01'
GROUP BY event_type
ORDER BY count() DESC;

• 10-100x schneller als PG für Analytik
• Spaltenformat
• 10x Kompression
• SQL-kompatibel

ClickHouse für Analytik¶

OLTP=PostgreSQL, OLAP=ClickHouse.