Just wanted to let you know running the command from all the nodes matched the count of records on both clusters
One more question, can any body know how to import the data in different keyspace using sstableloader Thanks, > On Sep 26, 2018, at 3:56 PM, rajasekhar kommineni <rajaco...@gmail.com> wrote: > > I have to copy whole key space which has many tables, some tables are 30 GB. > Copy is going to take more and also load is shooting up. > > I have a 4 node source cluster and 4 node cluster target cluster. My question > is do need to execute below command from all the nodes of source cluster ? > > /bin/sstableloader -d node1,node2,node3,node4 ‘path to folder’ > > Thanks, > > >> On Sep 26, 2018, at 3:43 PM, Kiran mk <coolkiran2...@gmail.com >> <mailto:coolkiran2...@gmail.com>> wrote: >> >> Please do try COPY TO commas to dump the data with csv or any other >> delimited format to dump. Then try Run COPY FROM on target cluster after >> copying the exported file. >> >> Best Regards, >> Kiran.M.K >> >> >> On Thu, 27 Sep 2018 at 4:05 AM, rajasekhar kommineni <rajaco...@gmail.com >> <mailto:rajaco...@gmail.com>> wrote: >> Hi All, >> >> I have a requirement to copy table data from cluster to another cluster, I >> used both sstableloader and copy snapshot, run nodetool refresh command. In >> both cases the count of records in new cluster is less than original >> cluster. >> I used select count(*) table name to count the records. >> >> Any body have clue on how this works. >> >> Thanks, >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org >> <mailto:user-unsubscr...@cassandra.apache.org> >> For additional commands, e-mail: user-h...@cassandra.apache.org >> <mailto:user-h...@cassandra.apache.org> >> >> -- >> Best Regards, >> Kiran.M.K. >