Structure of composite partition key tables

The structure of a composite partition key is similar to a single column partition key. The partitioning is based on a hash generated on the combination of values specified for columns in the partition key. So, every unique combination of the partition key columns value will belong to a different partition. This necessitates us to specify values for all the partition key columns when querying a table with a composite partition key. This is what it looks like for the previously specified table: