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. --

rename column family

2011-12-30 Thread Jim Newsham
How can I rename a column family (if version matters, I'm interested in both 0.8.x and 1.0.x). Thanks, Jim

Re: How to rename column family?

2011-02-15 Thread Jonathan Ellis
Renames are not yet supported (see https://issues.apache.org/jira/browse/CASSANDRA-1585) On Tue, Feb 15, 2011 at 7:45 AM, Michal Augustýn wrote: > Hello, > I would like to rename some column families but I discovered that the > system_rename_column_family disappeared in 0.7. How to rename the col

How to rename column family?

2011-02-15 Thread Michal Augustýn
Hello, I would like to rename some column families but I discovered that the system_rename_column_family disappeared in 0.7. How to rename the column family now? I tried system_update_column_family method but it doesn't work for renaming :( Thank you!

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,

rename column family

2011-02-10 Thread Karl Hiramoto
Hi, In Mysql I do this pattern and wonder if I could do something similar with cassandra. 1. Live/Production queries always coming into LiveTable 2. Build new data with BuildTable 3.RENAME TABLE LiveTable TO OldTable, BuildTable To LiveTable 4. DROP TABLE OldTable, Goto step #2 build

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

2010-11-11 Thread Jonathan Ellis
o suggest removing: > > rename keyspace                Rename a > keyspace. > rename column family                     Rename a column > family. > > from the help dialog in cassandra-cli. > > cheers, > greg > > On Nov 10, 2010, at 6:34 PM, Jonathan E

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

rename column family with cassandra-cli in 0.7.0-beta3

2010-11-10 Thread gbanks