A Day in the Life of a ClickHouse® Query - Intro to ClickHouse Internals | Tutorial on ClickHouse

Have questions about ClickHouse®? Get a free consultation with Altinity. Book a call here: hubs.la/Q02qr1RZ0 . No marketing BS. no sales talk during the call. Just answers to your questions.
______________________
Our latest webinar, hosted by Robert Hodges (Altinity CEO), is a gentle introduction to ClickHouse internals, focusing on topics that will help your applications run faster and more efficiently.
Find answers to common questions re: ClickHouse queries.
1. Why do queries run out of memory?
2. How can you make your queries even faster?
3. How should you size ClickHouse nodes for best cost-efficiency?
The key to these questions and many others is knowing what happens inside ClickHouse when a query runs. We’ll discuss the basic flow of query execution, dig into how ClickHouse handles aggregation and joins, and show you how ClickHouse distributes processing within a single CPU as well as across many nodes in the network.
Want the webinar slides? 👉🏼 www.slideshare.net/Altinity/a...
0:00 Introduction
5:54 Understand the engine
9:35 Processing INSERT
11:16 Improving efficiency
18:02 What happens when you INSERT?
20:07 MergeTree
27:34 Optimize INSERT
29:19 Aggregation
30:10 Process a query with Aggregates
32:33 Compute an average in parallel
33:55 ClickHouse thread doing Aggregation
35:14 Aggregation performance drivers
37:28 ClickHouse memory limits
38:47 Make aggregation queries faster
40:07 Reduce memory usage in aggregation queries
40:58 JOIN combines data between tables
42:10 Process a query with a JOIN
47:21 Example of a distributed dataset
50:22 ClickHouse pushes down JOINs by default
#ClickHouseQueries #ClickHouseTraining #ClickHouseTutorial #OpenSourceDatabase #ClickHouseCommunity
--------------
Join Altinity Meetups on ClickHouse: www.meetup.com/san-francisco-...
Check out more resources on ClickHouse: altinity.com/resources/
Visit the Altinity Documentation site: docs.altinity.com/
Contribute to Altinity Knowledge Base for ClickHouse: kb.altinity.com/
Join the Reddit community for ClickHouse: / clickhouse
-------------
More about Altinity! 💡
Site: www.altinity.com​
LinkedIn: / altinity
Twitter: / altinitydb
Slack: altinity.com/slack

[@Altinity]

Want to be the smartest ClickHouse developer in the room?
Then sign up to our newsletter to get ClickHouse tips and tricks straight to your inbox. Sign up here: hubs.ly/Q02pp8vh0

[@SanteeRocks]

Night job: Clickhouse expert 😊

[@Altinity]

Get curated ClickHouse tips and tricks straight to your inbox. Sign up to our newsletter: hubs.ly/Q02pp8vh0