Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of th.heller@gmail.com designates
 209.85.216.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type;
        b=IUZBUxkG3GWSrZdWKQQC4tXaShvgjupqbhByRBYNGO9YJzkULpjCvCBZgIX1S0g6ag
         iDZN2As0Cuu1bUZAtfMWVFHBzHrnM7WUnQkMbnmkxsDuRhFPhkaKZDo4LFVS+b05BIFx
         5OWHMzBkrz1t6A73oBiuO7nH7jagMCeB6t2K8=
MIME-Version: 1.0
Sender: th.heller@gmail.com
In-Reply-To: <4C5CB45A.8040301@gmail.com>
References: <4C51F4F7.6090801@gmail.com>
	<AANLkTimiiczK8vkq-bLFcw9S1ZEVQQUofPSGpx0f4VTC@mail.gmail.com>
	<4C54BC12.3040506@gmail.com>
	<AANLkTi=9dhjGyAX1FS7rOt6bVz0qv7eYbPMxU0CE6CYk@mail.gmail.com>
	<AANLkTinKzqt4vAO-+e9R2WHRXBgUNjmbexsxys8+ri9n@mail.gmail.com>
	<AANLkTinHz+7LhuzQ_w7OTQTTvNJX4wxkikD+XRvjkaVw@mail.gmail.com>
	<AANLkTi=UPob4Jbeu2bRN-avU1Qneq7t9Yng1e-UT1FTt@mail.gmail.com>
	<AANLkTi=-5YKkKH9e4tMNtKg9-bVDyGWkpz8Vb0XmgWTo@mail.gmail.com>
	<4C5CB45A.8040301@gmail.com>
Date: Sat, 7 Aug 2010 13:22:04 +0200
Message-ID: <AANLkTimRfem5svKGiP4mfPs+=DOKF_TPErGThhBr0C+T@mail.gmail.com>
Subject: Re: Columns limit
From: Thomas Heller <info@zilence.net>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=UTF-8

> Ok, I think the part I was missing was the concatenation of the key and
> partition to do the look ups. Is this the preferred way of accomplishing
> needs such as this? Are there alternatives ways?

Depending on your needs you can concat the row key or use super columns.

> How would one then "query" over multiple days? Same question for all days.
> Should I use range_slice or multiget_slice? And if its range_slice does that
> mean I need OrderPreservingPartitioner?

The last 3 days is pretty simple: ['2010-08-07', '2010-08-06',
'2010-08-05'], as is 7, 31, etc. Just generate the keys in your app
and use multiget_slice.

If you want to get all days where a specific ip address had some
requests you'll just need another CF where the row key is the addr and
column names are the days (values optional again). Pretty much the
same all over again, just add another CF and insert the data you need.

get_range_slice in my experience is better used for "offline" tasks
where you really want to process every row there is.

/thomas