Re: CQL 'Where' clause ignores secondary index filter

2012-01-19 Thread Sylvain Lebresne
the column index later will be inefficient. > > > > Thanks again. > > > > Regards, > > Vaibhav > > > > -Original Message- > From: "aaron morton" > Sent: Friday, January 20, 2012 12:23am > To: user@cassandra.apache.org > Subject: Re: CQ

Re: CQL 'Where' clause ignores secondary index filter

2012-01-19 Thread vaibhav . s
gards, Vaibhav -Original Message- From: "aaron morton" Sent: Friday, January 20, 2012 12:23am To: user@cassandra.apache.org Subject: Re: CQL 'Where' clause ignores secondary index filter It is working as expected. Because you have specified a KEY the query returns rec

Re: CQL 'Where' clause ignores secondary index filter

2012-01-19 Thread aaron morton
It is working as expected. Because you have specified a KEY the query returns records that match that key(s), and it ignores the other clauses. Selecting rows follows one of three paths: * selects rows by key(s) * select rows by key range, i.e. rows after this key. * select rows by (secondary

CQL 'Where' clause ignores secondary index filter

2012-01-19 Thread vaibhav . s
Hi, I've defined a column family 'Vaibhav' in which every row has few columns and its values. I've declared two column as secondary index so that I can filter the rows on the basis of those column values. Now whenever I execute a CQL with either only rowkey or column name in 'WHERE' clause