efficiently generate complete database dump in text format

2014-10-09 Thread Gaurav Bhatnagar
Hi, We have a Cassandra database column family containing 320 millions rows and each row contains about 15 columns. We want to take monthly dump of this single column family contained in this database in text format. We are planning to take following approach to implement this functionality 1.

RE: Doubts with the values of the parameter broadcast_rpc_address

2014-10-09 Thread Ricard Mestre Subirats
Thank you Tyler! It’s true that the cluster works! However I’m going to ask for the error of nodetool because it interest us. Thank you! Ricard De: Tyler Hobbs [mailto:ty...@datastax.com] Enviado el: miércoles, 08 de octubre de 2014 17:25 Para: user@cassandra.apache.org Asunto: Re: Doubts with t

Error conection in Nodetool

2014-10-09 Thread Ricard Mestre Subirats
Hi everyone, I have an issue with nodetool conection. I'm configuring a 2 node cluster with Cassandra 2.1 and 8.0 Java version, and I'm having problems with nodetool. The configuration of the machines is the following: At the machine with IP 192.168.150.112: -cluster_nam

Re: Multi-DC Repairs and Token Questions

2014-10-09 Thread Alain RODRIGUEZ
Ok got it. Thanks. 2014-10-07 14:56 GMT+02:00 Paulo Ricardo Motta Gomes < paulo.mo...@chaordicsystems.com>: > This related issue might be of interest: > https://issues.apache.org/jira/browse/CASSANDRA-7450 > > In 1.2 "-pr" option does make cross DC repairs, but you must ensure that > all nodes f

Re: efficiently generate complete database dump in text format

2014-10-09 Thread Paulo Ricardo Motta Gomes
The best way to generate dumps from Cassandra is via Hadoop integration (or spark). You can find more info here: http://www.datastax.com/documentation/cassandra/2.1/cassandra/configuration/configHadoop.html http://wiki.apache.org/cassandra/HadoopSupport On Thu, Oct 9, 2014 at 4:19 AM, Gaurav Bhat

Re: efficiently generate complete database dump in text format

2014-10-09 Thread Daniel Chia
You might also want to consider tools like https://github.com/Netflix/aegisthus for the last step, which can help you deal with tombstones and de-duplicate data. Thanks, Daniel On Thu, Oct 9, 2014 at 12:19 AM, Gaurav Bhatnagar wrote: > Hi, >We have a Cassandra database column family contain

Disabling compaction

2014-10-09 Thread Parag Shah
Hi all, I am trying to disable compaction for a few select tables. Here is a definition of one such table: CREATE TABLE blob_2014_12_31 ( blob_id uuid, blob_index int, blob_chunk blob, PRIMARY KEY (blob_id, blob_index) ) WITH bloom_filter_fp_chance=0.01 AND caching='KEYS_ONL

Deleting counters

2014-10-09 Thread Robert Wille
At the Cassandra Summit I became aware of that there are issues with deleting counters. I have a few questions about that. What is the bad thing that happens (or can possibly happen) when a counter is deleted? Is it safe to delete an entire row of counters? Is there any 2.0.x version of Cassandr

Re: Deleting counters

2014-10-09 Thread Robert Coli
On Thu, Oct 9, 2014 at 3:29 PM, Robert Wille wrote: > What is the bad thing that happens (or can possibly happen) when a counter > is deleted? > You get totally wacky counter state if you, later, re-create and use it. https://issues.apache.org/jira/browse/CASSANDRA-6532 and https://issues.apach

Re: Disabling compaction

2014-10-09 Thread Marcus Eriksson
what version are you on? On Thu, Oct 9, 2014 at 10:33 PM, Parag Shah wrote: > Hi all, > > I am trying to disable compaction for a few select tables. Here is > a definition of one such table: > > CREATE TABLE blob_2014_12_31 ( > blob_id uuid, > blob_index int, > blob_chunk blob, >