cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Ellis <jbel...@gmail.com>
Subject Re: Cql 3 wide rows filter expressions in where clause
Date Tue, 01 May 2012 01:54:23 GMT
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
http://www.datastax.com

Mime
View raw message