Re: json2sstable error: Can not write to the Standard columns Super Column Family

2012-04-11 Thread aaron morton
/04/2012, at 2:22 AM, Aliou SOW wrote: > Dear All, > > I am new to Cassandra 1.0.8, and I use the tool json2sstable for bulk insert, > but I still have the error: > > java.lang.RuntimeException: Can not write to the Standard columns Super > Column F

json2sstable error: Can not write to the Standard columns Super Column Family

2012-04-10 Thread Aliou SOW
Dear All, I am new to Cassandra 1.0.8, and I use the tool json2sstable for bulk insert, but I still have the error: java.lang.RuntimeException: Can not write to the Standard columns Super Column Family. Has org.apache.cassandra.tools.SSTableImport.importSorted

json2sstable error: Can not write to the Standard columns Super Column Family

2012-04-10 Thread Aliou SOW
Dear All, I am new to Cassandra 1.0.8, and I use the tool json2sstable for bulk insert, but I still have the error:

Re: strange json2sstable cast exception

2011-08-06 Thread Dan Kuebrich
Forgot to mention node is: new install of 0.8.2, though data was streamed over from nodes that have been upgraded over time from 0.7. On Aug 6, 2011 10:47 AM, "Jonathan Ellis" wrote: > You should probably upgrade, it looks like you have a version that > doesn't support sstable2json with expiring c

Re: strange json2sstable cast exception

2011-08-06 Thread Jonathan Ellis
You should probably upgrade, it looks like you have a version that doesn't support sstable2json with expiring columns. On Sat, Aug 6, 2011 at 9:29 AM, Dan Kuebrich wrote: > Having run into a recurring compaction problem due to a corrupt sstable > (perceived row size was 13 petabytes or something)

strange json2sstable cast exception

2011-08-06 Thread Dan Kuebrich
Having run into a recurring compaction problem due to a corrupt sstable (perceived row size was 13 petabytes or something), I sstable2json -x 'd the key and am now trying to re-import the sstable without it. However, I'm running into the following exception: Importing 2882 keys... java.lang.Clas

Re: Need help json2sstable

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

Re: Need help json2sstable

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

Re: Need help json2sstable

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

Re: Need help json2sstable

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

Re: Need help json2sstable

2011-07-21 Thread aaron morton
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 wrote: > The sstable2json/js

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

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

Re: Need help json2sstable

2011-07-20 Thread Nilabja Banerjee
> "":"", > "city":{ > "name":"banglore" >}; >}; > } > > If the structure is incorrect, please g

Re: Need help json2sstable

2011-07-20 Thread Nilabja Banerjee
"":"", > > "city":{ > > "name":"banglore" > >}; > >}; > > } > > > > If the structu

Re: Need help json2sstable

2011-07-19 Thread Sasha Dolgy
> } > > 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 > -- Sasha Dolgy sasha.do...@gmail.com

Need help json2sstable

2011-07-19 Thread Nilabja Banerjee
"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

json2sstable & sstable2json

2011-07-19 Thread Nilabja Banerjee
Hi All, Can you please explain me how can I use json2sstable and sstable2json features in cassandra. It will be useful to me if anyone of you explain me with a small example. 1. one small json text file. 2. what will be the keyspace and columnfamily name. 3. Syntax in details. What .db name I

Re: json2sstable

2011-04-13 Thread aaron morton
Reading the code looks like it could not find a subColumns item for the row >>> in the json file. >>> >>> The target CF is a super CF, is the data from a super CF ? >>> >>> Aaron >>> >>> On 13 Apr 2011, at 07:24, Steven Teo wrote: &

Re: json2sstable

2011-04-13 Thread Steven Teo
a from a super CF ? >> >> Aaron >> >> On 13 Apr 2011, at 07:24, Steven Teo wrote: >> >>> Hi, >>> >>> I am trying to run json2sstable with the following command but am receiving >>> the below error. >>>

Re: json2sstable

2011-04-12 Thread Steven Teo
rget CF is a super CF, is the data from a super CF ? > > Aaron > > On 13 Apr 2011, at 07:24, Steven Teo wrote: > >> Hi, >> >> I am trying to run json2sstable with the following command but am receiving >> the below error. >> json2sstable -K

Re: json2sstable

2011-04-12 Thread aaron morton
Reading the code looks like it could not find a subColumns item for the row in the json file. The target CF is a super CF, is the data from a super CF ? Aaron On 13 Apr 2011, at 07:24, Steven Teo wrote: > Hi, > > I am trying to run json2sstable with the following command but am

