Thank you, Rahul!
From: Rahul Singh
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 ,
wrote:
You mean that correct table UUID
gt; 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 he same as the newly created table in the system sc
555242
Directory name:
./data/test/usr-ea2f6da0f93111e7822443ca70555242
Correct?
Regards,
Kyrill
From: Rahul Singh
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 differ
hardlinks. After this both tables should be used independently (RW).
> > Is this a supported way or not?
> >
> > Regards,
> > Kyrill
> > From: Ali Hubail
> > Sent: Monday, April 16, 2018 6:51:51 PM
> > To: user@cassandra.apache.org
> > Subject:
ndra.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 Apr 16, 2018, 4:21 P
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 the new sstabl
: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 the new sstables, you can then use the
ay be
recorded.
Kyrylo Lebediev
04/16/2018 10:37 AM
Please respond to
user@cassandra.apache.org
To
"user@cassandra.apache.org" ,
cc
Subject
Re: copy from one table to another
Any issues if we:
1) create an new empty table with the same structure as the old one
2) create hardlinks
, as SSTables are immutable, this should work, but could there be some
hidden issues?
Regards,
Kyrill
From: Dmitry Saprykin
Sent: Sunday, April 8, 2018 7:33:03 PM
To: user@cassandra.apache.org
Subject: Re: copy from one table to another
You can copy har
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 repartition
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 copy/pastin
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&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-13488959
The only difference is that you need to copy data from one
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
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 files of that sequence and
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 wrote:
>
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
16 matches
Mail list logo
