Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 57602 invoked from network); 6 May 2010 14:50:40 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 6 May 2010 14:50:40 -0000 Received: (qmail 45165 invoked by uid 500); 6 May 2010 14:50:39 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 45144 invoked by uid 500); 6 May 2010 14:50:39 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 45135 invoked by uid 99); 6 May 2010 14:50:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 May 2010 14:50:39 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates 74.125.82.172 as permitted sender) Received: from [74.125.82.172] (HELO mail-wy0-f172.google.com) (74.125.82.172) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 May 2010 14:50:33 +0000 Received: by wyb32 with SMTP id 32so29027wyb.31 for ; Thu, 06 May 2010 07:50:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:in-reply-to :references:from:date:message-id:subject:to:content-type :content-transfer-encoding; bh=TtuXiaMbLz4v/uNveHLmf3Q8ja8cAzTPczrN8lVEVfc=; b=QKdplzgJaqyxkUbWVQlppxhcY9az3swgAHqKQxFTd7qE1jNO/BCXftKltYKpe/IWq4 4WQUrvTlIDAsHabAbahbjKzDz8yEBAss5udGpBaNtkOFvUa6Ehavtz3JjQyWJl+BfZjn 9PXcLoBr63Uqn7O3WP+cOp13Kirg26YfKhgJ8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; b=L/4cYjiT6FoNQmE+qWy2DiYVe5Mr1G0LQMMbKV7ylRWQUmRenI1G/GllgYBmwBPSz3 JPZSEvh1uP79JfpGNYglC2MppBZbXyyoo7Ydq/HAsEPc5kwJ7HfQogyHTiSfN9xOiB3d 720wH2QuNd/NXx0xZZeV4aLQfDVNX7to2ih3s= Received: by 10.216.89.203 with SMTP id c53mr5128992wef.79.1273157413200; Thu, 06 May 2010 07:50:13 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.22.10 with HTTP; Thu, 6 May 2010 07:49:53 -0700 (PDT) In-Reply-To: <009201caed29$f147b150$d3d713f0$@com> References: <007e01caed1a$e3969670$aac3c350$@com> <009201caed29$f147b150$d3d713f0$@com> From: Jonathan Ellis Date: Thu, 6 May 2010 09:49:53 -0500 Message-ID: Subject: Re: How to initialize the Cassandra To: user@cassandra.apache.org Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org what you see in bin/ is pretty much what you get. On Thu, May 6, 2010 at 9:39 AM, Dop Sun wrote: > Is this feedback for my request on initializing data for Cassandra? :-) > > Basically, my question is whether there is a tool, like json2sstable, whi= ch > can import some data in a format which can be easily manual created. I do= n't > know the experience of other people, but what I'm currently doing is writ= ing > a small application to write the data in. > > Dop > > -----Original Message----- > From: Jonathan Ellis [mailto:jbellis@gmail.com] > Sent: Thursday, May 06, 2010 10:25 PM > To: user@cassandra.apache.org > Subject: Re: How to initialize the Cassandra > > The simplest way is to just use thrift batch_mutate. > > If Cassandra CPU is your bottleneck then using the binary load method > from StorageProxy can help (see contrib/bmt_example). > > If Casssandra disk or network is your bottleneck then binary load > won't really help. > > On Thu, May 6, 2010 at 7:51 AM, Dop Sun wrote: >> Hi, >> >> >> >> I just discovered that the json file exported by sstable2json contains > more >> than the data itself, like deletedAt values. >> >> >> >> I=92m thinking whether there is a tool can import some initial data? >> >> >> >> When we are doing the typical RDBMS system, this is how we are doing: >> >> 1)=A0=A0=A0=A0=A0 Define the schema >> >> 2)=A0=A0=A0=A0=A0 Initialize the database with initial data using Insert= statements >> >> 3)=A0=A0=A0=A0=A0 Running the application >> >> >> >> If following these steps in Cassandra: >> >> 1)=A0=A0=A0=A0=A0 Define the schema: this is done by define the KeySpace >> >> 2)=A0=A0=A0=A0=A0 Initialize the data with initial data: =A0This is curr= ently not > there. >> We can import data exported from existing installation, but not from > nothing >> >> 3)=A0=A0=A0=A0=A0 Running the application >> >> >> >> Thanks, >> >> Regards, >> >> Dop > > > > -- > Jonathan Ellis > Project Chair, Apache Cassandra > co-founder of Riptano, the source for professional Cassandra support > http://riptano.com > > > --=20 Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Cassandra support http://riptano.com