json2sstable

2011-04-12 Thread Steven Teo
Hi, I am trying to run json2sstable with the following command but am receiving the below error. json2sstable -K testks -c testcf output.json /var/lib/cassandra/data/testks/testcf-f-1-Data.db Importing 321 keys... java.lang.NullPointerException at

Re: secondary indexes on data imported by json2sstable

2011-03-14 Thread Jonathan Ellis
ing data using json2sstable? > Or is there some manual procedure that needs to be done to generate them? > Regards, > Terje -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com

Re: secondary indexes on data imported by json2sstable

2011-03-14 Thread Norman Maurer
I would expect they get created on the fly while importing. If not I think its a bug... Bye, Norman 2011/3/14 Terje Marthinussen > Hi, > > Should it be expected that secondary indexes are automatically regenerated > when importing data using json2sstable? > Or is there some m

secondary indexes on data imported by json2sstable

2011-03-14 Thread Terje Marthinussen
Hi, Should it be expected that secondary indexes are automatically regenerated when importing data using json2sstable? Or is there some manual procedure that needs to be done to generate them? Regards, Terje

Re: json2sstable hanging on large sstable2json-generated JSON file

2011-03-13 Thread Jason Harvey
idering I saw zero reads on my disk when I ran it, I don't think > it is even reading the JSON file. > > I shrunk the file down to a handful of keys, and it worked fine. Is > there an issue with json2sstable loading large JSON files? Does it try > to read it into memory? > >

json2sstable hanging on large sstable2json-generated JSON file

2011-03-12 Thread Jason Harvey
: reddit:false:2502@1298067089267 Considering I saw zero reads on my disk when I ran it, I don't think it is even reading the JSON file. I shrunk the file down to a handful of keys, and it worked fine. Is there an issue with json2sstable loading large JSON files? Does it try to read it into m

Example usage of json2sstable?

2011-03-12 Thread Jason Harvey
json2sstable to write to, but I'm not sure what naming convention I need to use on the destination table. My current sstables look like the following: permacache-f-13-Data.db. Should I just pick a random number for the new sstable when running json2sstable? Thanks, Jason

Re: json2sstable NPE

2011-01-18 Thread Aaron Morton
AFAIK the CF must exist. Create it and try again.AOn 19 Jan, 2011,at 12:03 PM, ruslan usifov wrote:Thats odd, the line before line 68 has an assertion that should have kicked in. Are you on the release version of 0.7.0 ?  Yes i use release downloaded from official site  Does the "test" CF exist in

Re: json2sstable NPE

2011-01-18 Thread ruslan usifov
Thats odd, the line before line 68 has an assertion that should have kicked > in. Are you on the release version of 0.7.0 ? > > Yes i use release downloaded from official site > Does the "test" CF exist in the keyspace "test" in your cluster ? > > > no it doesn't exists

Re: json2sstable NPE

2011-01-18 Thread Aaron Morton
Thats odd, the line before line 68 has an assertion that should have kicked in. Are you on the release version of 0.7.0 ? Does the "test" CF exist in the keyspace "test" in your cluster ? AaronOn 19 Jan, 2011,at 11:37 AM, ruslan usifov wrote:HelloI have problem when use json2s

json2sstable NPE

2011-01-18 Thread ruslan usifov
Hello I have problem when use json2sstable (in cassandra 0.7). When i invoke: json2sstable -K test -c test D:\apache-cassandra-0.7.0\bin\test-e-1-Data.json F:\cassandra\test\test\test-e-1-Data.db I got NPE: WARN 01:31:38,750 Schema definitions were defined both locally and in cassandra.yaml

Re: json2sstable

2010-04-15 Thread Brandon Williams
On Thu, Apr 15, 2010 at 3:47 PM, Lee Parker wrote: > Has anyone used json2sstable to migrate a large amount of data into > cassandra? What was your methodology? I assume that this will be much > faster than stepping through my data and doing writes via PHP/Thrift. If you're l

Re: json2sstable

2010-04-15 Thread 孔令华
I tried that and found that it cannot handle large file at present. But you can write a tool according to it. eg: first sorting your data file according to it's hash key; second, write to a SSTable directly On Fri, Apr 16, 2010 at 4:47 AM, Lee Parker wrote: > Has anyone used json2ss

json2sstable

2010-04-15 Thread Lee Parker
Has anyone used json2sstable to migrate a large amount of data into cassandra? What was your methodology? I assume that this will be much faster than stepping through my data and doing writes via PHP/Thrift. Lee Parker