Re: need some help with counters

2011-06-16 Thread Ian Holsman
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 rows

Re: need some help with counters

2011-06-12 Thread aaron morton
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 on

Re: need some help with counters

2011-06-10 Thread Ian Holsman
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 : 4567, }

need some help with counters

2011-06-09 Thread Ian Holsman
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

Re: need some help with counters

2011-06-09 Thread Ryan King
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

Re: need some help with counters

2011-06-09 Thread Colin
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

Re: need some help with counters

2011-06-09 Thread Yang
something like this: https://issues.apache.org/jira/browse/CASSANDRA-2103 https://issues.apache.org/jira/browse/CASSANDRA-2103but this turns out not feasible 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

Re: need some help with counters

2011-06-09 Thread Ian Holsman
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),

Re: need some help with counters

2011-06-09 Thread Ryan King
On Thu, Jun 9, 2011 at 1:06 PM, Ian Holsman had...@holsman.net 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

2011-06-09 Thread Ian Holsman
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

Re: need some help with counters

2011-06-09 Thread aaron morton
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