Re: Migrate table data to another table

[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

[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
>>>
>>
>>