Re: Can't remove contents of table with truncate or drop

2013-02-08 Thread Jabbar
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

Can't remove contents of table with truncate or drop

2013-02-07 Thread Jabbar
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

Re: Can't remove contents of table with truncate or drop

2013-02-07 Thread aaron morton
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