Ask HN: Which is a good Column Store database?

7 points by hyuen ↗ HN
I am looking for an Open Source Column Store DB, but seems like there is no dominant one around. Can you suggest me some to look at?

Thanks

9 comments

[ 3.5 ms ] story [ 34.7 ms ] thread
If looking to scale and store massive amount of data over multiple machines checkout Apache Cassandra. Otherwise, BerkeleyDB should be sufficient.
It might be better to say what use case you're looking for and then go from there.

Column-oriented storage is basically an implementation detail for exploiting certain types of data-locality patterns; there may be things which fit your needs which exploit that in different ways.

I am looking for something for analytics, I am interested in column storage specifically on something that supports compression. At this point I guess data can fit in one machine, so clustering would be desirable, but not mandatory.
Check out InfoBright. It has a free version that has most features you're going to need. There are some bugs, but they're working through them pretty quickly.