cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leonid Ilyevsky <>
Subject RE: help using org.apache.cassandra.cql3
Date Wed, 11 Jul 2012 12:18:34 GMT
I see.
The reason I looked at that package was, I need to use the batch feature, and I could not
make it work using thrift with the CF having composite key. It worked fine with the simple
key, but not composite, I was getting an error while trying to do the update.
Sylvain suggested (in reply to my other posting) that I use cql3 batch statement, but I am
not sure how to do it efficiently from Java. Can batch statement be prepared? Is it OK to
put 10000 of update statements in one batch, with 50000 question marks in it? The set that
many variables?
Maybe I can try small example first, just to see if it works at all.

From: Derek Williams []
Sent: Tuesday, July 10, 2012 7:19 PM
Subject: Re: help using org.apache.cassandra.cql3

On Tue, Jul 10, 2012 at 3:04 PM, Leonid Ilyevsky <<>>
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 “username” and “password”, setting them
to bogus values, passing null to the login method – 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 legally 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 email is strictly prohibited
and this email and any attachments should be deleted 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 (“Moon Capital”). Moon
Capital does not provide legal, accounting or tax advice. Any statement 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.
View raw message