Learning Apache Cassandra - Second Edition

Static-only inserts

As it turns out, inserting a row that consists only of static data is perfectly valid. Let's say, we relax our rule that upon signing up, a user must also write their first status update. If bob wishes to sign up, he may simply enter a username, e-mail, and password:

INSERT INTO "users_with_status_updates" ("username", "email", "encrypted_password") VALUES (   'bob',   '[e-mail]',   0x10920941a69549d33aaee6116ed1f47e19b8e713 );

Now, we have an email and an encrypted_password associated with the partition key bob but no clustering column values forming rows under that partition key. So, can we retrieve the information about bob that we just inserted? As it turns out, we can. Here's the updated state of the table that ...