Updating the index after data expires (TTL)

Configure purge of expired and deleted data.

Time-To-Live (TTL) set on a CQL field also applies to the indexed values. The DSE Search engine purges expired and deleted data by rebuilding the index as defined by the ttl_index_rebuild_options in the dse.yaml file. The default rebuild interval is 300 seconds (5 minutes).

Setting data expiration in CQL

  1. Using CQL INSERT or UPDATE, set the TTL property.
    For example, insert a row with a life of 60 seconds into the health_data demo:
    INSERT INTO demo.health_data (id, age, gender) 
    VALUES (9999,88,'female') USING TTL 60;
  2. Force the index to update with the new data:
    COMMIT SEARCH INDEX ON demo.health_data ;
  3. After 60 seconds, the row is removed from the CQL table and the search index.