incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Need help json2sstable
Date Thu, 21 Jul 2011 22:08:40 GMT
In my DB the keys added by the client were ascii strings like "foo", but these are stored as
binary arrays in cassandra. So I cannot use the string "foo" with 22table2json I have to use
the ascii encoding 666f6f .

This will *probably* be what you see in the output from cassandra-cli list (unless you have
either set a key_validation_class for the CF or used the assume statement). 

If one way does not work try the other. 

Cheers

-----------------
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com

On 22 Jul 2011, at 01:15, Nilabja Banerjee wrote:

> 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