CODEWITHSUNDEEP
databasecassandracqlelassandra
CaptainLevii
CaptainLevii

Reputation: 71

Delete records from cassandra

I have written wrong update command.

update table_name set col_val = 'x' where PRI_KEY_1 IN ( 50 values ) and PRI_KEY_2 IN ( 50 values ) and CLUSTER_KEY IN ( 10 Values );

This has created 40000 records where there was only 150. I can see only columns mentioned in query- PRI_KEY_1 ,PRI_KEY_2 and CLUSTER_KEY are updated in those extra 39850.

Now I need help in deleting all those 39850 records. Please Help.

Upvotes: 1

Views: 193

Answers (1)

Erick Ramirez
Erick Ramirez

Reputation: 16443

Unfortunately, there isn't a quick fix for it.

You will need to iterate over those records and issue a DELETE.

Upvotes: 2

Related Questions