Give the differences between the different types of Primary Keys in Cassandra?

• Single primary key

In this case, only one column is used as a primary key. This column is also referred to as partitioning key which is used to partition the data. By virtue of the partition key, data has been spread on various nodes.

• Compound Primary Key

In this, the data is partitioned and then grouped. race_name is referred to as partitioning key while the race_position is referred to as clustering key. Former decides the partition of data and the latter decides the clustering of data.