All Products
Search
Document Center

Tablestore:Create a Lastpoint index

Last Updated:Apr 14, 2025

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

Procedure

  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 instance name or click Manage Instance in the Actions column of the instance.

  2. Go to the Manage Time Series Table page.

    1. On the Instance Management page, click the Time Series Tables tab.

    2. 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.

  3. Create a Lastpoint index.

    1. On the Manage Time Series Table page, click the Basic Information tab, and then click Create LastPoint Index.

    2. 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.

    3. 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.