incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ron <web...@gmail.com>
Subject Deletion and batch_mutate
Date Tue, 22 Jun 2010 08:00:45 GMT
Hi everyone,
I'm a new user of Cassandra, and during my tests, I've encountered a problem
with deleting rows from CFs.
I use Cassandra 0.6.2 and coding in Java, using the native Java Thrift API.

The way my application works, I need to delete multiple rows at a time (just
like reads and writes).
Obviously, in terms of performance, I'd rather use batch_mutate and delete
several rows and not issue a remove command on each and every row.
So far, all attempts doing so have failed.
The following command configurations have been tested:

   1. Deletion, without a Supercolumn or SlicePredicate set. I get this
   error: InvalidRequestException(why:A Deletion must have a SuperColumn, a
   SlicePredicate or both.)
   2. Deletion, with a SlicePredicate set. The SlicePredicate is without
   column names or SliceRange set. I get this error:
   InvalidRequestException(why:A SlicePredicate must be given a list of
   Columns, a SliceRange, or both)
   3. Deletion, with a SlicePredicate set. The SlicePredicate is set with
   SliceRange. The SliceRange is set with empty start and finish values. I get
   this error: InvalidRequestException(why:Deletion does not yet support
   SliceRange predicates.)

At this point I'm left with no other alternatives (since I want to delete a
whole row and not specific columns/supercolumns within a row).
Using the remove command in a loop has serious implications in terms of
performance.
Is there any solution for this problems?
Thanks,
Ron

Mime
View raw message