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 45F1D10095 for ; Thu, 4 Jul 2013 22:19:24 +0000 (UTC) Received: (qmail 8986 invoked by uid 500); 4 Jul 2013 22:19:22 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 8960 invoked by uid 500); 4 Jul 2013 22:19:21 -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 8950 invoked by uid 99); 4 Jul 2013 22:19:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Jul 2013 22:19:21 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of ruidevieira@googlemail.com designates 209.85.214.42 as permitted sender) Received: from [209.85.214.42] (HELO mail-bk0-f42.google.com) (209.85.214.42) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Jul 2013 22:19:16 +0000 Received: by mail-bk0-f42.google.com with SMTP id jk13so830039bkc.15 for ; Thu, 04 Jul 2013 15:18:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=ZHLkKZ+PBZ4qPKdR+WlykVqr8ocxOl2Nf/lnxEY5IUM=; b=c28E679qlRqG7ltSNNk7VavHYxe5Ld5FXQaWDE2CQ9hLD4bv27MswF8Z+fhICHKnfg 7Pz6CnU39dNLGEVygz+okqbSh7cZ3bovffRI5Tm5pD4CVXOtDxLtvzus5TiVuqo1cLym h3KUCw4FzuaMUC+1UbhBw49rE1chbwK6ZzAdUhhtL/B3MV1doyl7bEw4lWt2n9iTuHzl Zjq6OQA9oAWnMpSgGx03tdhcUJEp8opoOkk5BoqTpbrLFQmFBxunqijcff3nDEmUYvWU PBYbcNNYLpi5FPwZjb/9Xbp7pRkzHpVaWVSL8WcSnCPjTMB2BR4Nsm/4Ohwth611GnmK +42Q== X-Received: by 10.204.227.196 with SMTP id jb4mr1331241bkb.96.1372976335864; Thu, 04 Jul 2013 15:18:55 -0700 (PDT) MIME-Version: 1.0 Received: by 10.204.188.8 with HTTP; Thu, 4 Jul 2013 15:18:15 -0700 (PDT) In-Reply-To: References: <1372974827.10182.YahooMailNeo@web121802.mail.ne1.yahoo.com> From: Rui Vieira Date: Thu, 4 Jul 2013 23:18:15 +0100 Message-ID: Subject: Re: CQL and IN To: user@cassandra.apache.org, Tony Anecito Content-Type: multipart/alternative; boundary=485b3970d2e4c8f7ee04e0b6f66c X-Virus-Checked: Checked by ClamAV on apache.org --485b3970d2e4c8f7ee04e0b6f66c Content-Type: text/plain; charset=ISO-8859-1 You can use the actual item_ids however, Select * from items Where item_id IN (1, 2, 3, ..., n) On 4 July 2013 23:16, Rui Vieira wrote: > CQL does not support sub-queries. > > > On 4 July 2013 22:53, Tony Anecito wrote: > >> Hi All, >> >> I am using the DataStax driver and got prepared to work. When I tried to >> use the "IN" keyword with a SQL it did not work. According to DataStax IN >> should work. >> >> So if I tried: >> >> Select * from items Where item_id IN (Select item_id FROM users where >> user_id = ?) >> >> >> Thanks for the feedback. >> -Tony >> > > --485b3970d2e4c8f7ee04e0b6f66c Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

You can use the actual item_ids however,=A0

Select * from items Where item_id IN (1, 2, 3= , ..., n)

On 4 Ju= ly 2013 23:16, Rui Vieira <ruidevieira@googlemail.com> wrote:

CQL does not support sub-qu= eries.

On 4 July 2013 22:53, Tony Anecito <adane= cito@yahoo.com> wrote:

Hi All,

=A0

I am using the DataStax driver and got prepared to work. When I tried = to use the "IN" keyword with a SQL it did not work. According to = DataStax IN should work.

=A0

So if I tried:

=A0

Select * from items Where item_id IN (Select item_id FROM users where = user_id =3D ?)

=A0

=A0

Thanks for the feedback.

-Tony

--485b3970d2e4c8f7ee04e0b6f66c--