You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Tharindu Mathew <mc...@gmail.com> on 2012/02/09 20:31:59 UTC
Re: Tips for using OrderedPartitioner
That sounds like writing a DB... indexing the index row.... :)
By making the keys uniform.... Do you mean like keep the initial X
characters the same or the last Y the same... Could you elaborate, please?
Also, if there's hot spot is there any way out of it, other than restarting
from scratch...
On Tue, Jan 24, 2012 at 3:50 PM, R. Verlangen <ro...@us2.nl> wrote:
> If you would like to index your rows in an "index-row", you could also
> choose for indexing the "index-rows". This will scale up for any needs and
> create a tree structure.
>
>
> 2012/1/24 aaron morton <aa...@thelastpickle.com>
>
>> Nothing I can thin of other than making the keys uniform.
>>
>> Having a single index row with the RP can be a pain. Is there a way to
>> partition it ?
>>
>> Cheers
>>
>>
>> -----------------
>> Aaron Morton
>> Freelance Developer
>> @aaronmorton
>> http://www.thelastpickle.com
>>
>> On 23/01/2012, at 11:42 PM, Tharindu Mathew wrote:
>>
>> Hi,
>>
>> We use Cassandra in a way we always want to range slice queries. Because,
>> of the tendency to create hotspots with OrderedPartioner we decided to use
>> RandomPartitioner. Then we would use, a row as an index row, holding values
>> of the other row keys of the CF.
>>
>> I feel this has become a burden and would like to move to an
>> OrderedPartioner to avoid this work around. The index row workaround which
>> has become cumbersome when we query the data store.
>>
>> Is there any tips we can follow to allow for lesser amount of hot spots?
>>
>> --
>> Regards,
>>
>> Tharindu
>>
>> blog: http://mackiemathew.com/
>>
>>
>>
>
--
Regards,
Tharindu
blog: http://mackiemathew.com/
Re: Tips for using OrderedPartitioner
Posted by aaron morton <aa...@thelastpickle.com>.
> Also, if there's hot spot is there any way out of it, other than restarting from scratch…
A cluster with a changed partitioner is like a mule with a spinning wheel. No one knows how it changed and danged if it knows how to return your data .
(You cannot change it.)
By uniform I meat evenly distributed across the range of values. That is what the RandomPartitioner does by using the MD5 transform (also means we know that the tokens have finite range).
Cheers
-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 10/02/2012, at 8:31 AM, Tharindu Mathew wrote:
> That sounds like writing a DB... indexing the index row.... :)
>
> By making the keys uniform.... Do you mean like keep the initial X characters the same or the last Y the same... Could you elaborate, please?
>
> Also, if there's hot spot is there any way out of it, other than restarting from scratch...
>
> On Tue, Jan 24, 2012 at 3:50 PM, R. Verlangen <ro...@us2.nl> wrote:
> If you would like to index your rows in an "index-row", you could also choose for indexing the "index-rows". This will scale up for any needs and create a tree structure.
>
>
> 2012/1/24 aaron morton <aa...@thelastpickle.com>
> Nothing I can thin of other than making the keys uniform.
>
> Having a single index row with the RP can be a pain. Is there a way to partition it ?
>
> Cheers
>
>
> -----------------
> Aaron Morton
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 23/01/2012, at 11:42 PM, Tharindu Mathew wrote:
>
>> Hi,
>>
>> We use Cassandra in a way we always want to range slice queries. Because, of the tendency to create hotspots with OrderedPartioner we decided to use RandomPartitioner. Then we would use, a row as an index row, holding values of the other row keys of the CF.
>>
>> I feel this has become a burden and would like to move to an OrderedPartioner to avoid this work around. The index row workaround which has become cumbersome when we query the data store.
>>
>> Is there any tips we can follow to allow for lesser amount of hot spots?
>>
>> --
>> Regards,
>>
>> Tharindu
>>
>> blog: http://mackiemathew.com/
>>
>
>
>
>
>
> --
> Regards,
>
> Tharindu
>
> blog: http://mackiemathew.com/
>