From user-return-35063-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Thu Jul 4 21:54:18 2013 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 A45A810FDF for ; Thu, 4 Jul 2013 21:54:18 +0000 (UTC) Received: (qmail 78861 invoked by uid 500); 4 Jul 2013 21:54:16 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 78838 invoked by uid 500); 4 Jul 2013 21:54:16 -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 78830 invoked by uid 99); 4 Jul 2013 21:54:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Jul 2013 21:54:16 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.138.91.144] (HELO nm14-vm3.bullet.mail.ne1.yahoo.com) (98.138.91.144) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Jul 2013 21:54:08 +0000 Received: from [98.138.90.53] by nm14.bullet.mail.ne1.yahoo.com with NNFMP; 04 Jul 2013 21:53:47 -0000 Received: from [98.138.101.162] by tm6.bullet.mail.ne1.yahoo.com with NNFMP; 04 Jul 2013 21:53:47 -0000 Received: from [127.0.0.1] by omp1073.mail.ne1.yahoo.com with NNFMP; 04 Jul 2013 21:53:47 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 523678.4356.bm@omp1073.mail.ne1.yahoo.com Received: (qmail 55589 invoked by uid 60001); 4 Jul 2013 21:53:47 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1372974827; bh=F1dlNvqwCz1HGSqdm900PzAoUSWLjb11PZcL7tRZDdE=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=tzzLzi3bxaya8PPw4qn3rF99fXOz5D04hEbJTJDCiCg23l3/DwCmPDEu31OiF7w4I1tvNzkApQuZ3CDHZLNkhZLwtRM07rgyOXdtf9lPEnbczTmELz9wpQ9utyrUeYXltD18EergKKRcoA/LTWOaQNUA6ycMF0xt5eDQzTQh5/E= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=HJY6SEUGM3I61iAZqXNr3IzPQ6YonCNPg/NKKzB/wCT2QCyAzYXTqEcTsrVypYnatBbhIU667poW4jJaanJriKlVHLD8iZNXhu6Sp9J0PaowZ7Ev5cOOY9wHaVEa45P/2D1rFY2L3Y0i2SCruIy8jM9/NPKSLA6RC5WP4fckYgg= ; X-YMail-OSG: paDF8_UVM1n.9WG8lr6snnEO8GIILBpDN2IfXMsNNlZpMt4 XkK2sN0_cdeIumYCbXkeDX00UOfJ4_WwcJ31f_QzFuyRwnOCoVFDISojuHy4 Yfwy0jt.nPEHqeIOAl.YtelW21rdrcYoh0yuh9otrpffu8eDuV.jNr_5jC5s 0kOWnoiZQTrJq4hRgP5ZInDQd0ZgF50QqMpfJFQDewLT7PHTywCsqQHp8Mya engb4vRpuMR1L3TINLbW7FL4JxLwQDG7L2dwdoGaCyg1T_W.gDXi_DYYTJHs BsxzpP3itGGZFUu2uLt9ejM6zvOYwOiOVDddBmvo4n0cnPXLTFEnxfTcWUaw ViXmF__EpUZgwvMkqkQEsJKpeOE.3zEYicrfds1IyAWgvGRDkoeU_eQRaCy0 t8RqCqv7b9dVapQEkX0QZio9lF70i.D9Ned1QxDjB5yDNjfHKJeKFzRbMI0K ZX.kpgnn4G6XNE1jeEM7LRMoB64twXh7GPQI0CmBsnSssEe6X7Ipl79s5uZK GtyWPXCEIUl4JeA1.0Z4ReeoBBIZnhiyQmfr_yzggbVWWSgLQpSi70GeICgn 6UDeq3oVDzhkxaeCyNJMmyeKa1Yy5Ow-- Received: from [204.228.207.218] by web121802.mail.ne1.yahoo.com via HTTP; Thu, 04 Jul 2013 14:53:47 PDT X-Rocket-MIMEInfo: 002.001,SGkgQWxsLArCoApJIGFtIHVzaW5nIHRoZSBEYXRhU3RheCBkcml2ZXIgYW5kIGdvdCBwcmVwYXJlZCB0byB3b3JrLiBXaGVuIEkgdHJpZWQgdG8gdXNlIHRoZSAiSU4iIGtleXdvcmQgd2l0aCBhIFNRTCBpdCBkaWQgbm90IHdvcmsuIEFjY29yZGluZyB0byBEYXRhU3RheCBJTiBzaG91bGQgd29yay4KwqAKU28gaWYgSSB0cmllZDoKwqAKU2VsZWN0ICogZnJvbSBpdGVtcyBXaGVyZSBpdGVtX2lkIElOIChTZWxlY3QgaXRlbV9pZCBGUk9NIHVzZXJzIHdoZXJlIHVzZXJfaWQgPSA_KQrCoArCoApUaGFua3MgZm8BMAEBAQE- X-Mailer: YahooMailWebService/0.8.148.557 Message-ID: <1372974827.10182.YahooMailNeo@web121802.mail.ne1.yahoo.com> Date: Thu, 4 Jul 2013 14:53:47 -0700 (PDT) From: Tony Anecito Reply-To: Tony Anecito Subject: CQL and IN To: Users-Cassandra MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-509655459-912221390-1372974827=:10182" X-Virus-Checked: Checked by ClamAV on apache.org ---509655459-912221390-1372974827=:10182 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi All,=0A=A0=0AI am using the DataStax driver and got prepared to work. Wh= en I tried to use the "IN" keyword with a SQL it did not work. According to= DataStax IN should work.=0A=A0=0ASo if I tried:=0A=A0=0ASelect * from item= s Where item_id IN (Select item_id FROM users where user_id =3D ?)=0A=A0=0A= =A0=0AThanks for the feedback.=0A-Tony ---509655459-912221390-1372974827=:10182 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
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. A= ccording to DataStax IN should work.
 
So if I tried:
 
Select * from items Where item_id IN (Select ite= m_id FROM users where user_id =3D ?)
 
 
Thanks for the feedback.
-Tony
<= /body> ---509655459-912221390-1372974827=:10182--