Hacker News new | ask | show | jobs
A practical approach to schema changes in ClickHouse (engineeringat.axis.com)
7 points by AntonFriberg 927 days ago
2 comments
tbragin 927 days ago
Cool 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.

link
AntonFriberg 927 days ago
Author here, thanks! Feel free to share it on other platforms. Let me know if you have any questions.
link
Randalthorro 927 days ago
Really great stuff. It's a pain to do schema management with clickhouse when materialized views start coming into the picture.
link
AntonFriberg 927 days ago
Thanks 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.
link