News for hackers. Stuff that matters.
Re:ClickHouse – high-performance open-source distributed col... by slagfart on Wednesday June 15, 2016 @08:44AM (#11908931)
Actually, the benchmarks aren't against alternative columnstore DBs, which would really put proof on their claims. Would love to see a comparison with Greenplum or Redshift.

For those who haven't worked with them before, columnstore databases are clever, but also do as much processing as they can at ingestion time, so that they can have good SELECT benchmarks later.

Re:ClickHouse – high-performance open-source distributed col... by RMarcus on Wednesday June 15, 2016 @08:54AM (#11908995)
Vertica is a pretty large commercial column store with a lot of customers. Although I'm not sure if the Yandex folks got permission to publish benchmarks about it...

(MonetDB is a classic research columnar database, and I believe MemSQL has a columnar mode. Greenplum is missing, for some reason.)

Re:ClickHouse – high-performance open-source distributed col... by ruw1090 on Wednesday June 15, 2016 @11:45AM (#11910011)
It looks like they benchmarked against MemSQL 3.2, which is nearly 2 years old and Hive .11, which is close to 3 years. Not sure how out of date the other comparisons are.
Re:ClickHouse – high-performance open-source distributed col... by fsaintjacques on Wednesday June 15, 2016 @10:22AM (#11909484)
That's what I want to know, how fast is it agaisn't Vertica.
Re:ClickHouse – high-performance open-source distributed col... by RMarcus on Wednesday June 15, 2016 @10:33AM (#11909567)
Well, they have benchmarks! Against Vertica! Which is surprising, because I imagine Vertica's EULA forbids that.

https://clickhouse.yandex/benchmark.html#["1000000000",["Cli...]

Re:ClickHouse – high-performance open-source distributed col... by overcast on Wednesday June 15, 2016 @02:14PM (#11910938)
Wait, Vertica forbids publishing benchmarks? What exactly are they going to do?
Re:ClickHouse – high-performance open-source distributed col... by EwanToo on Wednesday June 15, 2016 @06:19PM (#11912586)
Clicked one of the vote buttons while trying to hit reply, sorry if it was a down...

Most DB vendors forbid benchmarks, Oracle, IBM DB2, etc, they claim they can remove your rights to run the software if you publish them

Re:ClickHouse – high-performance open-source distributed col... by fsaintjacques on Wednesday June 15, 2016 @10:56AM (#11909699)
sweet, now where can I see the projections :)
Re:ClickHouse – high-performance open-source distributed col... by trungaczne on Wednesday June 15, 2016 @08:47AM (#11908955)
Isn't MonetDB a columnar store? They did benchmark against MonetDB.

Edit: MemSQL too is a columnar store

Re:ClickHouse – high-performance open-source distributed col... by slagfart on Wednesday June 15, 2016 @08:51AM (#11908977)
I stand corrected!

Edit: However, the reference states "At this time (May 2016), there aren't any available open-source and free systems that have all the features listed above". Greenplum does actually implement all of these features, and is open source. I guess I just take issue with all the hyperbole in use.

Re:ClickHouse – high-performance open-source distributed col... by blahi on Wednesday June 15, 2016 @01:21PM (#11910637)
You managed to check all of their docs already? Because as far as I know greenplum doesn't have incremental aggregation.
Re:ClickHouse – high-performance open-source distributed col... by slagfart on Saturday June 18, 2016 @09:03PM (#11931387)
"Incremental Aggregation" is just UPDATE (new value = old value + JOIN value), right? If so, yes :)
Re:ClickHouse – high-performance open-source distributed col... by blahi on Monday June 20, 2016 @07:27AM (#11937312)
Yeah... do you have ANY experience with column stores?
Re:ClickHouse – high-performance open-source distributed col... by jaytaylor on Wednesday June 15, 2016 @12:06PM (#11910149)
Link to greenplum db src code: https://github.com/greenplum-db/gpdb
Re:ClickHouse – high-performance open-source distributed col... by threeseed on Wednesday June 15, 2016 @08:58AM (#11909012)
Actually not all column store databases do work on the ingestion path. Cassandra, HBase etc being notable exceptions. But then again not quite the same use case as the others you mentioned.

This really is begging for a better benchmark.

Re:ClickHouse – high-performance open-source distributed col... by coredog64 on Wednesday June 15, 2016 @09:38AM (#11909219)
I thought Cassandra was all about doing work in the ingestion path. Tables are built to specify very narrow access patterns. Data is streamed to disk in a format that's very efficient to read back later (SSTable).
Re:ClickHouse – high-performance open-source distributed col... by biokoda on Wednesday June 15, 2016 @09:39AM (#11909226)
Cassandra is not a column store.