Articles by tag: betting-analytics

ClickHouse aggregate functions: uniqHLL12, quantileTDigest, topK

uniqHLL12 for fast unique users, quantileTDigest for distributions, groupArray, topK, -If combinators. Examples of GGR, cohorts, retention.

SELECT queries in ClickHouse: differences from PostgreSQL, PREWHERE, SAMPLE

PREWHERE, SAMPLE, FINAL, IN vs JOIN, FORMAT, top 10 queries for betting analytics. How to migrate SQL from PostgreSQL to ClickHouse without errors.

ClickHouse client and HTTP API: connection and first queries

Practical guide to working with clickhouse-client and HTTP API: connection methods, interactive vs batch, JSON/CSV formats, creating the bets table. Examples for a betting platform.