Re: Retrieving TimeUUID sub-columns in reverse order

2010-12-26 Thread Jonathan Ellis
Better would be to just reverse client-side. On Sun, Dec 26, 2010 at 10:35 PM, Roshan Dawrani wrote: > Thanks, but unfortunately, I need to fetch multiple super columns - each > super column represents a particular "state" and as entities transition from > one state to another, they move from one

Re: The mutations to delete sub-columns can't be batched?

2010-12-26 Thread Roshan Dawrani
There doesn't really seem to be an inherent limitation in batching sub-column deletes. Pelops seem to be doing it - http://pelops.googlecode.com/svn/trunk/src/org/wyki/cassandra/pelops/Mutator.java[deleteSubColumn() / deleteSubColumns()] Is it worth an improvement request on Hector? On Mon, Dec

Re: The mutations to delete sub-columns can't be batched?

2010-12-26 Thread Roshan Dawrani
Which "No"? 1) No, it is "not" correct correct that they can't be batched, or 1) No, they can't be batched :-) On Mon, Dec 27, 2010 at 10:04 AM, Jonathan Ellis wrote: > On Sun, Dec 26, 2010 at 9:14 AM, Roshan Dawrani > wrote: > > Is it correct that mutations that delete subcolumns of a supe

Re: Retrieving TimeUUID sub-columns in reverse order

2010-12-26 Thread Roshan Dawrani
Thanks, but unfortunately, I need to fetch multiple super columns - each super column represents a particular "state" and as entities transition from one state to another, they move from one super column to another. So, there is no way currently I can retrieve multiple super columns with their sub

Re: The mutations to delete sub-columns can't be batched?

2010-12-26 Thread Jonathan Ellis
On Sun, Dec 26, 2010 at 9:14 AM, Roshan Dawrani wrote: > Is it correct that mutations that delete subcolumns of a super column can't > be batched - unlike inserts and deletes of normal columns? No. -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professio

Re: Retrieving TimeUUID sub-columns in reverse order

2010-12-26 Thread Jonathan Ellis
If you are fetching multiple supercolumns, then that's what you can control the order of. If you are slicing within a single supercolumn, the reverse parameter will affect the order of subcolumns. On Sun, Dec 26, 2010 at 6:11 AM, Roshan Dawrani wrote: > Hi Ran, > I am not doing it the YAML way.

I have TimeUUID sorted keys. Can I get the range query return rows in the same order as sorted keys?

2010-12-26 Thread Roshan Dawrani
Hi, I have the following 2 column families - one being used to store full rows for an entity and other is an index table for having the TimeUUID sorted row keys. I am able to query the TimeUUID columns under the super column fine. But now I need to go to main CF and get the data and I want the row

The mutations to delete sub-columns can't be batched?

2010-12-26 Thread Roshan Dawrani
Hi, Is it correct that mutations that delete subcolumns of a super column can't be batched - unlike inserts and deletes of normal columns? If yes, could someone share why that is so? Thanks. -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani

Re: Retrieving TimeUUID sub-columns in reverse order

2010-12-26 Thread Roshan Dawrani
Hi Ran, I am not doing it the YAML way. I am defining my SCF through Hector API as below ThriftCfDef cfDef = HFactory.createColumnFamilyDefinition(ksName, "SCF") cfDef.setColumnMetadata(...) cfDef.setColumnType(ColumnType.SUPER) cfDe

Re: Retrieving TimeUUID sub-columns in reverse order

2010-12-26 Thread Ran Tavory
Roshan, in cassandra.yaml did you define compare_subcolumns_with for the SCF? The subcolumn names are the timeuuid, not the subcolumn values, right? On Sun, Dec 26, 2010 at 9:14 AM, Roshan Dawrani wrote: > Hi, > > I have a super ColumnFamily that has a few super columns, with each having > a gro