incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcelo Elias Del Valle <marc...@s1mbi0se.com.br>
Subject Re: migration to a new model
Date Mon, 02 Jun 2014 18:15:04 GMT
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.rantil@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 <
> 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