Size Matters: Best practices for Trillion Row Datasets on ClickHouse® | Webinar for ClickHouse®
Vložit
- čas přidán 5. 08. 2024
- 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.
_____________
ClickHouse is so fast that virtually any developer can get a sub-second response on tables running into billions of rows. It’s different once you reach data sizes in the hundreds of billions or trillions of rows. This webinar walks you through best practices for designing a schema, loading data, and running queries on very large datasets. Expert tricks like combining events in a single fact table, using aggregation to simulate joins, and using materialized views to “index” interesting events in large fact tables are all covered. We’ll even demonstrate the ideas on a trillion-row test data set. Want to scale your data? This webinar is the place to start.
Chapters:
0:00 - 3:24 Introduction
3:25 - 3:57 Introduction to ClickHouse
3:58 - 6:01 ClickHouse Characteristics
6:02 - 11:08 ClickHouse Demo
11:09 - 14:06 Some Definitions to Guide Our Webinar Decision
14:07 - 17:06 Principles of Large Datasets in ClickHouse
17:07 - 35:44 Basic Design for Trillion-Row Tables
35:45 - 48:21 Unique ClickHouse Tricks for Large Datasets
48:22 - 50:39 Wrapping Up!
50:40 - 51:49 Other Techniques for Big Data
51:50 - 1:02:04 Additional Resources & Q&A
#ClickHouse #datasets #ClickHouseTutorial #opensource #ClickHouseCommunity #altinity
--------------
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 - Věda a technologie
Have burning ClickHouse questions?
Book a free session with Altinity (no pressure, no sales talk. Just answers to your questions). Book a call here: hubs.la/Q02qr1Qz0
what a title - "SIZE MATTERS" xD
Jokes aside - its really helpful.
sensor_id could be optimised too to UInt16?
Thanks for the good video. Now I only need to make it work with 400TB of data 😂