incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nilabja Banerjee <nilabja.baner...@gmail.com>
Subject Re: Need help json2sstable
Date Thu, 21 Jul 2011 13:15:28 GMT
Thank You...

But truely speaking I dnt get you.... what do you mean by* key is binary, so
thats the ascii encoding for foo *
and another thing... this is the output of "list BTP" command

RowKey: 09000002
=> (super_column=09000002,
     (column=30, value=303039303030303032, timestamp=1310471032735000)
     (column=31, value=303139303030303032, timestamp=1310471032737000)
     (column=3130, value=30313039303030303032, timestamp=1310471032750000)
     (column=3131, value=30313139303030303032, timestamp=1310471032752000)
     (column=3132, value=30313239303030303032, timestamp=1310471032753000)
     (column=3133, value=30313339303030303032, timestamp=1310471032755000)
     (column=3134, value=30313439303030303032, timestamp=1310471032757000)
     (column=3135, value=30313539303030303032, timestamp=1310471032758000)
     (column=3136, value=30313639303030303032, timestamp=1310471032760000)
     (column=3137, value=30313739303030303032, timestamp=1310471032761000)
     (column=3138, value=30313839303030303032, timestamp=1310471032763000)
     (column=3139, value=30313939303030303032, timestamp=1310471032764000)
     (column=32, value=303239303030303032, timestamp=1310471032738000)
     (column=3230, value=30323039303030303032, timestamp=1310471032766000)
     (column=3231, value=30323139303030303032, timestamp=1310471032767000)
     (column=3232, value=30323239303030303032, timestamp=1310471032769000)
     (column=3233, value=30323339303030303032, timestamp=1310471032771000)
     (column=3234, value=30323439303030303032, timestamp=1310471032772000)
     (column=3235, value=30323539303030303032, timestamp=1310471032774000)
     (column=3236, value=30323639303030303032, timestamp=1310471032775000)
     (column=3237, value=30323739303030303032, timestamp=1310471032776000)
     (column=3238, value=30323839303030303032, timestamp=1310471032778000)
     (column=3239, value=30323939303030303032, timestamp=1310471032780000)
     (column=33, value=303339303030303032, timestamp=1310471032740000)

How can I Use this facility sstable2json ?
Thank you for keeping your patience.. ;)

On 21 July 2011 17:33, aaron morton <aaron@thelastpickle.com> wrote:

> mmm, there is no -f option for sstable2json /  SSTableExport. Datastax
> guys/girls ??
>
> this works for me
>
> bin/sstable2json /var/lib/cassandra/data/dev/data-g-1-Data.db -k 666f6f >
> output.txt
>
> NOTE: key is binary, so thats the ascii encoding for foo
>
> Cheers
>
> -----------------
> Aaron Morton
> Freelance Cassandra Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 21 Jul 2011, at 23:19, Nilabja Banerjee wrote:
>
> This is the full path of  SSTables:
> /Users/nilabja/Development/Cassandra/apache-cassandra-0.7.5/data/*cctest*
> /BTP-f-1-Data.db
> *cctest=  *keyspace
> *BTP*= Columnfamily name
> json file= /Users/nilabja/Development/Cassandra/testjson.txt
>
> commands are:
>
> bin/sstable2json -f output.txt /Users/nilabja/Development/Cassandra/apache-cassandra-0.7.5/data/*cctest1*/BTP-f-1-Data.db
-k keyname
>
> bin/json2sstable -k cctest -c BTP /Users/nilabja/Desktop/testjson.txt /Users/nilabja/Development/Cassandra/apache-cassandra-0.7.5/data/json2sstable/Fetch_CCDetails-f-1-Data.db
>
> Thank You
>
>
> On 21 July 2011 16:07, aaron morton <aaron@thelastpickle.com> wrote:
>
>> What is the command line you are executing ?
>>
>> That error is only returned by sstable2json when an sstable path is not
>> passed on the command line.
>>
>> Cheers
>>
>>  -----------------
>> Aaron Morton
>> Freelance Cassandra Developer
>> @aaronmorton
>> http://www.thelastpickle.com
>>
>> On 21 Jul 2011, at 18:50, Nilabja Banerjee wrote:
>>
>> Thank you...
>> but  I have already gone through that.. but still not working... I am
>> getting .. "*You must supply exactly one sstable
>> * Can you tell me why I am getting this?
>>
>>
>> On 21 July 2011 02:41, Tyler Hobbs <tyler@datastax.com> wrote:
>>
>>> The sstable2json/json2sstable format is detailed here:
>>> http://www.datastax.com/docs/0.7/utilities/sstable2json
>>>
>>> On Wed, Jul 20, 2011 at 4:58 AM, Nilabja Banerjee
>>> <nilabja.banerjee@gmail.com> wrote:
>>> >
>>> >
>>> >
>>> >
>>> > On 20 July 2011 11:33, Nilabja Banerjee <nilabja.banerjee@gmail.com>
>>> wrote:
>>> >>
>>> >> Hi All,
>>> >>
>>> >> Here Is my Json structure.
>>> >>
>>> >>
>>> >> {"Fetch_CC" :{
>>> >>                 "cc":{ "xxxx":"1000",
>>> >>                          "yyyy:"ICICI",
>>> >>                          "zzzz":"xxxxxxxx",
>>> >>                          "city":{
>>> >>                                  "name":"banglore"
>>> >>                                    };
>>> >>                        };
>>> >> }
>>> >>
>>> >> If the structure is incorrect, please give me one small structre to
>>> use
>>> >> below utility.
>>> >> I am using 0.7.5 version.
>>> >> Now how can I can use Json2SStable utilities? Please provide me the
>>> steps.
>>> >> What are the things I have configure?
>>> >>
>>> >> Thank You
>>> >
>>> >
>>>
>>>
>>>
>>> --
>>> Tyler Hobbs
>>> Software Engineer, DataStax
>>> Maintainer of the pycassa Cassandra Python client library
>>>
>>
>>
>>
>
>

Mime
View raw message