educative.io

Educative

Sharding by TweetID and Tweet creation time?

If we shard DB based on TweetId and creation, They will allow us to get the latest tweets only… How can we get the specific user’s tweets. ?

Thanks.

2 Likes

I think we can query all servers and filter tweets according to UserID.

but UserID is not the partition key. For Cassandra, the query needs to be run on partition, correct? In this case, the partition key is the tweet id. I’m a bit confused on this.