cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Colin <>
Subject Re: need some help with counters
Date Thu, 09 Jun 2011 19:54:37 GMT
Hey guy, have you tried amazon turk?

Colin Clark
+1 315 886 3422 cell
+1 701 212 4314 office

*Sent from Star Trek like flat panel device, which although larger than my Star Trek like
communicator device, may have typo's and exhibit improper grammar due to haste and less than
perfect use of the virtual keyboard*

On Jun 9, 2011, at 3:41 PM, Ian Holsman <> wrote:

> Hi.
> I had a brief look at CASSANDRA-2103 (expiring counter columns), and I was wondering
if anyone can help me with my problem.
> I want to keep some page-view stats on a URL at different levels of granularity (page
views per hour, page views per day, page views per year etc etc).
> so my thinking was to create something a counter with a key based on Year-Month-Day-Hour,
and simply increment the counter as I go along. 
> this work's well and I'm getting my metrics beautifully put into the right places.
> the only problem I have is that I only need the last 48-hours worth of metrics at the
hour level.
> how do I get rid of the old counters? 
> do I need to write a archiver that will go through each url (could be millions) and just
delete them?
> I'm sure other people have encountered this, and was wondering how they approached it.
> Ian

View raw message