Migrating data from one table to other in cassandra -

i need migrate data 1 table other.

create table asses (   id uuid,   toid text,   name text,   fbid text,   primary key (id) ) coments = ''; create table basses (   id text,   canid uuid,   primary key (id) ) comment= ''; 

i need move data asses basses. data coulmns name , fbid should go id , data id should go canid.

i know joins not work here.

how make work?

the following copy commands should trick:

copy asses (name, id) 'file1.csv'; copy asses (fbid, id) 'file2.csv';  copy basses (id, canid) 'file1.csv'; copy basses (id, canid) 'file2.csv'; 

you can delete rows original table:

truncate asses; 

hope helps.