What is a good way to copy data from one Cassandra ColumnFamily to another on the same Keyspace (like SQL's INSERT INTO)?

Question

Trying to find a way to easily transfer all the rows from a Cassandra ColumnFamily/Table to another.

The COPY command, as I understand, is a good option. However, as it dumps all the data to .csv on disk and then loads it back, I can't help but wonder if there is a better way to do it in-engine.

A specific example of what I mean would be the INSERT * FROM my_table INTO my_other_table available in many SQL databases. Of course, I realize that Cassandra is NoSQL and therefore does not to work the same way - but it seems like something which might be available.

What is a good way to accomplish this?

Thanks very much!

score 11 · Answer 1 · edited Aug 16 '14 at 13:13

11

cqlsh -k mykeyspace -e 'COPY fromTable(columnNames) TO STDOUT' | head -n -1 | 
cqlsh -k mykeyspace -e 'COPY toTable(columnNames) FROM STDIN'

edited Aug 16 '14 at 13:13

Paul White

94,921
30
437
687

answered Aug 16 '14 at 12:53

Vilmos Kiss

111
1
2

score 2 · Answer 2 · edited Apr 09 '20 at 14:01

2

Did you take a look at sstableloader?

edited Apr 09 '20 at 14:01

Peter Vandivier

5,485
1
25
49

answered Mar 05 '14 at 19:05

Mikhail Stepura

189
1

What is a good way to copy data from one Cassandra ColumnFamily to another on the same Keyspace (like SQL's INSERT INTO)?

2 Answers2