ClickHouse is great. Been using it without any major issues.

We started experiencing some issues with data duplication with ClickHouse when we moved our table to a Sharded+Replicated setup.

Optimize with DEDUPLICATE helped us a lot.. and we can just run this on a Partition instead of the full table.

https://clickhouse.com/docs/en/sql-reference/statements/opti...

ClickHouse is a very powerful system but it's not just setup and forget type.