ClickHouse analytics

Extrémně rychlá pro analytické dotazy.

Instalace¶

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

Tabulka¶

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);

Dotazy¶

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 rychlejší než PG pro analytics
• Sloupcový formát
• 10x komprese
• SQL kompatibilní

ClickHouse pro analytics¶

OLTP=PostgreSQL, OLAP=ClickHouse.