incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jens Rantil <jens.ran...@tink.se>
Subject Re: migration to a new model
Date Mon, 02 Jun 2014 18:08:46 GMT
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 <
marcelo@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.
>

Mime
View raw message