Re: Customized Secondary Index Schema

2011-08-25 Thread Alvin UW
Yes, this is what I am worrying about. 2011/8/24 Ryan King r...@twitter.com On Tue, Aug 23, 2011 at 10:03 AM, Alvin UW alvi...@gmail.com wrote: Hello, As mentioned by Ed Anuff in his blog and slides, one way to build customized secondary index is: We use one CF, each row to represent

Re: Customized Secondary Index Schema

2011-08-25 Thread Ed Anuff
How many unique last names do you anticipate having? How many characters in the last name do you anticipate keeping in your index? You can easily do the math to figure out how many you could fit on a node. I think you'll find that the ceiling might be quite a bit higher than you think. If you

Re: Customized Secondary Index Schema

2011-08-25 Thread Konstantin Naryshkin
, 2011 12:48:49 PM Subject: Re: Customized Secondary Index Schema How many unique last names do you anticipate having? How many characters in the last name do you anticipate keeping in your index? You can easily do the math to figure out how many you could fit on a node. I think you'll find

Re: Customized Secondary Index Schema

2011-08-25 Thread Ed Anuff
name. This will ensure that your index is evenly distributed throughout your cluster. - Original Message - From: Ed Anuff e...@anuff.com To: user@cassandra.apache.org Sent: Thursday, August 25, 2011 12:48:49 PM Subject: Re: Customized Secondary Index Schema How many unique last names

Re: Customized Secondary Index Schema

2011-08-25 Thread Alvin UW
the matching main column family key as the column name. This will ensure that your index is evenly distributed throughout your cluster. - Original Message - From: Ed Anuff e...@anuff.com To: user@cassandra.apache.org Sent: Thursday, August 25, 2011 12:48:49 PM Subject: Re: Customized Secondary

Re: Customized Secondary Index Schema

2011-08-25 Thread Konstantin Naryshkin
be read together. If you are going to query for all of them at the same time anyways, this disadvantage does not apply to you. - Original Message - From: Alvin UW alvi...@gmail.com To: user@cassandra.apache.org Sent: Thursday, August 25, 2011 5:11:07 PM Subject: Re: Customized Secondary Index

Re: Customized Secondary Index Schema

2011-08-24 Thread aaron morton
IMHO it's only a scalability problem if those nodes have trouble handling the throughput. The load will go all all replicas, not one, unless you turn off Read Repair. If it is a problem then you could manually partition the index into multiple rows, bit of a pain thought. I'd wait and see, or

Re: Customized Secondary Index Schema

2011-08-24 Thread Alvin UW
Thanks. 2011/8/24 aaron morton aa...@thelastpickle.com IMHO it's only a scalability problem if those nodes have trouble handling the throughput. The load will go all all replicas, not one, unless you turn off Read Repair. If it is a problem then you could manually partition the index into

Re: Customized Secondary Index Schema

2011-08-24 Thread Ryan King
On Tue, Aug 23, 2011 at 10:03 AM, Alvin UW alvi...@gmail.com wrote: Hello, As mentioned by Ed Anuff in his blog and slides, one way to build customized secondary index is: We use one CF, each row to represent a secondary index, with the secondary index name as row key. For example,

Customized Secondary Index Schema

2011-08-23 Thread Alvin UW
Hello, As mentioned by Ed Anuff in his blog and slides, one way to build customized secondary index is: We use one CF, each row to represent a secondary index, with the secondary index name as row key. For example, Indexes = { User_Keys_By_Last_Name : { adams : e5d61f2b-…, alden : e80a17ba-…,