Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 12898 invoked from network); 19 Nov 2009 04:23:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 19 Nov 2009 04:23:52 -0000 Received: (qmail 7430 invoked by uid 500); 19 Nov 2009 04:23:51 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 7379 invoked by uid 500); 19 Nov 2009 04:23:51 -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 7370 invoked by uid 99); 19 Nov 2009 04:23:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Nov 2009 04:23:51 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of jbellis@gmail.com designates 209.85.218.210 as permitted sender) Received: from [209.85.218.210] (HELO mail-bw0-f210.google.com) (209.85.218.210) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Nov 2009 04:23:48 +0000 Received: by bwz2 with SMTP id 2so2191524bwz.20 for ; Wed, 18 Nov 2009 20:23:27 -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=24Gux6hV6mpdsPiy2MCj7mkAPuTVewCCLFUrXYdqGWI=; b=ud0haPlKL8y9kc4bBtviXuGbLdOfpVPYYF4+qeVOVklh00s8JlYXmEkKbQEsIe8XsN eqnIdHY5p9/FO35a3UOOaqakdV0lEewGY451qKQIQ9BoR1ek5QPn2vlzZnotx38nv7VE /89Vv/F3iJ/bfRk93XX84RIBkIwVpaDD4HNUI= 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=PSCl6kxwzJdcKDuKuUvfvneeflYNFMIJVABErBQsV1qefgBrP63ZMB528LV/jm8hLd 6nLXR5FMusdfezOpGVX6t9rm2PP36O1RTNB0sE+5YGe9oaynwiylNqSyrz/YkhPmCCS8 U1VBaW0UCuDph9M80rOZx+2KkmWpGAD0wNVw0= MIME-Version: 1.0 Received: by 10.216.90.139 with SMTP id e11mr1217793wef.111.1258604607137; Wed, 18 Nov 2009 20:23:27 -0800 (PST) In-Reply-To: References: From: Jonathan Ellis Date: Wed, 18 Nov 2009 22:23:07 -0600 Message-ID: Subject: Re: date range queries To: cassandra-user@incubator.apache.org Content-Type: text/plain; charset=ISO-8859-1 The easiest is to store the messages in a row with timeuuid column names. Then you can just use get_slice in either forward or reverse order. On Wed, Nov 18, 2009 at 6:07 PM, Adam Fisk wrote: > First off, very impressive project -- thanks for everyone's hard work! > I'm wondering how I would do date range queries in Cassandra, say for > all messages for a given user in the last week. > > Can someone provide an example? > > Thanks so much. > > -Adam > > -- > Adam Fisk > http://www.littleshoot.org | http://adamfisk.wordpress.com | > http://twitter.com/adamfisk >