Guys,
I am sorry for this question but I really don't know what does it mean and couldn't figure it out.
Can anyone tell me what bucket means and represents of what data in this table?
What is the bucket column in the video_interactions_by_user in KillrVideo?
It's just a column to break up the partitions to make them smaller in size. It's just an example to illustrate how you can split the partitions into "buckets" to make them more manageable.
In the DS220 course example, it talks about the user having too many interactions with videos in the thousands. To reduce the number of rows in each partition, we add an arbitrary bucket column to make a composite partition key so we can manually control the size of each partition in the video_interactions_by_user table.
Again, the choice is completely arbitrary and is not a "natural key". It's just to show you ways to design tables. Cheers!
5 People are following this question.
