3 ms·
A practical approach to schema changes in ClickHouse
- tbragin 3y agoCool article! I like the practical advice on managing schema changes. I hope you don't mind me sharing on other platforms. Thank you! Disclaimer: I work at ClickHouse.
- AntonFriberg 3y agoAuthor here, thanks! Feel free to share it on other platforms. Let me know if you have any questions.
- Randalthorro 3y agoReally great stuff. It's a pain to do schema management with clickhouse when materialized views start coming into the picture.
- AntonFriberg 3y agoThanks Randal! I hope to be able to complete a follow-up post on how to automate most of the schema changes by utilizing a form of data contract with the data owner of each metric table. It is very easy to roll out incorrect changes when working with the materialized views in a sharded ClickHouse table due to the need to having to toggle the materialized view and distributed tables when changing the underlying long-term storage tables.