Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 31920 invoked from network); 17 Nov 2009 13:16:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 17 Nov 2009 13:16:21 -0000 Received: (qmail 89072 invoked by uid 500); 17 Nov 2009 13:16:21 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 89046 invoked by uid 500); 17 Nov 2009 13:16:20 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 89037 invoked by uid 99); 17 Nov 2009 13:16:20 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Nov 2009 13:16:20 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates 209.85.218.219 as permitted sender) Received: from [209.85.218.219] (HELO mail-bw0-f219.google.com) (209.85.218.219) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Nov 2009 13:16:12 +0000 Received: by bwz19 with SMTP id 19so6893409bwz.28 for ; Tue, 17 Nov 2009 05:15:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:content-type; bh=UcHY3c4yjdl8aLz4eH/hpHUcmdav+fZJIt7Nyzl/akY=; b=KQ5YGzylcG+2LcznKNWqyt0JvPKtWSSA/vkNJD0UZvEgxmy3PW6Ulyan4JkFYJAYk2 pI8gYVn2kGe7UmwK+sCo0q83Vjs5XoRqPpCahAxIr760al0jGIkqeYOa0OeUMXXjDQ7B NSVlop8mQjS/2eWpQmnMmQZ2oYsJDGfHiiDCA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=JUnK/7eTxKrQMp0BAqu7uODAhz7DbrCawcrWuKBhrsu+Ksh1Te/+FQQi3KrQTxhnbL BS3C1dWh1NQPgtnppXcW7D7R48Nz5H50scfLCA9hZAjRTuuwjeo4g0R+h+rMCY6UIAUO RdLqpji5w7PVB55c4h0NlnEtiLr09tS37Lq7Q= MIME-Version: 1.0 Received: by 10.216.91.6 with SMTP id g6mr1085223wef.212.1258463752215; Tue, 17 Nov 2009 05:15:52 -0800 (PST) In-Reply-To: <4B028608.5070306@gmail.com> References: <4B028608.5070306@gmail.com> From: Jonathan Ellis Date: Tue, 17 Nov 2009 07:15:32 -0600 Message-ID: Subject: Re: intersection of result sets, filters based on column values? To: cassandra-user@incubator.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Correct. On Tue, Nov 17, 2009 at 5:16 AM, TuxRacer69 wrote: > Hello Cassandra Users, > > is filtering based on a column value possible with Cassandra? > > Example: I have a supper column with > > key: Paris, super column key: 2008.12.31.23.45.00, columns: (docid:99, > type:pdf) > key: Paris, super column key: 2008.12.31.23.46.00, columns: (docid:109, > type:mp3) > key: Paris, super column key: 2008.12.31.23.47.00, columns: (docid:110, > type:pdf) > > Is there an API function to get directly only the documents about 'Paris' of > type (say) 'pdf'? > > I am reading the API documentation and I think the answer is 'No', and that > I would have to make the intersection (or filtering) at the application > level, but could somebody please confirm? > > Thanks, > TR >