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 <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 >>> >> >> > >
