Re: how to do a get_range_slices where all keys start with same string

2011-01-12 Thread Stephen Connolly
or set the end key to com.googlf On 12 January 2011 02:49, Aaron Morton aa...@thelastpickle.com wrote: If you were using OPP and get_range_slices then set the start_key to be com.google and the end_key to be . Get is slices of say 1,000 (use the last key read as the next start_ket) and when

Re: how to do a get_range_slices where all keys start with same string

2011-01-11 Thread Tyler Hobbs
That type of operation only works (directly) when using an OrderPreservingPartitioner. There are a lot of downsides to OPP: http://ria101.wordpress.com/2010/02/22/cassandra-randompartitioner-vs-orderpreservingpartitioner/ You can instead order your keys alphabetically as column names in a row

Re: how to do a get_range_slices where all keys start with same string

2011-01-11 Thread Jonathan Ellis
http://wiki.apache.org/cassandra/FAQ#range_rp also, start==end==x means give me back exactly row x, if it exists. IF you were using OPP you'd need end=y. On Tue, Jan 11, 2011 at 7:45 PM, Koert Kuipers koert.kuip...@diamondnotch.com wrote: I would like to do a get_range_slices for all keys

RE: how to do a get_range_slices where all keys start with same string

2011-01-11 Thread Koert Kuipers
Ok I see get_range_slice is really only useful for paging with RP... So if I were using OPP (which I am not) and I wanted all keys starting with com.google, what should my start_key and end_key be? -Original Message- From: Jonathan Ellis [mailto:jbel...@gmail.com] Sent: Tuesday,

Re: how to do a get_range_slices where all keys start with same string

2011-01-11 Thread Roshan Dawrani
On Wed, Jan 12, 2011 at 7:41 AM, Koert Kuipers koert.kuip...@diamondnotch.com wrote: Ok I see get_range_slice is really only useful for paging with RP... So if I were using OPP (which I am not) and I wanted all keys starting with com.google, what should my start_key and end_key be? I think

Re: how to do a get_range_slices where all keys start with same string

2011-01-11 Thread Aaron Morton
If you were using OPP and get_range_slices then set the start_key to be "com.google" and the end_key to be "". Get is slices of say 1,000 (use the last key read as the next start_ket) and when you see the first key that does not start with com.google top making calls.If you move the data from rows

Re: how to do a get_range_slices where all keys start with same string

2011-01-11 Thread Arijit Mukherjee
I have a follow on question on this. I have a super column family like this: ColumnFamily Name=EventSpace CompareWith=TimeUUIDType CompareSubcolumnsWith=BytesType ColumnType=Super/ I store some events keyed by a subscriber id, and for each such row, I have a number of super columns which are