Re: get_indexed_slices && sorting

2010-09-11 Thread Jonathan Ellis
Not until https://issues.apache.org/jira/browse/CASSANDRA-1339 is done On Sat, Sep 11, 2010 at 3:35 PM, Petr Odut wrote: > Hi, > I can't test new IndexOperators so I would like to ask you whether new > Cassandra 0.7 sorts the results - i.e. I have an secondary index on "age" of > "user" cf and I

Re: what is best way to do load balance if cluster has Imbalance load

2010-09-11 Thread aaron morton
That script is for use with the random partitioner, when using the order preserving partitioner the tokens have to be manually selected to best distribute the load. See the section on Token Selection here http://wiki.apache.org/cassandra/Operations Aaron On 12 Sep 2010, at 04:05, March, And

Re: get_indexed_slices && sorting

2010-09-11 Thread Frank LoVecchio
I actually need a similar query; can someone update the wiki on adding a secondary index in 0.7? http://wiki.apache.org/cassandra/SecondaryIndexes Thanks, Frank On Sat, Sep 11, 2010 at 2:35 PM, Petr Odut wrote: > Hi, > I can't test new IndexOperators so I would like to ask you whether new > Ca

get_indexed_slices && sorting

2010-09-11 Thread Petr Odut
Hi, I can't test new IndexOperators so I would like to ask you whether new Cassandra 0.7 sorts the results - i.e. I have an secondary index on "age" of "user" cf and I want to get top 10 oldest users. Can cassandra do this? Thanks, Petr

Re: what is best way to do load balance if cluster has Imbalance load

2010-09-11 Thread March, Andres
It should be simpler than that if the wiki is correct. Search the list archives or wiki for the small script that calculates what the token should be for each node. After that it should be as simple as using nodetool move on one node at a time. On Sep 11, 2010, at 2:00 AM, aaron morton wrote:

Re: 4k keyspaces... Maybe we're doing it wrong?

2010-09-11 Thread samal gorai
Lot of memtables means lot of sstables means lot of disk io. On 9/7/10, Benjamin Black wrote: > On Mon, Sep 6, 2010 at 12:41 AM, Janne Jalkanen > wrote: >> >> So if I read this right, using lots of CF's is also a Bad Idea(tm)? >> > > Yes, lots of CFs is bad means lots of CFs is also bad. > --

Re: what is best way to do load balance if cluster has Imbalance load

2010-09-11 Thread aaron morton
See the section on Moving or Removing nodes here http://wiki.apache.org/cassandra/Operations you should also read the bootstrapping section as that is essentially what you are doing. AFAIK you should use nodetool move to assign a new token to the nodes. As you say, loadbalance is not recommende

what is best way to do load balance if cluster has Imbalance load

2010-09-11 Thread maneela a
we have a Cassandra set up running with 4 nodes with Reflicationfactor:2 and OrderPreservingPartitioner as partitioner but we have not provided InitialToken values. Could some one suggest me what is best way to balance my cluster because some of user threads have suggested "do not ever run nodet