You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by rajasekhar kommineni <ra...@gmail.com> on 2018/09/26 22:35:25 UTC
Data copy problem
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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org
Re: Data copy problem
Posted by rajasekhar kommineni <ra...@gmail.com>.
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 <ra...@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 <coolkiran2006@gmail.com <ma...@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 <rajacoast@gmail.com <ma...@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-unsubscribe@cassandra.apache.org <ma...@cassandra.apache.org>
>> For additional commands, e-mail: user-help@cassandra.apache.org <ma...@cassandra.apache.org>
>>
>> --
>> Best Regards,
>> Kiran.M.K.
>
Re: Data copy problem
Posted by rajasekhar kommineni <ra...@gmail.com>.
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 <co...@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 <rajacoast@gmail.com <ma...@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-unsubscribe@cassandra.apache.org <ma...@cassandra.apache.org>
> For additional commands, e-mail: user-help@cassandra.apache.org <ma...@cassandra.apache.org>
>
> --
> Best Regards,
> Kiran.M.K.
Re: Data copy problem
Posted by Kiran mk <co...@gmail.com>.
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 <ra...@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-unsubscribe@cassandra.apache.org
> For additional commands, e-mail: user-help@cassandra.apache.org
>
> --
Best Regards,
Kiran.M.K.