Re: what is the best way to truncate a column family

2010-06-18 Thread Phil Stanhope
I am happy with this restriction on truncate operation for 0.7. Thanks for the quick response. -phil On Jun 18, 2010, at 4:57 PM, Ran Tavory wrote: > it will be immediate. > But it will fail if not all hosts in the cluster are up, this is the > tradeoff. We regard the truncate operation an ad

Re: what is the best way to truncate a column family

2010-06-18 Thread Ran Tavory
it will be immediate. But it will fail if not all hosts in the cluster are up, this is the tradeoff. We regard the truncate operation an admin api so I think it's a fair tradeoff. On Fri, Jun 18, 2010 at 11:50 PM, Phil Stanhope wrote: > In 0.6.x the iterating approach works ... but you need to f

Re: what is the best way to truncate a column family

2010-06-18 Thread Phil Stanhope
In 0.6.x the iterating approach works ... but you need to flush and compact (after GCGraceSeconds) in order to NOT see the keys in the CF. Will the behavior of the truncate method in 0.7 require flush/compact as well? Or will it be immediate? -phil On Jun 18, 2010, at 1:29 PM, Benjamin Black w

Re: what is the best way to truncate a column family

2010-06-18 Thread Benjamin Black
I have been reminded that you can do a range query+pagination with RP in 0.6 to perform this operation. On Fri, Jun 18, 2010 at 10:29 AM, Benjamin Black wrote: > In 0.6 your only option with those constraints is to iterate over the > entire CF and deleting row by row.  This requires you are eithe

Re: what is the best way to truncate a column family

2010-06-18 Thread Benjamin Black
In 0.6 your only option with those constraints is to iterate over the entire CF and deleting row by row. This requires you are either using OPP or have an index that covers all keys in the CF. 0.7 adds the ability to truncate a CF (deleting all its rows) through the API. On Fri, Jun 18, 2010 at