Re: Cassandra copy command

2019-08-22 Thread Ahmed Eljami
Hello, As Jean said il will be preferable to use http://cassandra-reaper.io So you don't have to manually manage the consistency of your cassandra ring nor the list of nodes to repair. Le mer. 21 août 2019 à 15:57, Rahul Reddy a écrit : > Thanks Jean, > > I have dc1 and dc2 existing. added d

Re: Cassandra copy command

2019-08-21 Thread Rahul Reddy
Thanks Jean, I have dc1 and dc2 existing. added dc3 from dc1 and dc4 from dc2. If I want to run repair on one node in dc3 from dc1 only is it possible? On Wed, Aug 21, 2019, 8:11 AM Jean Carlo wrote: > Hello Rahul, > > To ensure the consistency among the DCs, it is enough to run a repair > comm

Re: Cassandra copy command

2019-08-21 Thread Jean Carlo
Hello Rahul, To ensure the consistency among the DCs, it is enough to run a repair command. You can do it using http://cassandra-reaper.io/ or runing the commande *nodetool repair* with the respectively options in every node. You do not need to count the rows in every DC to ensure cassandra is s

Re: Cassandra copy command

2019-08-21 Thread Rahul Reddy
Yep I did run rebuild on each new node On Wed, Aug 21, 2019, 7:25 AM Stefan Miklosovic < stefan.mikloso...@instaclustr.com> wrote: > Hi Rahul, > > how did you add that dc3 to cluster? The rule of thumb here is to do > rebuild from each node, for example like here > > https://docs.datastax.com/e

Re: Cassandra copy command

2019-08-21 Thread Stefan Miklosovic
Hi Rahul, how did you add that dc3 to cluster? The rule of thumb here is to do rebuild from each node, for example like here https://docs.datastax.com/en/archived/cassandra/3.0/cassandra/operations/opsAddDCToCluster.html On Wed, 21 Aug 2019 at 12:57, Rahul Reddy wrote: > > Hi sefan, > > I'm addi

Re: Cassandra copy command

2019-08-21 Thread Rahul Reddy
Hi sefan, I'm adding new DC3 to exiting cluster and see discripencies couple of millions in Nodetool cfstats in new DC. My table size is 50gb I'm trying to run copy entire table. Copy table to 'full_tablr.csv' with delimiter ','; If I run above command from dc3. Does it get the data only from d

Re: Cassandra copy command

2019-08-21 Thread Stefan Miklosovic
Hi Rahul, what is your motivation behind this? Why do you want to make sure the count is same? What is the purpose of that? All you should care about is that Cassandra will return you right results. It was designed from the very bottom to do that for you, you should not be bothered too much about

Cassandra copy command

2019-08-21 Thread Rahul Reddy
Hello, I have 3 datacenters . Want to make sure record count is same in all dc's . If I run copy command node1 in dc1 does it get the data from only dc1? Nodetool cfstats I'm seeing discrepancies in partitions count is it because we didn't run cleanup after adding few nodes and remove them?. To ru

Re: [EXTERNAL] Cassandra copy command is giving OverflowError

2017-09-22 Thread AI Rumman
ns DBA > > Seattle, WA > > Email : kishore.mohapa...@nuance.com > > > > > > *From:* AI Rumman [mailto:rumman...@gmail.com] > *Sent:* Thursday, September 21, 2017 11:24 PM > *To:* user@cassandra.apache.org > *Subject:* [EXTERNAL] Cassandra copy command is giving OverflowEr

RE: [EXTERNAL] Cassandra copy command is giving OverflowError

2017-09-22 Thread Mohapatra, Kishore
] Sent: Thursday, September 21, 2017 11:24 PM To: user@cassandra.apache.org Subject: [EXTERNAL] Cassandra copy command is giving OverflowError Hi, This is my first post here. I am copying my writings from https://stackoverflow.com/questions/46354677/cassandra-copy-command-is-giving-ove

Cassandra copy command is giving OverflowError

2017-09-21 Thread AI Rumman
Hi, This is my first post here. I am copying my writings from https://stackoverflow.com/questions/46354677/cassandra-copy-command-is-giving-overflowerror I am new with Cassandra and running DataStax Cassandra 4.8.14. My cluster is as: 3 nodes - cassandra 3 nodes - solr search by DataStax