You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Utku Can Topçu <ut...@topcu.gen.tr> on 2010/05/26 15:08:44 UTC

Moving/copying columns in between ColumnFamilies

Hey All,

Assume I have two ColumnFamilies in the same keyspace and I want to move or
copy a range of columns (defined by a keyrange) into another columnfamily.

Do you think it's somehow possible and doable with the current support of
the API, if so how?

Best Regards,
Utku

RE: Moving/copying columns in between ColumnFamilies

Posted by Dop Sun <su...@dopsun.com>.
In Thrift API, I guess you need to use read/ insert and then delete to implement the move action.

 

If you can shut the Cassandra down, maybe you can try to sstable2json to export data out, and json2sstable to import back to different column family file? I did not do it before, but I guess it may work if they have same schema definition. 

 

From: Utku Can Topçu [mailto:utku@topcu.gen.tr] 
Sent: Wednesday, May 26, 2010 9:18 PM
To: user@cassandra.apache.org
Subject: Re: Moving/copying columns in between ColumnFamilies

 

Sorry I now realized that I used the wrong terminology.

What I really meant was, moving or copying the ROWS defined by a KeyRange in between ColumnFamilies.
Do you think it's doable with an efficient way?

On Wed, May 26, 2010 at 3:14 PM, Dop Sun <su...@dopsun.com> wrote:

There are no single API call to achieve this.

 

It’s read and write, plus a delete (if move) API calls I guess.

 

From: Utku Can Topçu [mailto:utku@topcu.gen.tr] 
Sent: Wednesday, May 26, 2010 9:09 PM
To: user@cassandra.apache.org
Subject: Moving/copying columns in between ColumnFamilies

 

Hey All,

Assume I have two ColumnFamilies in the same keyspace and I want to move or copy a range of columns (defined by a keyrange) into another columnfamily.

Do you think it's somehow possible and doable with the current support of the API, if so how?

Best Regards,
Utku

 


Re: Moving/copying columns in between ColumnFamilies

Posted by Utku Can Topçu <ut...@topcu.gen.tr>.
Sorry I now realized that I used the wrong terminology.

What I really meant was, moving or copying the ROWS defined by a KeyRange in
between ColumnFamilies.
Do you think it's doable with an efficient way?

On Wed, May 26, 2010 at 3:14 PM, Dop Sun <su...@dopsun.com> wrote:

>  There are no single API call to achieve this.
>
>
>
> It’s read and write, plus a delete (if move) API calls I guess.
>
>
>
> *From:* Utku Can Topçu [mailto:utku@topcu.gen.tr]
> *Sent:* Wednesday, May 26, 2010 9:09 PM
> *To:* user@cassandra.apache.org
> *Subject:* Moving/copying columns in between ColumnFamilies
>
>
>
> Hey All,
>
> Assume I have two ColumnFamilies in the same keyspace and I want to move or
> copy a range of columns (defined by a keyrange) into another columnfamily.
>
> Do you think it's somehow possible and doable with the current support of
> the API, if so how?
>
> Best Regards,
> Utku
>

RE: Moving/copying columns in between ColumnFamilies

Posted by Dop Sun <su...@dopsun.com>.
There are no single API call to achieve this.

 

It’s read and write, plus a delete (if move) API calls I guess.

 

From: Utku Can Topçu [mailto:utku@topcu.gen.tr] 
Sent: Wednesday, May 26, 2010 9:09 PM
To: user@cassandra.apache.org
Subject: Moving/copying columns in between ColumnFamilies

 

Hey All,

Assume I have two ColumnFamilies in the same keyspace and I want to move or copy a range of columns (defined by a keyrange) into another columnfamily.

Do you think it's somehow possible and doable with the current support of the API, if so how?

Best Regards,
Utku