Return-Path: 
 <cassandra-user-return-2710-apmail-incubator-cassandra-user-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org
Received: (qmail 24693 invoked from network); 24 Feb 2010 17:44:10 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 24 Feb 2010 17:44:10 -0000
Received: (qmail 7228 invoked by uid 500); 24 Feb 2010 17:44:10 -0000
Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org
Received: (qmail 7212 invoked by uid 500); 24 Feb 2010 17:44:10 -0000
Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:cassandra-user-help@incubator.apache.org>
List-Unsubscribe: <mailto:cassandra-user-unsubscribe@incubator.apache.org>
List-Post: <mailto:cassandra-user@incubator.apache.org>
List-Id: <cassandra-user.incubator.apache.org>
Reply-To: cassandra-user@incubator.apache.org
Delivered-To: mailing list cassandra-user@incubator.apache.org
Received: (qmail 7203 invoked by uid 99); 24 Feb 2010 17:44:10 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Feb 2010 17:44:10 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [213.174.48.142] (HELO c3po.preisroboter.de) (213.174.48.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Feb 2010 17:44:00 +0000
Received: from localhost (localhost [127.0.0.1])
	by c3po.preisroboter.de (Postfix) with ESMTP id 86DBB46C5B
	for <cassandra-user@incubator.apache.org>;
 Wed, 24 Feb 2010 18:43:40 +0100 (CET)
X-Virus-Scanned: Debian amavisd-new at c3po.preisroboter.de
Received: from c3po.preisroboter.de ([127.0.0.1])
	by localhost (c3po.preisroboter.de [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id rR1Nx6f59Z0V for <cassandra-user@incubator.apache.org>;
	Wed, 24 Feb 2010 18:43:35 +0100 (CET)
Received: from [192.168.0.15] (x062.ims-firmen.de [213.174.48.137])
	(using TLSv1 with cipher AES128-SHA (128/128 bits))
	(No client certificate requested)
	by c3po.preisroboter.de (Postfix) with ESMTPSA id 70E8746C56
	for <cassandra-user@incubator.apache.org>;
 Wed, 24 Feb 2010 18:43:35 +0100 (CET)
From: Martin Probst <server@preisroboter.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Subject: import data into cassandra
Date: Wed, 24 Feb 2010 18:43:33 +0100
Message-Id: <08C202D4-3F7C-4271-A6A4-D689E485D705@preisroboter.de>
To: cassandra-user@incubator.apache.org
Mime-Version: 1.0 (Apple Message framework v1077)
X-Mailer: Apple Mail (2.1077)
X-Virus-Checked: Checked by ClamAV on apache.org

Hi,

i'm playing around a little bit with cassandra and trying to load some =
data into it. I've found the sstable2json and json2sstable scripts =
inside the /bin dir and tried to work with this scripts. I've wrote a =
wrapper which transform csv's into a json file and the json-validator =
throws no failures. But every time i tried to import the json, a =
exception is thrown:

host:/opt/cassandra# bin/json2sstable -K Keyspace1 -c col1 =
../utf8_cassandra.json data/Keyspace1/col1-2-Data.db=20
Exception in thread "main" java.lang.NumberFormatException: For input =
string: "PR"
        at =
java.lang.NumberFormatException.forInputString(NumberFormatException.java:=
48)
        at java.lang.Integer.parseInt(Integer.java:447)
        at =
org.apache.cassandra.utils.FBUtilities.hexToBytes(FBUtilities.java:255)
        at =
org.apache.cassandra.tools.SSTableImport.addToStandardCF(SSTableImport.jav=
a:89)
        at =
org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:156=
)
        at =
org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:207)=20

The Keyspace is configured as follows:
   <Keyspace Name=3D"Keyspace1">
      <ColumnFamily CompareWith=3D"UTF8Type" Name=3D"col1" Comment=3D"some=
 data"/>
    </Keyspace>

Is there another way to import some data, maybe a tool or something? =
I've used the latest stable cassandra version (0.5.0).

Thanks
Martin=