Tablestore:Suffix query

1. Go to the Index Management tab.

   1. Log on to the Table Store 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 Instance Management in the Actions column.

   4. On the Instance Details tab, in the Data Table List tab, click the data table name or click Index Management in the Actions column.

2. On the Indexes tab, find the target search index and click Manage Data in the Actions column.

   1. By default, all columns are returned. To return specific columns, turn off Retrieve All Columns and enter the column names, separated by commas.

      Note

      By default, Table Store returns the primary key columns of the data table.

   2. Select a logical operator: And, Or, or Not.

      If you select And, the query returns data that meets all specified conditions. If you select Or, the query returns data that meets at least one of the specified conditions. If you select Not, the query returns data that does not meet the specified conditions.

   3. Select an index field of the FuzzyKeyword type and click Add.

   4. Set the query type for the index field to Suffix query (SuffixQuery) and enter the suffix value.

   5. By default, sorting is disabled. To sort the results by a specific field, turn on Enable Sorting, add the sort field, and configure the sort order.

   6. By default, aggregation is disabled. To perform statistical aggregation on a specific field, turn on Enable Aggregation, add the field for aggregation, and configure the aggregation settings.

3. Click OK.

   The query results are displayed on the Index Management tab.

The following example uses the Tablestore SDK for Java.

The following example shows how to query for data where the value in the Col_FuzzyKeyword column ends with "hangzhou".

/**
 * Query for data where the value in the Col_FuzzyKeyword column ends with "hangzhou".
 * @param client
 */
private static void suffixQuery(SyncClient client) {
    SearchQuery searchQuery = new SearchQuery();
    SuffixQuery suffixQuery = new SuffixQuery(); // Set the query type to SuffixQuery.
    searchQuery.setGetTotalCount(true);
    suffixQuery.setFieldName("Col_FuzzyKeyword");
    suffixQuery.setSuffix("hangzhou");
    searchQuery.setQuery(suffixQuery);
    //searchQuery.setGetTotalCount(true); // Set this to true to return the total number of matched rows.

    SearchRequest searchRequest = new SearchRequest("<TABLE_NAME>", "<SEARCH_INDEX_NAME>", searchQuery);
    // Specify the columns to return by setting the columnsToGet parameter. If you do not set this parameter, only primary key columns are returned by default.
    SearchRequest.ColumnsToGet columnsToGet = new SearchRequest.ColumnsToGet();
    //columnsToGet.setReturnAll(true); // Set this to true to return all columns.
    columnsToGet.setColumns(Arrays.asList("Col_FuzzyKeyword")); // Set this to return specified columns.
    searchRequest.setColumnsToGet(columnsToGet);

    SearchResponse resp = client.search(searchRequest);
    //System.out.println("TotalCount: " + resp.getTotalCount()); // Print the total number of matched rows, not the number of returned rows.
    System.out.println("Row: " + resp.getRows());
}