Re: need some help with counters

On Jun 13, 2011, at 5:10 AM, aaron morton wrote: >> I am wondering how to index on the most recent hour as well. (ie show me top >> 5 URLs type query).. > > AFAIK thats not a great application for counters. You would need range > support in the secondary indexes so you could get the first X r

Re: need some help with counters

> I am wondering how to index on the most recent hour as well. (ie show me top > 5 URLs type query).. AFAIK thats not a great application for counters. You would need range support in the secondary indexes so you could get the first X rows ordered by a column value. To be honest, depending o

Re: need some help with counters

On Jun 9, 2011, at 10:04 PM, aaron morton wrote: > I may be missing something but could you use a column for each of the last 48 > hours all in the same row for a url ? > > e.g. > { > "/url.com/hourly" : { > "20110609T01:00:00" : 456, > "20110609T02:00:00" : 4

Re: need some help with counters

I may be missing something but could you use a column for each of the last 48 hours all in the same row for a url ? e.g. { "/url.com/hourly" : { "20110609T01:00:00" : 456, "20110609T02:00:00" : 4567, } } Increment the current hour only. Delete the

Re: need some help with counters

So would doing something like storing it in reverse (so I know what to delete) work? Or is storing a million columns in a supercolumn impossible. I could always use a logfile and run the archiver off that as a worst case I guess. Would doing so many deletes screw up the db/cause other problems

Re: need some help with counters

On Thu, Jun 9, 2011 at 1:06 PM, Ian Holsman wrote: > Hi Ryan. > you wouldn't have your version of cassandra up on github would you?? No, and the patch isn't in our version yet either. We're still working on it. -ryan

Re: need some help with counters

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 wrote: >> Hi. >> >> I had a brief look at CASSANDRA-2103 (expiring counter columns), and I was >

Re: need some help with counters

something like this: 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 wrote: > Hi. > > I had a brief look at CASSANDRA-2103 (expiring counter columns), and I wa

Re: need some help with counters

Hey guy, have you tried amazon turk? -- Colin Clark +1 315 886 3422 cell +1 701 212 4314 office http://cloudeventprocessing.com http://blog.cloudeventprocessing.com @EventCloudPro *Sent from Star Trek like flat panel device, which although larger than my Star Trek like communicator device, may h

Re: need some help with counters

On Thu, Jun 9, 2011 at 12: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,

need some help with counters

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 thinkin