7 ms·
How did you find clickhouse vs drill/dremio? Have you tried maybe both and compared them?
by Keyframe 8y ago
How did you find clickhouse vs drill/dremio? Have you tried maybe both and compared them?
- IanCal 8y agoI'm afraid I've not tried those, I played around only a bit and mostly spent a while trying to get cassandra setup but failed. Then I hit on https://tech.marksblogg.com/benchmarks.html https://tech.marksblogg.com/benchmarks.html and saw clickhouse sitting at a very impressive point given the hardware it's on there. It was one of the few data things I saw that looked like it scaled down to a level relevant for me (cassandra I think talks about a dev setup of 5 servers). It's been fast enough with zero tuning or work so far that I've not done that much. I'm sure I could get closer to its speed by carefully setting some things in postgres, or clever work somewhere but I've got other things to do and that's not my speciality. It has a few issues with ingesting CSV (I end up quoting everything, though I think it's less hassle if you use TSV instead). Frankly, it's been incredible for my analysis work. apt-get install setup, fast to ingest data, easy to query and output large amounts of things. Happily works on a single box, though apparently scales up as well. More than happy to waffle on about this but I'm aware I've gone on very long already for a "I don't know" answer.