How can I change the TTL value of SnappyData table?

Question

How can I change the TTL value for SnappyData table?

For Example: If I create table with TTL = 60 seconds:

CREATE TABLE APP.TEST (ID INTEGER NOT NULL PRIMARY KEY, TTL INTEGER) USING ROW OPTIONS (PARTITION_BY 'ID', EXPIRE '60') ;

How can I change the TTL value later if required?

score 0 · Accepted Answer · answered May 09 '18 at 17:24

0

Unfortunately, Alter table doesn't support changing properties like expire currently. You will need to dump the table into some temp table, delete Test and re-create again.

answered May 09 '18 at 17:24

jagsr

535
2
6

Thanks. I will think about that approach – Rohit Patil May 28 '18 at 10:32

How can I change the TTL value of SnappyData table?

1 Answers1