News for hackers. Stuff that matters.
Re:ClickHouse – high-performance open-source distributed col... by nfa_backward on Wednesday June 15, 2016 @10:01AM (#11909349)
Looks really interesting and not another SQL on Hadoop solution. The benchmarks look impressive, but all of the queries were aggregations of a single table. I did not see any joins. I wonder how mature the optimizer is.
Re:ClickHouse – high-performance open-source distributed col... by Lethalman on Tuesday June 21, 2016 @04:49AM (#11944416)
I think it's because the docs say "If there isn't enough memory, you can't run a JOIN." . While SQL on Hadoop solutions work also without enough RAM by spilling on disk. I don't think a comparison with JOINs would be fair in this case.