HN Explorer

4 comments

[ 2.1 ms ] story [ 20.5 ms ] thread
tbragin
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.

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