3 ms·

Can it run on a cluster? Or single server only? Can you update specific rows? How fast are updates? How does it compare to monetDB.

• eldargab 8y ago
  monetDB is a sort of drop-in replacement for a regular database with all expected features and good compatibility. On other hand ClickHouse will be incompatible with most of existing tools and it's better to learn well its limitations and workaround technics in advance. But once you dump into it substantial amounts of time series data you'll find it 10+ times faster and 2-3 times smaller than monet.
  • bicubic 8y ago
    Is there a way to handle scenarios where the data does update? Like backfill of latent events within a 1-2 day window.
    • sin7 8y ago
      You can copy the stable data to another table, then insert the updated data. The database has excellent compression and copying from one table to another is super fast.
• sin7 8y ago
  You can run it on a cluster or a single server. It's pretty easy to setup either way. No updates. Fast inserts. You can only join two tables at a time, but the joins can be chained to deal with this limitation. I tried Monet. It wasn't very stable for me. I didn't stick with it long enough to judge it. ClickHouse has backing of Yandex. I think that makes a huge difference. I have used Clickhouse for the past year. Thrown 3000 column by 120 million row tables on it. It worked where PostgreSQL came to a halt. Different use cases really. I fits my use case perfectly. Large amounts of data with no updates and tons of aggregations. It's lighting fast.
  • manigandham 8y ago
    It does support updates and deletes now, but still limited.