Learning Apache Cassandra - Second Edition

Composite partition key table

So far, we have only worked with tables that have a single column partition key. Let's try working with multiple columns in the partition key. For instance, in our status application, we might want to allow users to reply to other users' status updates. In this case, each status update would have a stream of replies; replies would be partitioned by the full primary key of the original status update, and each reply would get its own timestamped UUID:

CREATE TABLE "status_update_replies" (   "status_update_username" text,   "status_update_id" timeuuid,   "id" timeuuid,   "author_username" text,   "body" text,   PRIMARY KEY (     ("status_update_username", "status_update_id"),     "id"   ) );

Note the extra set of parentheses ...