You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by xavier manach <xa...@tekio.org> on 2010/07/16 15:53:55 UTC

Extraction Cassandra from SSTables Files ?

Hi.

   What is the best method for make large extract of datas from cassandra ?
Extract directly from the SSTables files sound good ?
If yes,
  There is an API for exploit directly the SSTables files ?
  There is a specification of the SSTables files ?

Thx.

Re: Extraction Cassandra from SSTables Files ?

Posted by aaron morton <aa...@thelastpickle.com>.
It's a non trivial, but you could try using haddop/pig. Take a look at contrib/pig in the source. 

You could output flat file formats. 

Aaron


On 17 Jul 2010, at 02:09, Sylvain Lebresne wrote:

> On Fri, Jul 16, 2010 at 3:53 PM, xavier manach <xa...@tekio.org> wrote:
>> Hi.
>> 
>>   What is the best method for make large extract of datas from cassandra ?
>> Extract directly from the SSTables files sound good ?
>> If yes,
>>  There is an API for exploit directly the SSTables files ?
>>  There is a specification of the SSTables files ?
> 
> Not really, but you can have a look at the sstable2json tool. You may not be
> able to afford converting to json, but it shouldn't be too hard to
> modify it for your
> needs if you are motivated enough.
> 
> --
> Sylvain


Re: Extraction Cassandra from SSTables Files ?

Posted by Sylvain Lebresne <sy...@yakaz.com>.
On Fri, Jul 16, 2010 at 3:53 PM, xavier manach <xa...@tekio.org> wrote:
> Hi.
>
>   What is the best method for make large extract of datas from cassandra ?
> Extract directly from the SSTables files sound good ?
> If yes,
>  There is an API for exploit directly the SSTables files ?
>  There is a specification of the SSTables files ?

Not really, but you can have a look at the sstable2json tool. You may not be
able to afford converting to json, but it shouldn't be too hard to
modify it for your
needs if you are motivated enough.

--
Sylvain