cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ian Holsman <had...@holsman.net>
Subject Re: need some help with counters
Date Thu, 09 Jun 2011 20:06:29 GMT
Hi Ryan.
you wouldn't have your version of cassandra up on github would you??

Colin.. always a pleasure.

On Jun 9, 2011, at 3:44 PM, Ryan King wrote:

> On Thu, Jun 9, 2011 at 12:41 PM, Ian Holsman <hadoop@holsman.net> 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.
> 
> Here's how we are going to do it at twitter:
> https://issues.apache.org/jira/browse/CASSANDRA-2735
> 
> -ryan


Mime
View raw message