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 Family. Has

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:

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

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

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 dan.kuebr...@gmail.com wrote: Having run into a recurring compaction problem due to a corrupt sstable (perceived row size was 13

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 jbel...@gmail.com wrote: You should probably upgrade, it looks like you have a version that doesn't support sstable2json

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

Re: Need help json2sstable

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

Re: Need help json2sstable

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

Re: Need help json2sstable

2011-07-20 Thread Sasha Dolgy
,                          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

Re: Need help json2sstable

2011-07-20 Thread Nilabja Banerjee
}; }; } 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

Re: Need help json2sstable

2011-07-20 Thread Nilabja Banerjee
:{ 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

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 Steven Teo
, Steven Teo wrote: 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

Re: json2sstable

2011-04-13 Thread aaron morton
? 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 testks -c testcf output.json /var/lib/cassandra/data/testks/testcf-f-1-Data.db Importing 321 keys

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

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 receiving

Re: json2sstable

2011-04-12 Thread Steven Teo
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 testks -c testcf output.json /var/lib/cassandra/data/testks/testcf-f-1

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: 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 tmarthinus...@gmail.com Hi, Should it be expected that secondary indexes are automatically regenerated when importing data using json2sstable? Or is there some

Re: secondary indexes on data imported by json2sstable

2011-03-14 Thread Jonathan Ellis
importing 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: json2sstable hanging on large sstable2json-generated JSON file

2011-03-13 Thread Jason Harvey
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? Also as a note, this data is unsorted. I did

Example usage of json2sstable?

2011-03-12 Thread Jason Harvey
for 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

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 memory

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 NPE

2011-01-18 Thread Aaron Morton
ave 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.dbI got NPE: WARN 01:31:38,750 Schema definitions were defined both locally and in cassandra.yaml. Definitions

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
AFAIK the CF must exist. Create it and try again.AOn 19 Jan, 2011,at 12:03 PM, ruslan usifov ruslan.usi...@gmail.com 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

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

Re: json2sstable

2010-04-15 Thread 孔令华
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

Re: json2sstable

2010-04-15 Thread Brandon Williams
On Thu, Apr 15, 2010 at 3:47 PM, Lee Parker l...@socialagency.com 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