1. SQL Reference Guide
  2. Data Row Management
  3. UPDATE Statement
  4. Update Clauses
  5. SET TTL Clause

SET TTL Clause

Syntax

ttl_clause ::= 
   (add_expression (HOURS | DAYS)) | 
   (USING TABLE DEFAULT)

Semantics

If a SET TTL clause is used with an UPDATE statement, a new expiration time is computed and applied to the row being updated. In case of MR Tables, the rows replicated to other regions carry the recalculated expiration time of the row being updated. Therefore, this row will have the same expiration time in all the regions after successful replication. If a TTL value is updated to the same row in multiple regions, then the TTL value will be set in all regions to the value held in the row with the greatest write timestamp.

See Example: Updating TTL.