Geo-distance 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 Index Management tab, find the target Search Index and click Search in the Actions column.

3. In the Search dialog box, configure the query parameters.

   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 GEOPOINT type and click Add.

   4. Set the query type for the index field to GeoDistanceQuery. Enter the center point coordinates, select the point, and enter the distance.

      If you want to enter multiple coordinate pairs of central points, repeat the preceding operation.

   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.

4. Click OK.

   The query results are displayed on the Index Management tab.

You can use the Tablestore CLI to run the search command to query data by using search indexes. For more information, see Search index.

1. Run the search command to use the search_index search index to query data and return all indexed columns of each row that meets the query conditions.

   search -n search_index --return_all_indexed

2. The following sample code shows how to enter the query conditions as prompted by the system:

   {
       "Offset": -1,
       "Limit": 10,
       "Collapse": null,
       "Sort": null,
       "GetTotalCount": true,
       "Token": null,
       "Query": {
           "Name": "GeoDistanceQuery",
           "Query": {
               "FieldName": "col_geopoint",
               "CenterPoint": "35.8,-45.91",
               "DistanceInMeter": 100.0
           }
       }
   }

You can perform geo-distance queries by using Tablestore SDK for Java, Tablestore SDK for Go, Tablestore SDK for Python, Tablestore SDK for Node.js, Tablestore SDK for .NET and Tablestore SDK for PHP. In the following example, Tablestore SDK for Java is used to describe how to perform geo-distance queries.

The following sample code provides an example on how to query rows in which the value of the Col_GeoPoint column is within a specific distance from the central point.

public static void geoDistanceQuery(SyncClient client) {
    SearchQuery searchQuery = new SearchQuery();
    GeoDistanceQuery geoDistanceQuery = new GeoDistanceQuery();  // Use GeoDistanceQuery. 
    geoDistanceQuery.setFieldName("Col_GeoPoint");
    geoDistanceQuery.setCenterPoint("5,5"); // Specify the coordinates of the central point. 
    geoDistanceQuery.setDistanceInMeter(10000); // Set the distance from the central point to a value greater than or equal to 10,000. Unit: meter. 
    searchQuery.setQuery(geoDistanceQuery);
    //searchQuery.setGetTotalCount(true); // Set the GetTotalCount parameter to true to return the total number of rows that meet the query conditions. 

    SearchRequest searchRequest = new SearchRequest("<TABLE_NAME>", "<SEARCH_INDEX_NAME>", searchQuery);
    // You can use the columnsToGet parameter to specify the columns that you want to return or specify that all columns are returned. If you do not specify this parameter, only the primary key columns are returned. 
    //SearchRequest.ColumnsToGet columnsToGet = new SearchRequest.ColumnsToGet();
    //columnsToGet.setReturnAll(true); // Specify that all columns are returned. 
    //columnsToGet.setColumns(Arrays.asList("ColName1","ColName2")); // Specify the columns that you want to return. 
    //searchRequest.setColumnsToGet(columnsToGet);

    SearchResponse resp = client.search(searchRequest);
    //System.out.println("TotalCount: " + resp.getTotalCount()); // Display the total number of rows that meet the query conditions instead of the number of rows that are returned. 
    System.out.println("Row: " + resp.getRows());
}