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. >