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 <aa...@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 <aa...@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 <ty...@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.baner...@gmail.com> wrote:
>>> >
>>> >
>>> >
>>> >
>>> > On 20 July 2011 11:33, Nilabja Banerjee <nilabja.baner...@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
>>>
>>
>>
>>
>
>
