incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jabbar <aja...@gmail.com>
Subject Can't remove contents of table with truncate or drop
Date Thu, 07 Feb 2013 13:55:54 GMT
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

Mime
View raw message