Re: copy from one table to another

Thank you, Rahul! From: Rahul Singh <rahul.xavier.si...@gmail.com> Sent: Saturday, April 21, 2018 3:02:11 PM To: user@cassandra.apache.org Subject: Re: copy from one table to another That’s correct. On Apr 21, 2018, 5:05 AM -0400, Kyrylo Lebediev <kyr

Re: copy from one table to another

ul Singh <rahul.xavier.si...@gmail.com> > Sent: Thursday, April 19, 2018 10:53:11 PM > To: user@cassandra.apache.org > Subject: Re: copy from one table to another > > Each table has a different Guid — doing a hard link may work as long as the > sstable dir’s guid is h

Re: copy from one table to another

ame: ./data/test/usr-ea2f6da0f93111e7822443ca70555242 Correct? Regards, Kyrill From: Rahul Singh <rahul.xavier.si...@gmail.com> Sent: Thursday, April 19, 2018 10:53:11 PM To: user@cassandra.apache.org Subject: Re: copy from one table to another Each

Re: copy from one table to another

ul Singh <rahul.xavier.si...@gmail.com> > Sent: Wednesday, April 18, 2018 2:07:17 AM > To: user@cassandra.apache.org > Subject: Re: copy from one table to another > > 1. Make a new table with the same schema. > For each node > 2. Shutdown node > 3. Copy data from Sou

Re: copy from one table to another

:17 AM To: user@cassandra.apache.org Subject: Re: copy from one table to another 1. Make a new table with the same schema. For each node 2. Shutdown node 3. Copy data from Source sstable dir to new sstable dir. This will do what you want. -- Rahul Singh rahul.si...@anant.us Anant Corporation On

Re: copy from one table to another

ink.com> > Sent: Monday, April 16, 2018 6:51:51 PM > To: user@cassandra.apache.org > Subject: Re: copy from one table to another > > If you want to copy a portion of the data to another table, you can also use > sstable cql writer. It is more of an advanced feature and can be tr

Re: copy from one table to another

; Sent: Monday, April 16, 2018 6:51:51 PM To: user@cassandra.apache.org Subject: Re: copy from one table to another If you want to copy a portion of the data to another table, you can also use sstable cql writer. It is more of an advanced feature and can be tricky, but doable. once you write t

Re: copy from one table to another

be recorded. Kyrylo Lebediev <kyrylo_lebed...@epam.com> 04/16/2018 10:37 AM Please respond to user@cassandra.apache.org To "user@cassandra.apache.org" <user@cassandra.apache.org>, cc Subject Re: copy from one table to another Any issues if we: 1) create an new emp

Re: copy from one table to another

, as SSTables are immutable, this should work, but could there be some hidden issues? Regards, Kyrill From: Dmitry Saprykin <saprykin.dmi...@gmail.com> Sent: Sunday, April 8, 2018 7:33:03 PM To: user@cassandra.apache.org Subject: Re: copy from one table

Re: copy from one table to another

If you need this kind of logic, you might want to consider using Spark. It's often used for data migration. You could load your list of partition_key in a Spark RDD, then use joinWithCassandraTable, and write the result back to your destination table. Just before the join, you could use

Re: copy from one table to another

Thank you all I need something like this: insert into table test2 select * from test1 where partition_key='SOME_KEYS'; The problem with copying sstable is that original table contains some billions of records and i only want some hundred millions of records from the table, so after

Re: copy from one table to another

IMHO The best step by step description of what you need to do is here https://issues.apache.org/jira/browse/CASSANDRA-1585?focusedCommentId=13488959=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-13488959 The only difference is that you need to copy data from one

Re: copy from one table to another

You can use the same procedure to restore a table from snapshot from datastax webpage https://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_backup_snapshot_restore_t.html Just two modifications. after step 5, modify the name of the sstables to add the name of the table you want to

Re: copy from one table to another

You can copy hardlinks to ALL SSTables from old to new table and then delete part of data you do not need in a new one. On Sun, Apr 8, 2018 at 10:20 AM, Nitan Kainth wrote: > If it for testing and you don’t need any specific data, just copy a set of > sstables with all

Re: copy from one table to another

If it for testing and you don’t need any specific data, just copy a set of sstables with all files of that sequence and move to target tables directory and rename it. Restart target node or run nodetool refresh Sent from my iPhone > On Apr 8, 2018, at 4:15 AM, onmstester onmstester

copy from one table to another

Is there any way to copy some part of a table to another table in cassandra? A large amount of data should be copied so i don't want to fetch data to client and stream it back to cassandra using cql. Sent using Zoho Mail