Hi. Are you asking about SQL query in Ignite, or in PostgreSQL? No queries in PostgreSQL can possibly change any state of Ignite.
The thread, that you provided, contains discussion of native SQL queries: https://apacheignite-sql.readme.io/docs Here is the issue from that discussion: https://issues.apache.org/jira/browse/IGNITE-7687 And it's still unresolved, as you can see. TTL can be updated by using get, put or invoke operations. Denis вт, 27 февр. 2018 г. в 10:30, <[email protected]>: > Hi, > > I have read the reply below. > > > > > http://apache-ignite-users.70518.x6.nabble.com/Eager-TTL-and-query-td11662.html > > > > It mentioned that TTL will only update by IgniteCache API (put/get/invoke > and etc). And SQL query won’t update TTL. > > > > I use PostgreSQL as persistence store. > > Is there any method to update TTL by SQL query? > > Or dose Ignite provide any other policies like TTL? > > > > Thanks. > > > > > > > -- > 本信件可能包含工研院機密資訊，非指定之收件者，請勿使用或揭露本信件內容，並請銷毀此信件。 This email may contain > confidential information. Please do not use or disclose it in any way and > delete it if you are not the intended recipient. >
