News for hackers. Stuff that matters.
Re:Druid: fast column-oriented distributed data store by jnordwick on Thursday March 31, 2016 @06:21PM (#11401044)
Every open source column database I've seen is very poor: text, no decent array oriented ability (give me the prevoius row), slow, json output, etc. When will somebody get it right?
Re:Druid: fast column-oriented distributed data store by ktamura on Thursday March 31, 2016 @06:42PM (#11401176)
This is simply false. PostgreSQL + cstore_ftw, Presto, Impala, etc. all support "array oriented ability" via window functions.
Re:Druid: fast column-oriented distributed data store by jnordwick on Thursday March 31, 2016 @07:07PM (#11401305)
I mean like give me the preceding row from the current. Very useful for calculating anything from a simple rate of change to a properly doing a temporal database. Arrays as a column type doesn't get you that.
Re:Druid: fast column-oriented distributed data store by teraflop on Thursday March 31, 2016 @07:30PM (#11401412)
No, but window functions do, unless I'm not understanding what your goal is.

http://www.postgresql.org/docs/current/static/functions-wind...

Re:Druid: fast column-oriented distributed data store by jnordwick on Friday April 01, 2016 @09:45AM (#11404696)
I actually was using that yesterday. So so so so very very very very slow.
Re:Druid: fast column-oriented distributed data store by slachterman on Thursday March 31, 2016 @07:32PM (#11401418)
Re:Druid: fast column-oriented distributed data store by jnordwick on Friday April 01, 2016 @09:44AM (#11404694)
So do most databased, but they are SLOOOOOOOW.