migration to a new model

[Marcelo Elias Del Valle]

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.