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 EA5E4E1F0 for ; Fri, 8 Feb 2013 11:45:29 +0000 (UTC) Received: (qmail 60418 invoked by uid 500); 8 Feb 2013 11:45:26 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 58743 invoked by uid 500); 8 Feb 2013 11:45:23 -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 58547 invoked by uid 99); 8 Feb 2013 11:45:23 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Feb 2013 11:45:23 +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 ajazam@gmail.com designates 209.85.215.54 as permitted sender) Received: from [209.85.215.54] (HELO mail-la0-f54.google.com) (209.85.215.54) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Feb 2013 11:45:16 +0000 Received: by mail-la0-f54.google.com with SMTP id gw10so3690743lab.13 for ; Fri, 08 Feb 2013 03:44:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=IhTQHdH2zcg04yI2r2dEMa4by4iqol2TAc0ZNcSmgkA=; b=un0SHqTdfYqOaaTwdIeI+r0qXULCY32NM4aCZkBHsM4pA1fCxLJv//5GEPZdyZ8TqW O54pXlyM1XsgvneRGtEZL0lGzDhL+6VfWc3tyTP0PpjD/6kIcmJdmaheKuXUgH1ynhhF zSdbBOWzOM/r4w/+x/KaPZUfOxvhlyQZxq3X70JGngaHnkNX0kkWFdgOze53PO3rxMfP O/yZ4A/uDNc4ZuR8YclOBCzVNhDHEbZhP8H6r6TQ6y9t9si+a3oGREjLiGb/M8IrFZmS 1ilEJy6oYtGoMhSHLF1+I3I1tlijA4HEc+J9ksr51ufljhFbSzpVo0HFi1Ceg6hyB03z iVkw== MIME-Version: 1.0 X-Received: by 10.112.17.166 with SMTP id p6mr2171522lbd.41.1360323895548; Fri, 08 Feb 2013 03:44:55 -0800 (PST) Received: by 10.112.85.164 with HTTP; Fri, 8 Feb 2013 03:44:55 -0800 (PST) In-Reply-To: <25CB58AE-956D-4BDB-95E7-D2E5EBCABF2E@thelastpickle.com> References: <25CB58AE-956D-4BDB-95E7-D2E5EBCABF2E@thelastpickle.com> Date: Fri, 8 Feb 2013 11:44:55 +0000 Message-ID: Subject: Re: Can't remove contents of table with truncate or drop From: Jabbar To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=bcaec55400f092db3904d53516b6 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec55400f092db3904d53516b6 Content-Type: text/plain; charset=ISO-8859-1 Aaron, Everytime after I ran the truncate I did select count(*) from datapoints; and a non zero value was returned. I never got any errors after the truncate. All the nodes seem to be available as I was connected to all the servers via ssh and ran cassandra using ./cassandra -f I had to do some more testing so I wrote some c# to delete the rows explicitly. I am currently benchtesting our cluster so will do a truncate again after I have finished inserting data and will report my results. On 8 February 2013 02:13, aaron morton wrote: > Double check the truncate worked, all nodes must be available for it > execute. > > If you can provide the output from the cqlsh from truncating and selecting > that would be helpful. > > Cheers > > ----------------- > Aaron Morton > Freelance Cassandra Developer > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On 8/02/2013, at 2:55 AM, Jabbar wrote: > > Hello, > > I'm having problems truncating or deleting the contents of a table. If I > truncate the table and then do a select count(*) I get a value above zero. > If I drop the table, recreate the table the select count(*) still returns > a non zero value. > > The truncate or delete operation does not return any errors. > > I am using cassandra 1.2.1 with java 1.6.0 u 39 64 bit in centos 6.3 > > My keyspace definition is > > CREATE KEYSPACE studata WITH replication = { > 'class': 'SimpleStrategy', > 'replication_factor': '3' > }; > > > My table definition is > > CREATE TABLE datapoints ( > siteid bigint, > channel int, > time timestamp, > data float, > PRIMARY KEY ((siteid, channel), time) > ) WITH > bloom_filter_fp_chance=0.010000 AND > caching='KEYS_ONLY' AND > comment='' AND > dclocal_read_repair_chance=0.000000 AND > gc_grace_seconds=864000 AND > read_repair_chance=0.100000 AND > replicate_on_write='true' AND > compaction={'class': 'SizeTieredCompactionStrategy'} AND > compression={'sstable_compression': 'SnappyCompressor'}; > > > It has 3,504,000,000 rows, consisting of 100,000 partition keys. > > > Is there anything that I'm doing wrong? > > > > -- > Thanks > > A Jabbar Azam > > > -- Thanks A Jabbar Azam --bcaec55400f092db3904d53516b6 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Aaron,

Everytime after I = ran the truncate I did

select count(*) from datapoints;
and a non zero value was returned.

I never got any errors af= ter the truncate. All the nodes seem to be available as I was connected to = all the servers via ssh and ran cassandra using ./cassandra -f

I had to do some more testing so I wrote some c# to delete the ro= ws explicitly.

I am currently benchtesting our cluster so will do a = truncate again after I have finished inserting data and will report my resu= lts.


On 8 Fe= bruary 2013 02:13, aaron morton <aaron@thelastpickle.com> wrote:
Double c= heck the truncate worked, all nodes must be available for it execute.=A0
If you can provide the output from the cqlsh from truncating and= selecting that would be helpful.

Cheers
<= br>
-----------------
Aaron Morton
Freelance Cassandra= Developer
New Zealand


On 8/02/2013, at 2:55 AM, Jabbar <ajazam@gmail.com> wrote:

Hello,

I= 'm having problems truncating or deleting the contents of a table. If I= truncate the table and then do a select count(*) I get a value above zero.=
=A0If I drop the table, recreate the table the select count(*) s= till returns a non zero value.

The truncate or delete operation does not return any errors.=

I am using cassandra 1.2.1 with java 1.6.0 u 39 64 bit i= n centos 6.3

My keyspace definition is

CREATE KEYSPACE studata WITH replication =3D {
=A0 'class': 'SimpleStrategy',
=A0 'replication_fact= or': '3'
};


My table defini= tion is

CREATE TABLE datapoints (
=A0 siteid bigint,<= br> =A0 channel int,
=A0 time timestamp,
=A0 data float,
=A0 PRIMARY K= EY ((siteid, channel), time)
) WITH
=A0 bloom_filter_fp_chance=3D0.01= 0000 AND
=A0 caching=3D'KEYS_ONLY' AND
=A0 comment=3D'= 9; AND
=A0 dclocal_read_repair_chance=3D0.000000 AND
=A0 gc_grace_seconds=3D864000 AND
=A0 read_repair_chance=3D0.100000 AND<= br>=A0 replicate_on_write=3D'true' AND
=A0 compaction=3D{'cl= ass': 'SizeTieredCompactionStrategy'} AND
=A0 compression=3D= {'sstable_compression': 'SnappyCompressor'};


It has 3,504,000,000=A0 rows, consisting of 100,000 part= ition keys.


Is there anything that I'm= doing wrong?



--
Thanks

=A0A Jabbar Azam



--
Thanks

=A0A Jabbar Azam
--bcaec55400f092db3904d53516b6--