This topic describes how to create a Lastpoint index for a time series table to quickly retrieve data of the latest point in time in time series in the time series table.
Usage notes
The Lastpoint index feature is supported in the following regions: China (Hangzhou), China (Shanghai), China (Beijing), and China (Zhangjiakou).
The total number of Lastpoint indexes and analytical stores that you create for a time series table cannot exceed 10.
Prerequisites
An instance for the TimeSeries model is created in a region that supports the Lastpoint index features. For more information, see Create an instance for the TimeSeries model.
A time series table is created. For more information, see Operations on time series tables.
Procedure
Go to the Instance Management page.
Log on to the Tablestore console.
In the top navigation bar, select a resource group and a region.
On the Overview page, click the instance name or click Manage Instance in the Actions column of the instance.
Go to the Manage Time Series Table page.
On the Instance Management page, click the Time Series Tables tab.
On the Time Series Tables tab, click the time series table name or click Manage Data in the Actions column of the time series table.
Create a Lastpoint index.
On the Manage Time Series Table page, click the Basic Information tab, and then click Create LastPoint Index.
In the Create LastPoint Index dialog box, configure the parameters based on your business requirements. The following table describes the parameters.
Parameter
Description
LastPoint Index Name
The name of the Lastpoint index. The name must be 1 to 128 bytes in length and can contain letters, digits, and underscores (_). The name cannot start with a digit.
Synchronization Mode
The synchronization mode of the Lastpoint index. Valid values:
Full Synchronization: includes the existing data of the time series table in the Lastpoint index.
Incremental Synchronization: does not include the existing data of the time series table in the Lastpoint index.
Click Create.
Development integration
Related API operations
You can call the CreateTimeseriesLastpointIndex operation to create a Lastpoint index. For more information, see CreateTimeseriesLastpointIndex.
Integration methods
You can use Tablestore SDKs for the following programming languages to create a Lastpoint index:
References
If you want to use more flexible data query methods to accelerate data queries, such as Boolean query, full-text search, prefix query, and fuzzy query, you can use the search index feature of Lastpoint indexes. For more information, see Retrieve a Lastpoint index.