Database Reference
In-Depth Information
include the
ALLOW FILTERING
directive as a
waiver
indicating that we know the query
may be expensive:
Having assured ourselves that our denormalized structure is justified, we'll use the
user_inbound_follows
table to find out who follows
bob
:
SELECT "follower_username"
FROM "user_inbound_follows"
WHERE "followed_username" = 'bob';
Since we're doing the lookup using the
follower_username
partition key, Cassandra
has no complaints, and the result is what we expect:
Poor
bob
has only one follower. Keep posting those funny cat pictures,
bob
, and you'll
have more in no time!
