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.pe...@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-u...@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 http://www.datastax.com
