Search code examples
javaignitettl

Apache Ignite: TTL

Is it possible to set TTL on SQL rows in apache ignite?

I am aware of this documentation concerning TTL: https://apacheignite.readme.io/docs/expiry-policies but if I understand it right, it only applies to the cache layer?

What I need to do:

  • Set TTL for a row upon insert
  • Update TTL for single rows

It seems that the ModifiedExpiryPolicy is exactly what I need.

Is that possible? If yes, how?

Solution

  • Unfortunately it is a limitation of API that you can't set expiry policy with SQL.

    However, you can add rows using other mechanisms (Cache API, Data Streamer) and then use them across SQL.