Hi Jens, Thanks for trying to help.
Indeed, I know I can't do it using just CQL. But what would you use to migrate data manually? I tried to create a python program using auto paging, but I am getting timeouts. I also tried Hive, but no success. I only have two nodes and less than 200Gb in this cluster, any simple way to extract the data quickly would be good enough for me. Best regards, Marcelo. 2014-06-02 15:08 GMT-03:00 Jens Rantil <jens.ran...@tink.se>: > Hi Marcelo, > > Looks like you can't do this without migrating your data manually: > https://stackoverflow.com/questions/18421668/alter-cassandra-column-family-primary-key-using-cassandra-cli-or-cql > > Cheers, > Jens > > > On Mon, Jun 2, 2014 at 7:48 PM, Marcelo Elias Del Valle < > marc...@s1mbi0se.com.br> wrote: > >> Hi, >> >> I have some cql CFs in a 2 node Cassandra 2.0.8 cluster. >> >> I realized I created my column family with the wrong partition. Instead >> of: >> >> CREATE TABLE IF NOT EXISTS entity_lookup ( >> name varchar, >> value varchar, >> entity_id uuid, >> PRIMARY KEY ((name, value), entity_id)) >> WITH >> caching=all; >> >> I used: >> >> CREATE TABLE IF NOT EXISTS entitylookup ( >> name varchar, >> value varchar, >> entity_id uuid, >> PRIMARY KEY (name, value, entity_id)) >> WITH >> caching=all; >> >> >> Now I need to migrate the data from the second CF to the first one. >> I am using Data Stax Community Edition. >> >> What would be the best way to convert data from one CF to the other? >> >> Best regards, >> Marcelo. >> > >
