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