Office Hours #17: ReplacingMergeTree & Deduplication in ClickHouse®

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 Questions 3:44 What does ReplacingMergeTree actually do? 5:43 What does the version column control? 6:56 What does FINAL really do? 9:08 How long does deduplication take to happen? 11:45 How do background merges affect deduplication? 12:26 What happens if inserts arrive out of order? 13:30 What’s the best way to implement soft deletes? 17:10 When should I avoid ReplacingMergeTree entirely and use another engine? 22:35: Audience questions ==================== 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 #developer #devops #opensource #officehours #databasemanagement