You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Chidambaran Subramanian <ch...@gmail.com> on 2013/04/30 14:39:42 UTC
Exporting all data within a keyspace
Is there any easy way of exporting all data for a keyspace (and conversely)
importing it.
Regards
Chiddu
Re: Exporting all data within a keyspace
Posted by Chidambaran Subramanian <ch...@gmail.com>.
Thanks guys,both are good pointers
Regards
Chiddu
On Tue, Apr 30, 2013 at 7:09 PM, Brian O'Neill <bo...@alumni.brown.edu>wrote:
>
> You could always do something like this as well:
>
> http://brianoneill.blogspot.com/2012/05/dumping-data-from-cassandra-like.html
>
> -brian
>
> ---
>
> Brian O'Neill
>
> Lead Architect, Software Development
>
> *Health Market Science*
>
> *The Science of Better Results*
>
> 2700 Horizon Drive • King of Prussia, PA • 19406****
>
> M: 215.588.6024 • @boneill42 <http://www.twitter.com/boneill42> •
>
> healthmarketscience.com
>
>
> This information transmitted in this email message is for the intended
> recipient only and may contain confidential and/or privileged material. If
> you received this email in error and are not the intended recipient, or the
> person responsible to deliver it to the intended recipient, please contact
> the sender at the email above and delete this email and any attachments and
> destroy any copies thereof. Any review, retransmission, dissemination,
> copying or other use of, or taking any action in reliance upon, this
> information by persons or entities other than the intended recipient is
> strictly prohibited.****
>
> ** **
>
>
> From: Kumar Ranjan <wi...@gmail.com>
> Reply-To: <us...@cassandra.apache.org>
> Date: Tuesday, April 30, 2013 9:11 AM
> To: "user@cassandra.apache.org" <us...@cassandra.apache.org>
> Subject: Re: Exporting all data within a keyspace
>
> Try sstable2json and json2sstable. But it works on column family so you
> can fetch all column family and iterate over list of CF and use
> sstable2json tool to extract data. Remember this will only fetch on disk
> data do anything in memtable/cache which is to be flushed will be missed.
> So run compaction and then run the written script.
>
> On Tuesday, April 30, 2013, Chidambaran Subramanian wrote:
>
>> Is there any easy way of exporting all data for a keyspace (and
>> conversely) importing it.
>>
>> Regards
>> Chiddu
>>
>
Re: Exporting all data within a keyspace
Posted by Brian O'Neill <bo...@alumni.brown.edu>.
You could always do something like this as well:
http://brianoneill.blogspot.com/2012/05/dumping-data-from-cassandra-like.htm
l
-brian
---
Brian O'Neill
Lead Architect, Software Development
Health Market Science
The Science of Better Results
2700 Horizon Drive King of Prussia, PA 19406
M: 215.588.6024 @boneill42 <http://www.twitter.com/boneill42>
healthmarketscience.com
This information transmitted in this email message is for the intended
recipient only and may contain confidential and/or privileged material. If
you received this email in error and are not the intended recipient, or the
person responsible to deliver it to the intended recipient, please contact
the sender at the email above and delete this email and any attachments and
destroy any copies thereof. Any review, retransmission, dissemination,
copying or other use of, or taking any action in reliance upon, this
information by persons or entities other than the intended recipient is
strictly prohibited.
From: Kumar Ranjan <wi...@gmail.com>
Reply-To: <us...@cassandra.apache.org>
Date: Tuesday, April 30, 2013 9:11 AM
To: "user@cassandra.apache.org" <us...@cassandra.apache.org>
Subject: Re: Exporting all data within a keyspace
Try sstable2json and json2sstable. But it works on column family so you can
fetch all column family and iterate over list of CF and use sstable2json
tool to extract data. Remember this will only fetch on disk data do anything
in memtable/cache which is to be flushed will be missed. So run compaction
and then run the written script.
On Tuesday, April 30, 2013, Chidambaran Subramanian wrote:
> Is there any easy way of exporting all data for a keyspace (and conversely)
> importing it.
>
> Regards
> Chiddu
Re: Exporting all data within a keyspace
Posted by Kumar Ranjan <wi...@gmail.com>.
Try sstable2json and json2sstable. But it works on column family so you can
fetch all column family and iterate over list of CF and use sstable2json
tool to extract data. Remember this will only fetch on disk data do
anything in memtable/cache which is to be flushed will be missed. So run
compaction and then run the written script.
On Tuesday, April 30, 2013, Chidambaran Subramanian wrote:
> Is there any easy way of exporting all data for a keyspace (and
> conversely) importing it.
>
> Regards
> Chiddu
>