Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 224EB95BC for ; Tue, 3 Jan 2012 23:32:22 +0000 (UTC) Received: (qmail 51397 invoked by uid 500); 3 Jan 2012 23:32:20 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 51376 invoked by uid 500); 3 Jan 2012 23:32:19 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 51368 invoked by uid 99); 3 Jan 2012 23:32:19 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Jan 2012 23:32:19 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of jnewsham@referentia.com designates 64.18.3.96 as permitted sender) Received: from [64.18.3.96] (HELO exprod8og108.obsmtp.com) (64.18.3.96) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Jan 2012 23:32:12 +0000 Received: from mail-iy0-f181.google.com ([209.85.210.181]) (using TLSv1) by exprod8ob108.postini.com ([64.18.7.12]) with SMTP ID DSNKTwOP5x8XeSq5I3Dty6W5pMzb/ux0EfQn@postini.com; Tue, 03 Jan 2012 15:31:52 PST Received: by iakk12 with SMTP id k12so33099860iak.12 for ; Tue, 03 Jan 2012 15:31:51 -0800 (PST) Received: by 10.50.10.225 with SMTP id l1mr12102570igb.9.1325633510643; Tue, 03 Jan 2012 15:31:50 -0800 (PST) Received: from [172.16.67.116] ([72.235.184.194]) by mx.google.com with ESMTPS id r5sm78166392igl.3.2012.01.03.15.31.48 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 03 Jan 2012 15:31:49 -0800 (PST) Message-ID: <4F038FE3.2020807@referentia.com> Date: Tue, 03 Jan 2012 13:31:47 -1000 From: Jim Newsham User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: user@cassandra.apache.org Subject: Re: rename column family References: <4EFE1414.7010009@referentia.com> <24E7BA1C-B9FD-4F39-B214-2E31FF3FDCBA@thelastpickle.com> In-Reply-To: <24E7BA1C-B9FD-4F39-B214-2E31FF3FDCBA@thelastpickle.com> Content-Type: multipart/alternative; boundary="------------010703010800020206010809" This is a multi-part message in MIME format. --------------010703010800020206010809 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 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. > > ----------------- > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 31/12/2011, at 8:42 AM, Jim Newsham wrote: > >> >> How can I rename a column family (if version matters, I'm interested >> in both 0.8.x and 1.0.x). >> >> Thanks, >> Jim >> > --------------010703010800020206010809 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
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 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. 

-----------------
Aaron Morton
Freelance Developer
@aaronmorton

On 31/12/2011, at 8:42 AM, Jim Newsham wrote:


How can I rename a column family (if version matters, I'm interested in both 0.8.x and 1.0.x).

Thanks,
Jim



--------------010703010800020206010809--