Re: rename column family

2012-01-04 Thread aaron morton
You do not need a restart if you use nodetool refresh Otherwise a rolling restart will do the trick. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 4/01/2012, at 12:31 PM, Jim Newsham wrote: > > Thanks that's very helpful. I'm assuming

Re: rename column family

2012-01-03 Thread Jim Newsham
Thanks that's very helpful. I'm assuming there's no requirement to stop or restart Cassandra? Thanks, Jim On 1/2/2012 12:07 AM, aaron morton wrote: Renaming a CF is not directly supported. You can: 1) Add the new CF using the CLI or CQL 2) On each node copy the SSTable files and use the ne

Re: rename column family

2012-01-02 Thread aaron morton
Renaming a CF is not directly supported. You can: 1) Add the new CF using the CLI or CQL 2) On each node copy the SSTable files and use the new CF name. 3) Drop the old CF using the CLI or CQL 4) The Drop CF command will create a snapshot, you may want to delete this. Hope that helps. --

Re: rename column family

2011-02-13 Thread Aaron Morton
Forgot to put on the end of this, you could take that approach but it's not what CF's are designed for. Delete's are relatively cheap compared to MySql etc because most of the work is done in the compaction. My first approach would be to use row keys with prefixes, switch at the application level,

Re: rename column family

2011-02-13 Thread Aaron Morton
There are functions on the Cassandra API to rename and drop column families, see http://wiki.apache.org/cassandra/API dropping a CF does not immediately free up the disk space, see the docs. AFAIK the rename is not atomic across the cluster (that would require locks) so you best bet would be t

Re: rename column family

2011-02-10 Thread Karl Hiramoto
On 02/10/11 22:19, Aaron Morton wrote: > That should read "Without more information" > > A > On 11 Feb, 2011,at 10:15 AM, Aaron Morton wrote: > >> With more information I'd say this is not a good idea. >> >> I would suggest looking at why you do the table switch in the MySql >> version and conside

Re: rename column family

2011-02-10 Thread Aaron Morton
That should read "Without more information"AOn 11 Feb, 2011,at 10:15 AM, Aaron Morton wrote:With more information I'd say this is not a good idea. I would suggest looking at why you do the table switch in the MySql version and consider if it's still necessary in the Cassandra version. Could you

Re: rename column family

2011-02-10 Thread Aaron Morton
With more information I'd say this is not a good idea. I would suggest looking at why you do the table switch in the MySql version and consider if it's still necessary in the Cassandra version. Could you use prefixes in your keys that the app knows about and switch those? Aaron On 11/02/2011,

Re: rename column family with cassandra-cli in 0.7.0-beta3

2010-11-11 Thread Jonathan Ellis
Done, thanks for the reminder. On Thu, Nov 11, 2010 at 12:15 PM, gbanks wrote: > sorry for the empty body... i hit send a bit prematurely. > > so, rename functionality is gone until > https://issues.apache.org/jira/browse/CASSANDRA-1585 is resolved? > > in that case, can i also suggest removing:

Re: rename column family with cassandra-cli in 0.7.0-beta3

2010-11-11 Thread gbanks
sorry for the empty body... i hit send a bit prematurely. so, rename functionality is gone until https://issues.apache.org/jira/browse/CASSANDRA-1585 is resolved? in that case, can i also suggest removing: rename keyspace Rename a keyspace. rename column family

Re: rename column family with cassandra-cli in 0.7.0-beta3

2010-11-10 Thread Jonathan Ellis
https://issues.apache.org/jira/browse/CASSANDRA-1630 On Wed, Nov 10, 2010 at 6:09 PM, gbanks wrote: > -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Cassandra support http://riptano.com