Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cassandra-user@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of bill.w.au@gmail.com designates
 209.85.221.199 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=cPP6PHuk9gHEUpKjPWLCpleIlGAjL4ghYuTyfGHZJW0RaNv/t2FWzA6ni2/vp8MAqv
         rDeEICGhU79dntJ5BSuPPh2sfksN9EF3K6MaSEPlbxnmi4oagnaAso4RKPsyFAYv0sm4
         mw+JrtdNgiTQohXgSJhsxZDyo3fILJ3bv6fHQ=
MIME-Version: 1.0
Date: Thu, 11 Mar 2010 22:34:11 -0500
Message-ID: <3b5f72031003111934m75e9de7w4616642b5a14a9fe@mail.gmail.com>
Subject: question about deleting from cassandra
From: Bill Au <bill.w.au@gmail.com>
To: cassandra-user@incubator.apache.org
Content-Type: multipart/alternative; boundary=00504501671f6a5801048192347f

--00504501671f6a5801048192347f
Content-Type: text/plain; charset=ISO-8859-1

Let take Twitter as an example.  All the tweets are timestamped.  I want to
keep only a month's worth of tweets for each user.  The number of tweets
that fit within this one month window varies from user to user.  What is the
best way to accomplish this?  There are millions of users.  Do I need to
loop through all of them and handle the delete one user at a time?  Or is
there a better way to do this?  If a user has not post a new tweet in more
than a month, I also want to remove the user itself.  Do I also need to do
looking through all the users one at a time?

Bill

--00504501671f6a5801048192347f
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Let take Twitter as an example. =A0All the tweets are timestamped. =A0I wan=
t to keep only a month&#39;s worth of tweets for each user. =A0The number o=
f tweets that fit within this one month window varies from user to user. =
=A0What is the best way to accomplish this? =A0There are millions of users.=
 =A0Do I need to loop through all of them and handle the delete one user at=
 a time? =A0Or is there a better way to do this? =A0If a user has not post =
a new tweet in more than a month, I also want to remove the user itself. =
=A0Do I also need to do looking through all the users one at a time?<div>
<br></div><div>Bill</div>

--00504501671f6a5801048192347f--