Re: Data copy problem

2018-09-27 Thread rajasekhar kommineni
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 wrote: > > I hav

Re: Data copy problem

2018-09-26 Thread rajasekhar kommineni
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/sst

Re: Data copy problem

2018-09-26 Thread Kiran mk
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 wrote: > Hi All, > > I have a requirement to cop

Data copy problem

2018-09-26 Thread rajasekhar kommineni
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. A