Tablestore:TTL of time series data

Modify the TTL of data in a time series table

1. Go to the Instance Management page.

   1. Log on to the Tablestore console.

   2. In the top navigation bar, select a resource group and a region.

   3. On the Overview page, click the name of the instance that you want to manage or click Manage Instance in the Actions column of the instance.

2. In the lower part of the Instance Details tab, click the Time Series Tables tab.

3. On the Time Series Tables tab, click the name of the time series table that you want to manage.

4. In the Description section of the Basic Information tab, click the icon next to Data Lifecycle.

5. In the dialog box that appears, modify the TTL value.

   The TTL value is the retention period of the data in the time series table. Unit: seconds. The value must be -1 or a value that is greater than or equal to 86400. The value -1 indicates that the data never expires. The value 86400 indicates one day.

6. Click Yes.

Modify the TTL of time series metadata

1. Go to the Instance Management page.

   1. Log on to the Tablestore console.

   2. In the top navigation bar, select a resource group and a region.

   3. On the Overview page, click the name of the instance that you want to manage or click Manage Instance in the Actions column of the instance.

2. In the lower part of the Instance Details tab, click the Time Series Tables tab.

3. On the Time Series Tables tab, click the name of the time series table that you want to manage.

4. In the Description section of the Basic Information tab, click the icon next to Timeline TTL.

5. In the dialog box that appears, modify the TTL value.

   The TTL value is the retention period of the time series metadata in the time series metadata table. Unit: seconds. The value must be -1 or a value that is greater than or equal to 604800. The value -1 indicates that the metadata never expires. The value 604800 indicates seven days.

6. Click Yes.

Modify the TTL of data in a time series table

The following sample code provides an example on how to change the TTL of the data in a time series table to three years.

private static void updateTimeseriesTable(TimeseriesClient client) {
    // Specify the name of the time series table. 
    String tableName = "<TIMESERIES_TABLE>";
    UpdateTimeseriesTableRequest updateTimeseriesTableRequest = new UpdateTimeseriesTableRequest(tableName);
    // Change the TTL to three years. 
    updateTimeseriesTableRequest.setTimeseriesTableOptions(new TimeseriesTableOptions(86400 * 365 * 3)); 
    client.updateTimeseriesTable(updateTimeseriesTableRequest);

    DescribeTimeseriesTableResponse describeTimeseriesTableResponse = client.describeTimeseriesTable(new DescribeTimeseriesTableRequest(tableName));
    TimeseriesTableMeta tableMeta = describeTimeseriesTableResponse.getTimeseriesTableMeta();
    // View the modified TTL. 
    System.out.println(tableMeta.getTimeseriesTableOptions().getTimeToLive()); 
}

Modify the TTL of time series metadata

The following sample code provides an example on how to change the TTL value specified for time series metadata in a time series table to 94608000 (three years):

private static void updateTimeseriesMetaTableTTL(TimeseriesClient client) {
    // Specify the name of the time series table. 
    String tableName = "<TIMESERIES_TABLE>";
    UpdateTimeseriesTableRequest updateTimeseriesTableRequest = new UpdateTimeseriesTableRequest(tableName);
    // Change the TTL value to 94608000 (three years). 
    TimeseriesMetaOptions options = new TimeseriesMetaOptions();
    options.setMetaTimeToLive(86400 * 365 * 3);
    updateTimeseriesTableRequest.setTimeseriesMetaOptions(options);
    client.updateTimeseriesTable(updateTimeseriesTableRequest);
}