Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates
 74.125.82.44 as permitted sender)
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=kP8XQgEDGZZIiWFt2U0t/aVpkhQI9tTH2JAlvZbEl7o5N5amEWGPSJOhEQpzadTKH0
         0uEeY3/+rJdl37UXWhZw4KWpXxfOvz6gdOsVzTE8WdHF2s2THX4BW3lsgDop4zIk439c
         Uklly5T1LPJTetNE3OW49OIHXgaKDbCZLNNic=
MIME-Version: 1.0
In-Reply-To: <007e01caed1a$e3969670$aac3c350$@com>
References: <007e01caed1a$e3969670$aac3c350$@com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Thu, 6 May 2010 09:25:22 -0500
Message-ID: <w2ye06563881005060725sa5039eccgd7c643f2eee5fb48@mail.gmail.com>
Subject: Re: How to initialize the Cassandra
To: user@cassandra.apache.org
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

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 <sunht@dopsun.com> wrote:
> Hi,
>
>
>
> I just discovered that the json file exported by sstable2json contains mo=
re
> 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 curre=
ntly not there.
> We can import data exported from existing installation, but not from noth=
ing
>
> 3)=A0=A0=A0=A0=A0 Running the application
>
>
>
> Thanks,
>
> Regards,
>
> Dop


--=20
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com