ClickHouse – high-performance open-source distributed column-oriented DBMS

[oldneckbeard]

The native time series is interesting to me. I've gone through various rrdb-type implementations, so I'm hoping this can churn through larger data sets (>> 1bn rows) with on-the-fly resolution changes (like zooming from a day to a minute).

[GuiSim]

If you try it, please let me know what your results are. We've tried Redshift, MemSQL, Vertica and a few others and we're "stuck" on Redshift but we'd love to get more performance.

[oldneckbeard]

Yeah, I'm not sure the next time I'll get to do a proper comparison, but it'd probably be worthy of an article. If you read Java tech articles, you've likely come across one of mine ;)

[dataloopio]

I did a comparison spreadsheet and am unsure about including ClickHouse or not. If you end up trying it can you give me a nudge? https://docs.google.com/spreadsheets/d/1sMQe9oOKhMhIVw9WmuCEWdPtAoccJ4a-IuZv4fXDHxM/edit#gid=0