index partition key

2014-09-18 Thread Marcelo Elias Del Valle
Hi, This question is just for curiosity purposes, I don't need this in my solution, but it's something I was asking myself... Is there a way of indexing the partition key values in Cassandra? Does anyone needed this and found a solution of any kind? For example, I know the sample bellow doesn't

Re: index partition key

2014-09-18 Thread DuyHai Doan
Your query select * from testcf where key1 'Lucas'; does work if you choose the old OrderPartioner but since it's considered absolute evil (for good reason, load distribution is horrendous), pratically it is not possible to do your query. And it's the same thing with secondary index. Query with

Re: index partition key

2014-09-18 Thread Marcelo Elias Del Valle
Yes, indeed using the evil ordered partitioner it would work, but it should be avoided at all costs. What I am trying to figure is: Can I tell Cassandra is not good for cases where you need range queries over all the cluster? It's just a kind of architectural rule I am trying to use to decide