Re: rolling window of data

2011-02-03 Thread Jonathan Ellis
On Thu, Feb 3, 2011 at 3:59 PM, Jeffrey Wang wrote: > To be a little more clear, a simplified version of what I'm asking is: > > Let's say you add 1K columns with timestamps 1 to 1000. Then, at an > arbitrarily distant point in the future, if you call remove on that CF with > timestamp 500 (so t

RE: rolling window of data

2011-02-03 Thread Jeffrey Wang
essage- From: sc...@scode.org [mailto:sc...@scode.org] On Behalf Of Peter Schuller Sent: Thursday, February 03, 2011 8:48 AM To: user@cassandra.apache.org Subject: Re: rolling window of data > The correct way to accomplish what you describe is the new (in 0.7) > per-column TTL.  Simply set thi

RE: rolling window of data

2011-02-03 Thread Jeffrey Wang
@scode.org [mailto:sc...@scode.org] On Behalf Of Peter Schuller Sent: Thursday, February 03, 2011 8:48 AM To: user@cassandra.apache.org Subject: Re: rolling window of data > The correct way to accomplish what you describe is the new (in 0.7) > per-column TTL.  Simply set this to 60 * 60 * 24 * 90

Re: rolling window of data

2011-02-03 Thread Peter Schuller
> The correct way to accomplish what you describe is the new (in 0.7) > per-column TTL.  Simply set this to 60 * 60 * 24 * 90 (90 day's worth of > seconds) and your columns will magically disappear after that length of > time. Although that assumes it's okay to loose data or that there is some oth

Re: rolling window of data

2011-02-02 Thread Tyler Hobbs
thelastpickle.com] > *Sent:* Wednesday, February 02, 2011 9:21 PM > *To:* user@cassandra.apache.org > *Subject:* Re: rolling window of data > > > > This project may provide some inspiration for you > https://github.com/thobbs/logsandra > > > > Not sure if it has a

RE: rolling window of data

2011-02-02 Thread Jeffrey Wang
user@cassandra.apache.org Subject: Re: rolling window of data This project may provide some inspiration for you https://github.com/thobbs/logsandra Not sure if it has a rolling window, if you find out let me know :) Aaron On 03 Feb, 2011,at 06:08 PM, Jeffrey Wang wrote: Hi, We're trying to use Cassan

Re: rolling window of data

2011-02-02 Thread Aaron Morton
the trick, but that apparently is not supported yet. Another idea I had was to store the timestamp of the log entry as Cassandra’s timestamp and pass in artificial timestamps to remove (thrift API), but that seems hacky. Does anyone know if there is a good way to support this kind of rolling window

rolling window of data

2011-02-02 Thread Jeffrey Wang
ove (thrift API), but that seems hacky. Does anyone know if there is a good way to support this kind of rolling window of data efficiently? Thanks. -Jeffrey