Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 42436 invoked from network); 2 Feb 2010 03:11:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Feb 2010 03:11:02 -0000 Received: (qmail 77494 invoked by uid 500); 2 Feb 2010 03:11:02 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 77434 invoked by uid 500); 2 Feb 2010 03:11:02 -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 77425 invoked by uid 99); 2 Feb 2010 03:11:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Feb 2010 03:11:01 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of rockett.williams@gmail.com designates 74.125.92.149 as permitted sender) Received: from [74.125.92.149] (HELO qw-out-1920.google.com) (74.125.92.149) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Feb 2010 03:10:52 +0000 Received: by qw-out-1920.google.com with SMTP id 5so917077qwf.54 for ; Mon, 01 Feb 2010 19:10:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=0EiDfC+wS7g2U4p5tiHeebC0FNi23o/R+MHQVjP1AHM=; b=JsKOhjjuH7Id2mEoNk/6kIo/xhUUHdcgSHCd4jbAi+DSCCIcZo9O6TraLE0SvNbgT3 mtU/knXkYdy2SxxcKkgPBe3AUYwz1wxNXcw6LI6QNFXhKfeK9byw/vtjdHzR8ZouaJFa QTID9HB0TJbwHAv4jRhVmgB6bK+fDfC5mmIt0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=jrOTiX4bfbgbqh6LAqlZMTG8a6/o5Te6B9ImYNaEYFmOINgzOIbjrO4RNU6Boej5XL rvC2WRPRg9anDk43eyQZ+N+o9pFMNeodKt8yNaEIo9IpGZuCM/mFI5LbOoqFgx4DkyjC 29WCwtBO6p0bSknWNgMnN4M60BXHyKe6sqzmU= MIME-Version: 1.0 Received: by 10.229.130.206 with SMTP id u14mr2115585qcs.74.1265080232188; Mon, 01 Feb 2010 19:10:32 -0800 (PST) Date: Tue, 2 Feb 2010 13:10:32 +1000 Message-ID: Subject: Multiblog Scenario: Schema Design From: Rockett Williams To: cassandra-user@incubator.apache.org Content-Type: multipart/alternative; boundary=00151750e6e0da1cad047e9571dc --00151750e6e0da1cad047e9571dc Content-Type: text/plain; charset=ISO-8859-1 Most people are aware of Evan Weaver's (from Twitter) blog post introducing Cassandra. http://blog.evanweaver.com/articles/2009/07/06/up-and-running-with-cassandra/ In the post he uses a example multiblog application -> a blog for multiple users. I was wondering how would you be able to query by date for the example which would be a common scenario. For example, I want all blog posts from the month of January. What schema changes would be required and how would you approach the problem using the API. --00151750e6e0da1cad047e9571dc Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Most people are aware of Evan Weaver's (from Twitter) blog post introdu= cing Cassandra.

http://= blog.evanweaver.com/articles/2009/07/06/up-and-running-with-cassandra/<= /div>

In the post he uses a example multiblog=A0application= =A0-> a blog for multiple users.

I was wonderin= g how would you be able to query by date for the example which would be a c= ommon scenario.=A0

For example, I want all blog posts from the month of Ja= nuary.

What schema changes would be required and h= ow would you=A0approach=A0the problem using the API.=A0
--00151750e6e0da1cad047e9571dc--