cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergio Bilello <lapostadiser...@gmail.com>
Subject IN OPERATOR VS BATCH QUERY
Date Fri, 21 Feb 2020 00:25:46 GMT
Hi guys!

Let's say we have a KEY-VALUE schema

The goal is to delete the KEYS in batches without burning the cluster and be efficient as
soon as possible

I would like to know if it is better to run the query with DELETE FROM KEY_VALUE_COLUMN_FAMILY
WHERE KEY IN ('A','B','C'); At most 10 KEYS in the IN STATEMENT 

OR

HANDLE WITH A CASSANDRA BATCH QUERY and in particular, I was looking at https://docs.spring.io/spring-data/cassandra/docs/current/api/org/springframework/data/cassandra/core/ReactiveCassandraBatchOperations.html#delete-java.lang.Iterable-

Thanks,

Sergio




---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org


Mime
View raw message