Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of ajazam@gmail.com designates
 209.85.219.43 as permitted sender)
MIME-Version: 1.0
Date: Thu, 7 Feb 2013 13:55:54 +0000
Message-ID: 
 <CAPqEvGHFjkc3PWp330ezK9in90Uf+5VZHwg_meGy4egVTXHg=Q@mail.gmail.com>
Subject: Can't remove contents of table with truncate or drop
From: Jabbar <ajazam@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=14dae93b5e362a4f0504d522cd14

--14dae93b5e362a4f0504d522cd14
Content-Type: text/plain; charset=ISO-8859-1

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

--14dae93b5e362a4f0504d522cd14
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>Hello,<br><br></div><div>I&#39;m having problems=
 truncating or deleting the contents of a table. If I truncate the table an=
d then do a select count(*) I get a value above zero.<br></div><div>=A0If I=
 drop the table, recreate the table the select count(*) still returns a non=
 zero value.<br>
<br></div><div>The truncate or delete operation does not return any errors.=
<br></div><div><br>I am using cassandra 1.2.1 with java 1.6.0 u 39 64 bit i=
n centos 6.3<br></div><div><br></div>My keyspace definition is<br><br>CREAT=
E KEYSPACE studata WITH replication =3D {<br>
=A0 &#39;class&#39;: &#39;SimpleStrategy&#39;,<br>=A0 &#39;replication_fact=
or&#39;: &#39;3&#39;<br>};<br><br></div><div><br></div><div>My table defini=
tion is <br></div><div><br>CREATE TABLE datapoints (<br>=A0 siteid bigint,<=
br>
=A0 channel int,<br>=A0 time timestamp,<br>=A0 data float,<br>=A0 PRIMARY K=
EY ((siteid, channel), time)<br>) WITH<br>=A0 bloom_filter_fp_chance=3D0.01=
0000 AND<br>=A0 caching=3D&#39;KEYS_ONLY&#39; AND<br>=A0 comment=3D&#39;=
9; AND<br>=A0 dclocal_read_repair_chance=3D0.000000 AND<br>
=A0 gc_grace_seconds=3D864000 AND<br>=A0 read_repair_chance=3D0.100000 AND<=
br>=A0 replicate_on_write=3D&#39;true&#39; AND<br>=A0 compaction=3D{&#39;cl=
ass&#39;: &#39;SizeTieredCompactionStrategy&#39;} AND<br>=A0 compression=3D=
{&#39;sstable_compression&#39;: &#39;SnappyCompressor&#39;};<br>
<br><br></div><div>It has 3,504,000,000=A0 rows, consisting of 100,000 part=
ition keys.<br></div><div><br><br></div><div>Is there anything that I&#39;m=
 doing wrong?</div><div><div><br><br clear=3D"all"><div><br>-- <br>Thanks<b=
r>
<br>=A0A Jabbar Azam<br>
</div></div></div></div>

--14dae93b5e362a4f0504d522cd14--