incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From paul cannon <p...@datastax.com>
Subject Re: Cql 3 wide rows filter expressions in where clause
Date Tue, 01 May 2012 03:22:27 GMT
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.

p

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

Mime
View raw message