Re: composite indexes?
Hi, maybe you are looking for asynchronous triggers... https://issues.apache.org/jira/browse/CASSANDRA-1311 http://maxgrinev.com/2010/07/23/extending-cassandra-with-asynchronous-triggers/ Augi
composite indexes?
Is this on the roadmap? I guess I cant see why it wouldnt be and we would be happy to supply patches if they were to be accepted, just puzzled by the seeming lack of interest. cheers Colin
Re: composite indexes?
Can you start with the problem you are trying to solve, before we decide if composite indexes is the right solution? :) On Wed, Sep 22, 2010 at 11:28 PM, Colin Taylor colin.tay...@gmail.com wrote: Is this on the roadmap? I guess I cant see why it wouldnt be and we would be happy to supply patches if they were to be accepted, just puzzled by the seeming lack of interest. cheers Colin -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Cassandra support http://riptano.com
Re: composite indexes?
On Fri, Sep 24, 2010 at 9:15 AM, Jonathan Ellis jbel...@gmail.com wrote: Can you start with the problem you are trying to solve, before we decide if composite indexes is the right solution? :) In this case we have a large number of transactions, each with a date, type, detail etc. We are mostly looking for transactions between certain dates that have a certain value in one of the other fields. By maintaining a separate ColumnFamily (index) with a row key of the date + type we can easily find the transactions of a specific type on a certain day. All you need to do is concatenate the date and type, and look up the index. Currently we are maintaining the indexes ourselves. The new server side indexing function looks interesting, but only seems to permit one column. Allowing the index key to be multiple columns concatenated would permit a search based on multiple column values.