Deleting columns and rows
CQL provides the DELETE command to delete a column or row. Deleted values are removed completely by the first compaction following deletion.
Deletes user jsmith's session token column.
cqlsh:demodb> DELETE session_token FROM users where pk = 'jsmith';
Delete jsmith's entire row.
cqlsh:demodb> DELETE FROM users where pk = 'jsmith';