Re: Question about how to remove data

2015-08-19 Thread Analia Lorenzatto
Hello Michael, Thanks for responding! I do not have snapshots on any node of the cluster. Saludos / Regards. Analía Lorenzatto. "Hapiness is not something really made. It comes from your own actions" by Dalai Lama On 19 Aug 2015 6:19 pm, "Laing, Michael" wrote: > Possibly you have snapshot

Re: Question about how to remove data

2015-08-19 Thread Laing, Michael
Possibly you have snapshots? If so, use nodetool to clear them. On Wed, Aug 19, 2015 at 4:54 PM, Analia Lorenzatto < analialorenza...@gmail.com> wrote: > Hello guys, > > I have a cassandra cluster 2.1 comprised of 4 nodes. > > I removed a lot of data in a Column Family, then I ran manually a > co

Question about how to remove data

2015-08-19 Thread Analia Lorenzatto
Hello guys, I have a cassandra cluster 2.1 comprised of 4 nodes. I removed a lot of data in a Column Family, then I ran manually a compaction on this Column family on every node. After doing that, If I query that data, cassandra correctly says this data is not there. But the space on disk is e

Re: Truncate Table - What happens to indexes?

2015-08-19 Thread Robert Coli
On Wed, Aug 19, 2015 at 11:05 AM, Rahul Gupta wrote: > What happens to indexes when a table is truncated? > > Indexes are removed or they stay around? > Secondary indexes are stored on disk in the same data directory as the data and are truncated when the data they index is truncated. =Rob

Truncate Table - What happens to indexes?

2015-08-19 Thread Rahul Gupta
What happens to indexes when a table is truncated? Indexes are removed or they stay around? Rahul Gupta DEKA Research & Development 340 Commercial St Manchester, NH 03101 P: 603.666.3908 extn. 6504 | C: 603.718.9676 This e-mail and the information, including any a

Re: Null pointer exception after delete in a table with statics

2015-08-19 Thread Sebastian Estevez
Can you include your read code? On Aug 18, 2015 5:50 AM, "Hervé Rivière" wrote: > Hello, > > > > > > I have an issue with a message="java.lang.NullPointerException"> when I query a table with static > fields (without where clause) with Cassandra 2.1.8 / 2 nodes clusters. > > > > No more indicati

RE: Null pointer exception after delete in a table with statics

2015-08-19 Thread Hervé Rivière
Hello Doan, Thank you for your answer ! In my spark job I changed the spark.cassandra.input.split.size (spark.cassandra.input.fetch.size_in_rows isn’t recognize in my v. 1.2.3 spark-cassandra-connector) from 8 000 to 200 (so that’s create a lot more tasks by node) but I still have the null p

Re: Nodetool repair with Load times 5

2015-08-19 Thread Jean Tremblay
Dear Alain, Thanks again for your precious help. I might help, but I need to know what you have done recently (change the RF, Add remove node, cleanups, anything else as much as possible...) I have a cluster of 5 nodes all running Cassandra 2.1.8. I have a fixed schema which never changes. I ha