Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of sylvain@datastax.com
 designates 209.85.220.172 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <A663AF0EC22BAB47966CA61D63C01B385606D240@mcm-exch-mb.MoonCapital.Corp>
References: 
 <CAAD3TZq54SiTLE1KRkNTPTBzVZhEKuQLO99uYeaNwX_HkHvHbw@mail.gmail.com>
	<A4B547E3-0557-4319-92F8-6DFFBC8E133D@thelastpickle.com>
	<CAAD3TZpShK-bkSJXb8N-UN5uzmAVV3nPW3ETSOAT6MtORJkNTg@mail.gmail.com>
	<F59E86E5-7226-48E4-866C-51B7456CB123@thelastpickle.com>
	<CAAD3TZp5E-houoJ_n=4r-u3+5xtjq+HmrZq32-YGF_fzUt57Sw@mail.gmail.com>
	<B060E059-84E2-4531-ADC8-3758CA36D814@thelastpickle.com>
	<CAAD3TZp5KOx5tzJELwF9CZjfYKWJgNnJhcwKV9nqYbpa8Gm1LA@mail.gmail.com>
	<399CB8C7-AEE6-4468-91E0-BF06D6118BD8@thelastpickle.com>
	<CAAam9ssYCsUxsnvqfSRCuoa=yHckJX0MuYLtjXKV3KGkPuXaCw@mail.gmail.com>
	<CAAD3TZrCAF1Rp=cO7wz3gDesE7dOkGChe_m7uidm1taR5J=SNA@mail.gmail.com>
	<CAAam9suOHRFS2bhq+PLChGKD0Svru4BfT81CADrDhj0_ArdTtg@mail.gmail.com>
	<A663AF0EC22BAB47966CA61D63C01B385606D23F@mcm-exch-mb.MoonCapital.Corp>
	<CAOBz8JYa=8dvfYhY3fVmT5W7WTMxfAqg98kFQp1iyq95s=Q4ZA@mail.gmail.com>
	<A663AF0EC22BAB47966CA61D63C01B385606D240@mcm-exch-mb.MoonCapital.Corp>
Date: Wed, 11 Jul 2012 15:31:41 +0200
Message-ID: 
 <CAKkz8Q3C=7WgRzabf5HLkSVPL13o8aRJZAOXvrnXCv-oQxZLbA@mail.gmail.com>
Subject: Re: help using org.apache.cassandra.cql3
From: Sylvain Lebresne <sylvain@datastax.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

When I said to use the BATCH statement I mean't using a query that is
a BATCH statement, so something like:
  BEGIN BATCH
    INSERT ...;
    INSERT ...;
    ...
  APPLY BATCH;

If you want to that from java, you will want to look at the jdbc
driver (http://code.google.com/a/apache-extras.org/p/cassandra-jdbc/),
though I don't know what is the status of the support for CQL3.

On Wed, Jul 11, 2012 at 2:18 PM, Leonid Ilyevsky
<lilyevsky@mooncapital.com> wrote:
> Is it OK to put 10000 of update statements in one
> batch, with 50000 question marks in it? The set that many variables?

Yes batch statement can be prepared and in theory there isn't much
limit on the number of update statement (nor question marks) you can
put in one batch. However, the way C* work best is if you do
reasonably sized batches. It's even more true for CQL in the sense
that by using a huge batch statement you'll pay the parsing. So you
probably want to prepare one batch statement with a reasonable number
of statement in it (you'll have to test to find number that give the
best performances, but I would typically start with say 50-100 and see
if the performance are good enough) and reuse that to insert the data.

The other reason why breaking the insert into smallish batches is a
good idea is that it allows you to parallelize the insert using
multiple threads. And you need to parallelize if you want to get the
best out of C*.

--
Sylvain

>
> Maybe I can try small example first, just to see if it works at all.
>
>
>
>
>
> From: Derek Williams [mailto:derek@fyrie.net]
> Sent: Tuesday, July 10, 2012 7:19 PM
> To: user@cassandra.apache.org
> Subject: Re: help using org.apache.cassandra.cql3
>
>
>
> On Tue, Jul 10, 2012 at 3:04 PM, Leonid Ilyevsky <lilyevsky@mooncapital.c=
om>
> wrote:
>
> I am trying to use the org.apache.cassandra.cql3 package. Having problem
> connecting to the server using ClientState.
>
> I was not sure what to put in the credentials map (I did not set any
> users/passwords on my server), so I tried setting empty strings for
> =93username=94 and =93password=94, setting them to bogus values, passing =
null to the
> login method =96 there was no difference.
>
> It does not complain at the login(), but then it complains about
> setKeyspace(<my keyspace>), saying that the specified keyspace does not
> exist (it obviously does exist).
>
> The configuration was loaded from cassandra.yaml used by the server.
>
>
>
> I did not have any problem like this when I used
> org.apache.cassandra.thrift.Cassandra.Client .
>
>
>
> What am I doing wrong?
>
>
>
> I think that package just contains server classes. Everything you need
> should be in org.apache.cassandra.thrift.
>
>
>
> To use cql3 I just use the client methods 'execute_cql_query',
> 'prepare_cql_query' and 'execute_prepared_cql_query', after setting cql
> version to '3.0.0'.
>
>
>
>
>
> --
>
> Derek Williams
>
>
>
>
> ________________________________
> This email, along with any attachments, is confidential and may be legall=
y
> privileged or otherwise protected from disclosure. Any unauthorized
> dissemination, copying or use of the contents of this email is strictly
> prohibited and may be in violation of law. If you are not the intended
> recipient, any disclosure, copying, forwarding or distribution of this em=
ail
> is strictly prohibited and this email and any attachments should be delet=
ed
> immediately. This email and any attachments do not constitute an offer to
> sell or a solicitation of an offer to purchase any interest in any
> investment vehicle sponsored by Moon Capital Management LP (=93Moon Capit=
al=94).
> Moon Capital does not provide legal, accounting or tax advice. Any statem=
ent
> regarding legal, accounting or tax matters was not intended or written to=
 be
> relied upon by any person as advice. Moon Capital does not waive
> confidentiality or privilege as a result of this email.