Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of edlinuxguru@gmail.com
 designates 209.85.161.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=iMbSmBvmleO66zKoDADS/fcKck5b8khdW0/g29Dxooht9b3CSTPb5Y/VfPHFTXW9Iq
         GiSlAAyJk2qwtJ7WcimsGBXZpHkLqCShOvUdipk1jK2gdM7JPHTnhytNm6Q7NyJIHkaB
         8eRIp0dXPmKmwltKtr5geDH3MQb2pHxfmsOZQ=
MIME-Version: 1.0
In-Reply-To: <4D4D1479.7080705@panasiangroup.com>
References: <4D4BC36F.3040604@panasiangroup.com>
	<4D4BCF52.7080407@panasiangroup.com>
	<AANLkTi=NQjCuHP1Fw=f-A56jk_6PCdV-nr1y7_19nzTv@mail.gmail.com>
	<2019873521-1296838861-cardhu_decombobulator_blackberry.rim.net-1683316563-@b1.c3.bise7.blackberry>
	<AANLkTinjL3K__qO+C8Am391+OZih5hA+SeLkf-LXHV6s@mail.gmail.com>
	<4D4C5954.6020002@panasiangroup.com>
	<4D4D1479.7080705@panasiangroup.com>
Date: Sat, 5 Feb 2011 11:22:20 -0500
Message-ID: <AANLkTikPN0vyATntMraSrjKP28XBGCBBoDJ5rqfk6hVt@mail.gmail.com>
Subject: Re: How to delete bulk data from cassandra 0.6.3
From: Edward Capriolo <edlinuxguru@gmail.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Sat, Feb 5, 2011 at 4:12 AM, Ali Ahsan <ali.ahsan@panasiangroup.com> wro=
te:
> Any update on this?
>
> On 02/05/2011 12:53 AM, Ali Ahsan wrote:
>>
>> So do we need to write a script ? or its some thing i can do as a system
>> admin without involving and developer.If yes please guide me in this cas=
e.
>>
>>
>>
>>
>> On 02/04/2011 10:36 PM, Jonathan Ellis wrote:
>>>
>>> In that case, you should shut down the server before removing data file=
s.
>>>
>>> On Fri, Feb 4, 2011 at 9:01 AM,<roshandawrani@gmail.com> =A0wrote:
>>>>
>>>> I thought truncate() was not available before 0.7 (in 0.6.3)....was it=
?
>>>>
>>>> ---------------------------------------------------
>>>> Sent from BlackBerry
>>>>
>>>> -----Original Message-----
>>>> From: Jonathan Ellis<jbellis@gmail.com>
>>>> Date: Fri, 4 Feb 2011 08:58:35
>>>> To: user<user@cassandra.apache.org>
>>>> Reply-To: user@cassandra.apache.org
>>>> Subject: Re: How to delete bulk data from cassandra 0.6.3
>>>>
>>>> You should use truncate instead. (Then remove the snapshot truncate
>>>> creates.)
>>>>
>>>> On Fri, Feb 4, 2011 at 2:05 AM, Ali Ahsan<ali.ahsan@panasiangroup.com>
>>>> =A0wrote:
>>>>>
>>>>> Hi All
>>>>>
>>>>> Is there any way i can delete column families data (not removing colu=
mn
>>>>> families ) from Cassandra without effecting ring integrity.What if =
=A0i
>>>>> delete
>>>>> some column families data in linux with rm command =A0?
>>>>>
>>>>> --
>>>>> S.Ali Ahsan
>>>>>
>>>>> Senior System Engineer
>>>>>

>>>>> e-Business (Pvt) Ltd
>>>>>
>>>>> 49-C Jail Road, Lahore, P.O. Box 676
>>>>> Lahore 54000, Pakistan
>>>>>
>>>>> Tel: +92 (0)42 3758 7140 Ext. 128
>>>>>
>>>>> Mobile: +92 (0)345 831 8769
>>>>>
>>>>> Fax: +92 (0)42 3758 0027
>>>>>
>>>>> Email: ali.ahsan@panasiangroup.com
>>>>>
>>>>>
>>>>>
>>>>> www.ebusiness-pg.com
>>>>>
>>>>> www.panasiangroup.com
>>>>>
>>>>> Confidentiality: This e-mail and any attachments may be confidential
>>>>> and/or privileged. If you are not a named recipient, please notify th=
e
>>>>> sender immediately and do not disclose the contents to another person
>>>>> use it for any purpose or store or copy the information in any medium=
.
>>>>> Internet communications cannot be guaranteed to be timely, secure,
>>>>> error
>>>>> or virus-free. We do not accept liability for any errors or omissions=
.
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Jonathan Ellis
>>>> Project Chair, Apache Cassandra
>>>> co-founder of DataStax, the source for professional Cassandra support
>>>> http://www.datastax.com
>>>>
>>>
>>>
>>
>>
>
>
> --
> S.Ali Ahsan
>
> Senior System Engineer
>
> e-Business (Pvt) Ltd
>
> 49-C Jail Road, Lahore, P.O. Box 676
> Lahore 54000, Pakistan
>
> Tel: +92 (0)42 3758 7140 Ext. 128
>
> Mobile: +92 (0)345 831 8769
>
> Fax: +92 (0)42 3758 0027
>
> Email: ali.ahsan@panasiangroup.com
>
>
>
> www.ebusiness-pg.com
>
> www.panasiangroup.com
>
> Confidentiality: This e-mail and any attachments may be confidential
> and/or privileged. If you are not a named recipient, please notify the
> sender immediately and do not disclose the contents to another person
> use it for any purpose or store or copy the information in any medium.
> Internet communications cannot be guaranteed to be timely, secure, error
> or virus-free. We do not accept liability for any errors or omissions.
>
>

in 0.6.X
pkill `pid of cassandra`
rm -rf * /var/lib/cassandra/data/<keyspace>/<CF you want to delete>*
(start cassandra)