Learning Apache Cassandra - Second Edition

Unfollowing users

It's conceivable that bob may end up posting too many funny cat pictures for alice's taste, in which case, she may decide to unfollow him. For alice to do that, we'll need to remove the rows representing the follow relationship from both the inbound and outbound follow tables:

DELETE FROM "user_outbound_follows" WHERE "follower_username" = 'alice'   AND "followed_username" = 'bob';  DELETE FROM "user_inbound_follows" WHERE "followed_username" = 'bob'   AND "follower_username" = 'alice';

This is our first encounter with CQL's DELETE statement, although it should look quite familiar to anyone who's worked with SQL. To delete a row, we specify the full primary key of the row, that is, both the partition key(s) and the clustering ...