Hacker News new | ask | show | jobs
by ing33k 1424 days ago
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.