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 6E38A10346 for ; Mon, 2 Dec 2013 20:20:46 +0000 (UTC) Received: (qmail 14577 invoked by uid 500); 2 Dec 2013 20:20:43 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 14555 invoked by uid 500); 2 Dec 2013 20:20:43 -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 14547 invoked by uid 99); 2 Dec 2013 20:20:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Dec 2013 20:20:43 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of rcoli@eventbrite.com designates 209.85.212.42 as permitted sender) Received: from [209.85.212.42] (HELO mail-vb0-f42.google.com) (209.85.212.42) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Dec 2013 20:20:36 +0000 Received: by mail-vb0-f42.google.com with SMTP id w18so8998229vbj.15 for ; Mon, 02 Dec 2013 12:20:15 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=kgMVaHlncoXuYT5eaZtUugYpNZECkDZILOIq8No9o84=; b=fK18MNe9rFsll2ba9bCAUGwKd2fU+Ulgz1h6kzJxehWfNlQQDMjckE889N2HeGeo7L m0/TmiIFIxOk82g2qHJHvWjjJUWpNk/Bn2H5vYXXKFgHFM6FE3HDYDeT6yi/RE1+XTAJ 4zxmgXbQBy8Z3lJYvOm+CwVUm6zgLeyf0TZ40GVbkN+eliahDDefqAr0bUkVJNeIcWps C3wuHHlD+Ippkjn+5plrYTZj9PjArdLjfERchKa2nqUFf9Qtu1gXBPdfBdW4XrEzZ86T k3mCL5pWx40ca/ppdeb89UU9kFRTxqqSJ9RhoKXfyowFss3rxh/6jtXYu5SqaBjToShQ rU5w== X-Gm-Message-State: ALoCoQklg7m6g/7akDDCVyUNKMYxcopmF8orI67nOeYxZYOWzN9RLq9/syb+1tV7OznE5xeNWtaO MIME-Version: 1.0 X-Received: by 10.58.22.33 with SMTP id a1mr804270vef.55.1386015615621; Mon, 02 Dec 2013 12:20:15 -0800 (PST) Received: by 10.220.150.3 with HTTP; Mon, 2 Dec 2013 12:20:15 -0800 (PST) In-Reply-To: <78157CBC-9FD8-4FD5-B70F-6C591365CC47@gmail.com> References: <6A189B4A-D3FB-4BA9-9638-A976153C3142@gmail.com> <78157CBC-9FD8-4FD5-B70F-6C591365CC47@gmail.com> Date: Mon, 2 Dec 2013 12:20:15 -0800 Message-ID: Subject: Re: Table Creation Error From: Robert Coli To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=089e011763a36c25f004ec92e8c8 X-Virus-Checked: Checked by ClamAV on apache.org --089e011763a36c25f004ec92e8c8 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On Mon, Dec 2, 2013 at 12:14 PM, Charlie Andrews < charlieandrews.cwa@gmail.com> wrote: > Maybe a stupid question, but doesn=92t dropping a keyspace drop all data?= Or > is the keyspace schema separate from the data it describes? > Lol, sorry, yes. You will have to restore the data from the automatically created snapshot. 1) echo "DESCRIBE KEYSPACE ;" | cqlsh > keyspace_name.schema.cqlsh 2) DROP KEYSPACE ; 3) restore keyspace's data from the snapshots created automatically when you DROP 4) use the contents of keyspace_name.schema.cqlsh to re-create your schema 5) rolling restart of all nodes (or use "nodetool refresh") =3DRob --089e011763a36c25f004ec92e8c8 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
On Mon, Dec 2, 2013 at 12:14 PM, Charlie Andrews <charlieandrews.cwa@gmail.com> wrote:
Maybe a stupid question, but doesn=92t dropping a keyspace drop all data? O= r is the keyspace schema separate from the data it describes?

Lol, sorry, yes. You will have to restore the data= from the automatically created snapshot.

1) echo "DESCRIBE KEYSPACE <keyspace_name>;"= | cqlsh > keyspace_name.schema.cqlsh
2) DROP KEYSPACE <keyspace_name>;
3) restore keyspace's data= from the snapshots created automatically when you DROP
4) use the contents of keyspace_name.schema.cqlsh to re-create your schema<= /div>
5) rolling restart of all nodes (or use "nodetool refresh&qu= ot;)
=A0
=3DRob

--089e011763a36c25f004ec92e8c8--