CODEWITHSUNDEEP
cassandradatastax
Avba
Avba

Reputation: 15266

cassandra delete an entire row in the future using TTL after the row was created

I want to mark an entire existing row (not a column) for deletion using a TTL.

Unfortunately the TTL will only remove the entire row if it was set during insertion of the row. If you "update" the row and add a TTL, it will only effect the specific columns which were updated , and you can't "update" the primary key.

Is there some sort of work around? Am I forced to read the full row and then "re-insert" it to the table, adding the TTL value?

Upvotes: 0

Views: 595

Answers (1)

MD Ruhul Amin
MD Ruhul Amin

Reputation: 4502

You can't update TTL on an entire row. To do so, you need to re-insert with new TTL.

Check out This link on: Just set the TTL on a row

Upvotes: 1

Related Questions