CQL doesn't currently let you filter on columns which aren't part of a primary key or indexed, so the "and x=2 and z=2" part of your query is not valid.


On Mon, Apr 30, 2012 at 8:54 PM, Jonathan Ellis <jbellis@gmail.com> wrote:
That should work.  I don't see anything obviously wrong with your
query, other than the trivial (ascii values need to be quoted).
Assuming that's not the problem, please file a ticket if you have a
failing test case.

On Fri, Apr 20, 2012 at 11:59 PM, Nagaraj J <nagaraj.pesit@gmail.com> wrote:
> Hi
> cql 3 for wide rows is very promising. I was wondering if there is support
> for filtering wide rows by additional filter expressions in where clause
> (columns other than those which are part of the composite).
> Ex.
> suppose i have sparse cf
> create columnfamily scf( k ascii, o ascii, x ascii, y ascii, z ascii,
> PRIMARY KEY(k, o));
> is it possible to have a query
> select * from scf where k=1 and x=2 and z=2 order by o ASC;
> I tried this with 1.1-rc and it doesnt work as expected. Also looked at
> cql_tests.py in https://issues.apache.org/jira/browse/CASSANDRA-2474  there
> is no mention of this.
> Am i missing something here ?
> Thanks in advance
> Nagaraj
> --
> View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cql-3-wide-rows-filter-expressions-in-where-clause-tp7486344p7486344.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support