You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Umut Kocasaraç <uk...@gmail.com> on 2015/06/30 19:18:44 UTC
Migrate table data to another table
Hi,
I want to change clustering order column of my table. As far as i know it
is not possible to use alter command so i have created new table and i
would like to move data from old table to this one.
I am using Cassandra 2.0.7 and there is almost 100GB data on table. Is
there any easy method to move data except "Copy" command.
Thanks
Umut
Re: Migrate table data to another table
Posted by Sebastian Estevez <se...@datastax.com>.
Not yet, there is a ticket for CTAS for copy which will use spark to do
what you are looking for.
On Jul 1, 2015 3:31 AM, "Umut Kocasaraç" <uk...@gmail.com> wrote:
> In both methods i have to export table to one file and the i can move data
> to new table. Can i copy from one table to another?
>
> 30 Haz 2015 Sal, 20:31 tarihinde, Sebastian Estevez <
> sebastian.estevez@datastax.com> şunu yazdı:
>
>> Another option is Brian's cassandra loader:
>>
>> https://github.com/brianmhess/cassandra-loader
>>
>> All the best,
>>
>>
>> [image: datastax_logo.png] <http://www.datastax.com/>
>>
>> Sebastián Estévez
>>
>> Solutions Architect | 954 905 8615 | sebastian.estevez@datastax.com
>>
>> [image: linkedin.png] <https://www.linkedin.com/company/datastax> [image:
>> facebook.png] <https://www.facebook.com/datastax> [image: twitter.png]
>> <https://twitter.com/datastax> [image: g+.png]
>> <https://plus.google.com/+Datastax/about>
>> <http://feeds.feedburner.com/datastax>
>>
>> <http://cassandrasummit-datastax.com/>
>>
>> DataStax is the fastest, most scalable distributed database technology,
>> delivering Apache Cassandra to the world’s most innovative enterprises.
>> Datastax is built to be agile, always-on, and predictably scalable to any
>> size. With more than 500 customers in 45 countries, DataStax is the
>> database technology and transactional backbone of choice for the worlds
>> most innovative companies such as Netflix, Adobe, Intuit, and eBay.
>>
>> On Tue, Jun 30, 2015 at 1:26 PM, John Sanda <jo...@gmail.com> wrote:
>>
>>> You might want to take a look at CQLSSTableWriter[1] in the Cassandra
>>> source tree.
>>>
>>> http://www.datastax.com/dev/blog/using-the-cassandra-bulk-loader-updated
>>>
>>> On Tue, Jun 30, 2015 at 1:18 PM, Umut Kocasaraç <uk...@gmail.com>
>>> wrote:
>>>
>>>> Hi,
>>>> I want to change clustering order column of my table. As far as i know
>>>> it is not possible to use alter command so i have created new table and i
>>>> would like to move data from old table to this one.
>>>>
>>>> I am using Cassandra 2.0.7 and there is almost 100GB data on table. Is
>>>> there any easy method to move data except "Copy" command.
>>>>
>>>> Thanks
>>>>
>>>> Umut
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> - John
>>>
>>
>>
Re: Migrate table data to another table
Posted by Umut Kocasaraç <uk...@gmail.com>.
In both methods i have to export table to one file and the i can move data
to new table. Can i copy from one table to another?
30 Haz 2015 Sal, 20:31 tarihinde, Sebastian Estevez <
sebastian.estevez@datastax.com> şunu yazdı:
> Another option is Brian's cassandra loader:
>
> https://github.com/brianmhess/cassandra-loader
>
> All the best,
>
>
> [image: datastax_logo.png] <http://www.datastax.com/>
>
> Sebastián Estévez
>
> Solutions Architect | 954 905 8615 | sebastian.estevez@datastax.com
>
> [image: linkedin.png] <https://www.linkedin.com/company/datastax> [image:
> facebook.png] <https://www.facebook.com/datastax> [image: twitter.png]
> <https://twitter.com/datastax> [image: g+.png]
> <https://plus.google.com/+Datastax/about>
> <http://feeds.feedburner.com/datastax>
>
> <http://cassandrasummit-datastax.com/>
>
> DataStax is the fastest, most scalable distributed database technology,
> delivering Apache Cassandra to the world’s most innovative enterprises.
> Datastax is built to be agile, always-on, and predictably scalable to any
> size. With more than 500 customers in 45 countries, DataStax is the
> database technology and transactional backbone of choice for the worlds
> most innovative companies such as Netflix, Adobe, Intuit, and eBay.
>
> On Tue, Jun 30, 2015 at 1:26 PM, John Sanda <jo...@gmail.com> wrote:
>
>> You might want to take a look at CQLSSTableWriter[1] in the Cassandra
>> source tree.
>>
>> http://www.datastax.com/dev/blog/using-the-cassandra-bulk-loader-updated
>>
>> On Tue, Jun 30, 2015 at 1:18 PM, Umut Kocasaraç <uk...@gmail.com>
>> wrote:
>>
>>> Hi,
>>> I want to change clustering order column of my table. As far as i know
>>> it is not possible to use alter command so i have created new table and i
>>> would like to move data from old table to this one.
>>>
>>> I am using Cassandra 2.0.7 and there is almost 100GB data on table. Is
>>> there any easy method to move data except "Copy" command.
>>>
>>> Thanks
>>>
>>> Umut
>>>
>>
>>
>>
>> --
>>
>> - John
>>
>
>
Re: Migrate table data to another table
Posted by Sebastian Estevez <se...@datastax.com>.
Another option is Brian's cassandra loader:
https://github.com/brianmhess/cassandra-loader
All the best,
[image: datastax_logo.png] <http://www.datastax.com/>
Sebastián Estévez
Solutions Architect | 954 905 8615 | sebastian.estevez@datastax.com
[image: linkedin.png] <https://www.linkedin.com/company/datastax> [image:
facebook.png] <https://www.facebook.com/datastax> [image: twitter.png]
<https://twitter.com/datastax> [image: g+.png]
<https://plus.google.com/+Datastax/about>
<http://feeds.feedburner.com/datastax>
<http://cassandrasummit-datastax.com/>
DataStax is the fastest, most scalable distributed database technology,
delivering Apache Cassandra to the world’s most innovative enterprises.
Datastax is built to be agile, always-on, and predictably scalable to any
size. With more than 500 customers in 45 countries, DataStax is the
database technology and transactional backbone of choice for the worlds
most innovative companies such as Netflix, Adobe, Intuit, and eBay.
On Tue, Jun 30, 2015 at 1:26 PM, John Sanda <jo...@gmail.com> wrote:
> You might want to take a look at CQLSSTableWriter[1] in the Cassandra
> source tree.
>
> http://www.datastax.com/dev/blog/using-the-cassandra-bulk-loader-updated
>
> On Tue, Jun 30, 2015 at 1:18 PM, Umut Kocasaraç <uk...@gmail.com>
> wrote:
>
>> Hi,
>> I want to change clustering order column of my table. As far as i know it
>> is not possible to use alter command so i have created new table and i
>> would like to move data from old table to this one.
>>
>> I am using Cassandra 2.0.7 and there is almost 100GB data on table. Is
>> there any easy method to move data except "Copy" command.
>>
>> Thanks
>>
>> Umut
>>
>
>
>
> --
>
> - John
>
Re: Migrate table data to another table
Posted by John Sanda <jo...@gmail.com>.
You might want to take a look at CQLSSTableWriter[1] in the Cassandra
source tree.
http://www.datastax.com/dev/blog/using-the-cassandra-bulk-loader-updated
On Tue, Jun 30, 2015 at 1:18 PM, Umut Kocasaraç <uk...@gmail.com>
wrote:
> Hi,
> I want to change clustering order column of my table. As far as i know it
> is not possible to use alter command so i have created new table and i
> would like to move data from old table to this one.
>
> I am using Cassandra 2.0.7 and there is almost 100GB data on table. Is
> there any easy method to move data except "Copy" command.
>
> Thanks
>
> Umut
>
--
- John