I'm trying to solve the Extend The KillrVideo Logical Model Exercie but i'm getting a little bit confused about the solution given by datastax academy.
In fact, in Q2 query the given solution defines the column character_name as a clustering column, but without givinf an explanation
(May be it was obvious, but not for me :).
Did we add character_name as a clustering column:
- For uniqueness guarantee? (an actor can feature in the same video with different characters).However the given explanation said: "The key attributes are actor_name and video_id.
Or because :
- The couple ( actor_name and chracter_mame is a nested entity so for performance reason we need to store them in the same partition).
Thank you in advance