Re: Need help json2sstable

2011-07-21 Thread aaron morton
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 (unles

Re: Need help json2sstable

2011-07-21 Thread Nilabja Banerjee
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: 0902 => (super_column=0902, (column=30, value=303039303030303032, timestamp=1310471032735

Re: Need help json2sstable

2011-07-21 Thread aaron morton
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 Freelanc

Re: Need help json2sstable

2011-07-21 Thread Nilabja Banerjee
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/Deve

Re: Need help json2sstable

2011-07-21 Thread aaron morton
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 Ba

Re: Need help json2sstable

2011-07-20 Thread Nilabja Banerjee
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 wrote: > The sstable2json/json2sstable format is detailed here: > http://www.datastax.c

Re: Need help json2sstable

2011-07-20 Thread Tyler Hobbs
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 wrote: > > > > > On 20 July 2011 11:33, Nilabja Banerjee wrote: >> >> Hi All, >> >> Here Is my Json structure. >> >> >> {"Fetch_CC" :{

Re: Need help json2sstable

2011-07-20 Thread Nilabja Banerjee
On 20 July 2011 11:33, Nilabja Banerjee wrote: > Hi All, > > Here Is my Json structure. > > > {"Fetch_CC" :{ > "cc":{ "":"1000", > ":"ICICI", > "":"", > "city":{ >

Re: Need help json2sstable

2011-07-20 Thread Nilabja Banerjee
Yes.Actually, I was just asking you guys to give me one example with one sample of small json structure. Thank you in advance :) On 20 July 2011 11:53, Sasha Dolgy wrote: > You are missing " after > > On Wed, Jul 20, 2011 at 8:03 AM, Nilabja Banerjee > wrote: > > Hi All, > > > >

Re: Need help json2sstable

2011-07-19 Thread Sasha Dolgy
You are missing " after On Wed, Jul 20, 2011 at 8:03 AM, Nilabja Banerjee wrote: > Hi All, > > Here Is my Json structure. > > > {"Fetch_CC" :{ >                 "cc":{ "":"1000", >                     ":"ICICI", >                          "":"", >               

Need help json2sstable

2011-07-19 Thread Nilabja Banerjee
Hi All, Here Is my Json structure. {"Fetch_CC" :{ "cc":{ "":"1000", ":"ICICI", "":"", "city":{ "name":"banglore" };