Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0E94AC823 for ; Tue, 1 May 2012 03:23:17 +0000 (UTC) Received: (qmail 9971 invoked by uid 500); 1 May 2012 03:23:14 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 9932 invoked by uid 500); 1 May 2012 03:23:14 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 9899 invoked by uid 99); 1 May 2012 03:23:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 May 2012 03:23:13 +0000 X-ASF-Spam-Status: No, hits=2.8 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of paul@datastax.com designates 209.85.213.172 as permitted sender) Received: from [209.85.213.172] (HELO mail-yx0-f172.google.com) (209.85.213.172) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 May 2012 03:23:08 +0000 Received: by yenr9 with SMTP id r9so47331yen.31 for ; Mon, 30 Apr 2012 20:22:47 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:x-gm-message-state; bh=Rm1/0JR/XTML29VG1dRrbT8GSF4XCpNoxDZVZRjvLHo=; b=eZgr0uiauBG6yYbZTReghVDIzPv8WvqdVPF6ZaS9bdM2jgKj5aeqCsmg415K2isfV+ p1d6jRsyTjMO7z26wocxosK63A552YY06AjfW/YSKBD0cpiWPulZnLwi0VfQV/hS4xqL w050+NMQEypX+1pxJGX8o1+Z4fIlQVRWqONMbqnlZzK9CyC8G+IAOtLCV8XaMhYfpD9i y1bkTJeT54RlHNnLI/LANvTOTxdrpHj5WZE+JScIMFwTOvoke+nO/GP3CHgAnY74B4Sb lVJdyvo+klU221Lyan70JPXtAo5KX85QUaWc7YGHO7U6g+u8c3izub/eAQyOraTUJ7M+ ZVZw== Received: by 10.236.72.138 with SMTP id t10mr25119816yhd.109.1335842567621; Mon, 30 Apr 2012 20:22:47 -0700 (PDT) MIME-Version: 1.0 Received: by 10.146.244.17 with HTTP; Mon, 30 Apr 2012 20:22:27 -0700 (PDT) In-Reply-To: References: <1334984372045-7486344.post@n2.nabble.com> From: paul cannon Date: Mon, 30 Apr 2012 22:22:27 -0500 Message-ID: Subject: Re: Cql 3 wide rows filter expressions in where clause To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=20cf300fb169b80c4304bef1151c X-Gm-Message-State: ALoCoQkR4Tj6aFziZSAgjmuj5KFKsLQ556EQpEZE7C5El9hWybcizYei/IeehC257RfqSVUqUhno X-Virus-Checked: Checked by ClamAV on apache.org --20cf300fb169b80c4304bef1151c Content-Type: text/plain; charset=UTF-8 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 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 > 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 > --20cf300fb169b80c4304bef1151c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable CQL doesn't currently let you filter on columns which aren't part o= f a primary key or indexed, so the "and x=3D2 and z=3D2" 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. =C2=A0I don't see anything obviously wrong with your<= br> 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 sup= port
> for filtering wide rows by additional filter expressions in where clau= se
> (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,<= br> > PRIMARY KEY(k, o));
>
> is it possible to have a query
>
> select * from scf where k=3D1 and x=3D2 and z=3D2 order by o ASC;
>
> I tried this with 1.1-rc and it doesnt work as expected. Also looked a= t
> cql_tests.py in https://issues.apache.org/jira/browse/CASSANDR= A-2474 =C2=A0there
> 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-expressi= ons-in-where-clause-tp7486344p7486344.html
> Sent from the c= assandra-user@incubator.apache.org mailing list archive at Nabble.com.<= br>


--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.c= om

--20cf300fb169b80c4304bef1151c--