Size Matters: Best Practices for Trillion Row Datasets on ClickHouse® | ClickHouse® Webinar

Have questions about ClickHouse®? Get a free consultation with Altinity.

No marketing BS. no sales talk during the call. Just answers to your questions. Book a free help session: https://hubs.la/Q02qr1RZ0.

_____________

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

========================
PRESENTATION SLIDES
========================
https://altinity.com/webinarspage/siz...

==================================
MANAGED CLOUD FOR CLICKHOUSE
==================================
https://altinity.com/managed-clickhouse/

====================
RESOURCES
====================
Altinity Knowledge Base for ClickHouse: https://kb.altinity.com/
Altinity Documentation for ClickHouse: https://docs.altinity.com
Altinity Stable Builds for ClickHouse: https://altinity.com/altinity-stable/
Training for ClickHouse: https://altinity.com/clickhouse-train...
Altinity vs other ClickHouse vendors: https://altinity.com/altinity-cloud-v...

====================
COMMUNITY
====================
🧑🏽‍💻 Join the Community: https://www.altinity.com/slack
🙋🏽 Get Support on Slack: https://www.altinity.com/slack
⭐️ Star on GitHub: https://github.com/Altinity/
🌐 Connect on LI:   / 10955938  
🌐 Follow on 𝕏:   / altinitydb  
🌐 Say Hi on Reddit:   / clickhouse  

#ClickHouse #datasets #opensource #altinity #opensourcecommunity #realtimeanalytics #olap #bigdataanalytics #realtimedata #developers #developerscommunity #dbaas #bigdata #datawarehouse