Tablestore:Quick start for search indexes

Step 1: Create a search index

You can create a search index to accelerate data queries. You must add the fields that you want to query to the search index. You can configure advanced settings, such as the Routing Key, Time to Live, and Pre-sorting parameters, based on your business requirements.

1. Go to the Indexes tab.

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

   4. In the Tables section of the Instance Details tab, click the name of the data table and click the Indexes tab. Alternatively, you can click Indexes in the Actions column of the data table.

2. On the Indexes tab, click Create Search Index.

3. In the Create Index dialog box, specify the index name based on your business requirements.

4. Select Auto Generate for Schema Generation Type, and select the field type and specify whether to enable array based on your business requirements.

   In this example, the search index name is example_index. The search index contains four fields: id (Fuzzy Keyword), cost (Floating Point), name (String), and age (Long Integer).

   Important

   The value of Field Name for each field in the search index must be the same as the field name in the data table, and the data type of each field in the search index must match the data type of the field in the data table.

   

5. Click OK.

   After the search index is created, in the Actions column of the search index in index list, click Index Details to view the basic information, index metrics, routing key, index fields, and pre-sorting information of the search index.

Step 2: Use the search index to query and analyze data

When you use a search index to query data, you can select the query types based on your business requirements. When you query data, you can specify the columns that you want to return, the sorting method for returned data, and whether to perform statistical analysis on the data.

This example demonstrates how to use range query to query rows where the cost column value is greater than or equal to 10 and less than or equal to 1000, and calculate the sum of the cost column values in the rows that meet the conditions.

1. On the Indexes tab, click Manage Data in the Actions column of the search index.

2. In the Search dialog box, select cost as the index field, and click Add.

   

3. Configure the range query conditions.

   1. Set Query Type to RangeQuery(RangeQuery).

   2. Set the maximum value to 1000 and the minimum value to 10.

4. Turn on the Collect Statistics switch and configure the statistical conditions.

   1. Select cost as the statistical field and click Add.

   2. Set Statistics Type to Sum and set Item to costtotal.

5. Click OK.

   The data that meets the query conditions is displayed on the Indexes tab.