- This event has passed.
5th June 2019 @ 6:00 pm - 7:00 pm BST
June 5, 2019
6 pm GMT / 1 pm EST / 10 am PST
This talk shows how to get 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. 😉