If i have a Primary key statement like Primary Key((year),moviename) for a table. will i be able to insert 2014, Interstellar in a row and 2017, Interstellar in another row. Same movie name on different years
Should the clustering key/keys defines uniqueness or we can rely on year which is a partition key in addition to the clustering column to define uniqueness