This talk shows how to get a sub-second response from datasets containing a billion rows or more. We’ll start with defining schema and loading quickly data in parallel. We will then introduce tricks like LowCardinality datatype, ASOF joins, and materialized views that can reduce query response to thousandths of seconds. Finally, we’ll show you metrics and logging to analyze query performance. After this talk you’ll be ready for your first billion rows and many more afterwards.
Robert Hodges is CEO of Altinity, which offers enterprise support for ClickHouse. He has over three decades of experience in data management spanning 20 different DBMS types. ClickHouse is his current favorite. 😉
You can find slides for this webinar HERE