You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Aliou SOW <al...@hotmail.com> on 2012/04/10 16:14:30 UTC

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

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: json2sstable error: Can not write to the Standard columns Super Column Family

Posted by aaron morton <aa...@thelastpickle.com>.
Your json is for a standard CF but you are trying to load it into a super CF. 

There is a dedicated bulk loader interface you may find useful http://www.datastax.com/dev/blog/bulk-loading

Cheers

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

On 11/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 org.apache.cassandra.tools.SSTableImport.importSorted (SSTableImport.java: 368)
>          Has org.apache.cassandra.tools.SSTableImport.importJson (SSTableImport.java: 255)
>          Has org.apache.cassandra.tools.SSTableImport.main (SSTableImport.java: 479)
> ERROR: Can not write to the Standard columns Super Column Family.
> 
> Before that, i first created a keyspace "testkeyspace", then a column family "testCF" wherein I defined the key as varchar. Here is the structure of my json file:
>  
> {
> "rs12354060": {
> "X1714T": 1.0,
> "X1905T": 1.0,
> ...
> "X3155T": 1.0
> }
> "rs3115850": {
> "X1714T": 0938,
> "X1905T": 0879,
> ...
> "X3155T": 0822
> }
> }
>  
> Help please, and if there is a other and easier way for bulk inserts, let me know please.
>  
> Kind regards, Aliou.


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

Posted by Aliou SOW <al...@hotmail.com>.


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
(SSTableImport.java: 368)

         Has
org.apache.cassandra.tools.SSTableImport.importJson (SSTableImport.java: 255)

         Has
org.apache.cassandra.tools.SSTableImport.main (SSTableImport.java: 479)

ERROR: Can not write to the Standard columns Super Column Family. 

Before that, i first created a keyspace
"testkeyspace", then a column family "testCF" wherein I
defined the key as varchar. Here is the structure of my json file:

 

{

"rs12354060": {

"X1714T": 1.0,

"X1905T": 1.0,

...

"X3155T":
1.0

}

"rs3115850": {

"X1714T": 0938,

"X1905T": 0879,

...

"X3155T":
0822

}

}

 

Help please, and if there is a other and easier
way for bulk inserts, let me know please.

 

Kind
regards, Aliou.