CODEWITHSUNDEEP
cassandra
Rajesh Shanmugam
Rajesh Shanmugam

Reputation: 75

Can the TTL of tupule be updated without updating the tupule itself in cassandra

I am sort of noob to cassandra. I was wondering if it is possible to add expiry to a tupule without actually updating the tupule. I have not specified the TTL during INSERT of the tupule. Now I just want to update the TTL.

Is this possible?

Regards Rajesh

Upvotes: 1

Views: 103

Answers (1)

Alex Popescu
Alex Popescu

Reputation: 4002

As far as I can tell there's no way to set only the ttl. You could probably re-set one of the values to allow you to pass in the ttl:

UPDATE TABLE USING TTL 10 SET a_col = a_col WHERE key = key;

See the syntax: here

Note: keep in mind that this will set the TTL for the a_col column and will result in an write operation.

Update: this answer is also a valid option.

Upvotes: 4

Related Questions