New Tips and Tricks that Every ClickHouse® Developer Should Know | ClickHouse Webinar
Have questions about ClickHouse®? Get a free consultation with Altinity.
No pressure, no sales talk. Just answers to your questions. Book a free help session: https://hubs.la/Q02qr1RZ0
______________________________
Are you building analytic applications on #ClickHouse? Great choice!
In this talk, Robert Hodges (@Altinity CEO) shows 7 tricks to develop analytic apps that are fast, cost-efficient, and easy to maintain, such as loading data from S3, using aggregation instead of joins, applying materialized views, using compression effectively, and many more.
You also gain insight into how column storage, parallel processing, and distributed algorithms make ClickHouse the fastest analytic database on the planet. Stick around to witness the power of real-time data!
========================
CHAPTERS
========================
0:00 - Introduction
08:10 - Read S3 data fast with wildcards and named collections
15:25 - Reduce storage size using codecs and compression
24:30 - Repeat time column in ORDER BY to speed up time-based queries
32:55 - Handle mutable data with ReplacingMergeTree
41:40 - Store RBAC model in Zookeeper (or clickhouse-keeper)
48:10 - Use aggregation to simulate joins
========================
PRESENTATION SLIDES
========================
https://altinity.com/New-Tips-and-Tri...
==================================
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
#Altinity #datanalytics #opensource #datawarehouse #database #devops #realtime #datanalytics #datamanagement #dbms #dbmstutorials #developerscommunity #developers #opensourcecommunity #materializedviews #objectstorage #webinar #tipsandtricks #zookeeper