incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yang <teddyyyy...@gmail.com>
Subject Re: need some help with counters
Date Thu, 09 Jun 2011 20:04:14 GMT
something like this:
https://issues.apache.org/jira/browse/CASSANDRA-2103

<https://issues.apache.org/jira/browse/CASSANDRA-2103>but this turns out not
feasible

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.
>
> TIA
> Ian

Mime
View raw message