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 whe

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 wit