All Products
Search
Document Center

Tablestore:How do I delete time series data?

Last Updated:Jan 26, 2024

In the TimeSeries model, data consists of the metadata of time series and the data of the time series tables to which the time series belong.

  • To delete the metadata of a time series, you can specify the time to live (TTL) of the time series metadata or call the DeleteTimeseriesMeta operation. After you delete the metadata of a time series, the data of the associated time series table is not deleted. You can still query the data of the associated time series table by calling the GetTimeseriesData operation based on the identifier of the time series.

  • To delete the data of a time series table, you can specify the TTL of the time series table. This way, the data whose retention period exceeds the specified TTL is automatically deleted. For more information, see Use the TimeSeries model in the Tablestore console or Use the TimeSeries model by using Tablestore SDKs. You cannot specify the row of data to delete from a time series table. However, you can overwrite a specific row of data in a time series table. To achieve this, you can manually write a delete marker to an existing row to overwrite the original data.