Are you a ClickHouse fan? Want to make your apps faster? This talk introduces ClickHouse internals, focusing on how to make analytic queries faster and more efficient. We'll cover data insertion, aggregation, joins, and distributed queries. You'll learn about the basic flow of query execution, how ClickHouse parallelizes processing, and how it uses memory. We'll also show you standard tools like the system.query_log table that help you diagnose problems, trace distributed queries, and track memory usage. To enjoy the talk, all you need is a basic knowledge of SQL. We'll supply the rest!
Robert Hodges is CEO of Altinity, an enterprise provider for ClickHouse data warehouse. He's also a database geek with experience on at least 20 DBMS types. Robert caught the Kubernetes bug at VMware in 2018.