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 <had...@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