You can consult a full example of schema for multiblog here:

In fact, Cassandra is not RDBMS so you'll have to create a CF for everything you want to "index" as Jonathan's suggestion.

On Tue, Feb 2, 2010 at 10:27 AM, Jonathan Ellis <> wrote:
You would add a columnfamily with a row per month and write blog posts
(either ids or entire post data) to that CF.

On Mon, Feb 1, 2010 at 9:10 PM, Rockett Williams
<> wrote:
> Most people are aware of Evan Weaver's (from Twitter) blog post introducing
> 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.