Learning Apache Cassandra - Second Edition

Deleting specific columns

To remove data from a column in Cassandra rather than setting it to NULL, we'll want to simply delete it from the column. The syntax for CQL's DELETE statement allows us to do just this by specifying one or more specific columns that we want to delete from:

DELETE "location" FROM "users" WHERE "username" = 'bob';

We can now check the users table again to confirm that bob no longer has a location in his profile: