Match all query - Tablestore SDK for Java - Tablestore - Alibaba Cloud Documentation Center

A match all query with the Tablestore SDK for Java matches every row in a search index and returns matching rows or their total count.

Prerequisites

Install the Tablestore SDK for Java and initialize the client.

Feature description

A match all query matches all data in a search index without specifying a field or value to filter by. When you call search, set the query type to MatchAllQuery, and use SearchQuery to configure the number of returned rows, total count tracking, and other common query behaviors.

SearchResponse search(SearchRequest request)

The following example matches every row in a search index and returns up to 10 rows and the total number of matching rows.

String tableName = "example_table";
String indexName = "example_index";

SearchQuery searchQuery = new SearchQuery();
searchQuery.setQuery(new MatchAllQuery());
searchQuery.setLimit(10);
searchQuery.setTrackTotalCount(SearchQuery.TRACK_TOTAL_COUNT);

SearchRequest request = new SearchRequest(tableName, indexName, searchQuery);
SearchRequest.ColumnsToGet columnsToGet = new SearchRequest.ColumnsToGet();
columnsToGet.setReturnAll(true);
request.setColumnsToGet(columnsToGet);

SearchResponse response = client.search(request);
System.out.println(response.getTotalCount());
System.out.println(response.getRows());

Note

MatchAllQuery assigns the same relevance score to every matching row. Without an explicit sort order, the row order is not guaranteed. To retrieve only the total count, set limit to 0. The server then returns no rows. Tracking total counts increases query overhead.

Parameters

Search request

request is a SearchRequest object that contains the following parameters.

Name	Type	Description
tableName (required)	String	The name of the table.
indexName (required)	String	The name of the search index.
searchQuery (required)	SearchQuery	The query condition and common query settings.
columnsToGet (optional)	SearchRequest.ColumnsToGet	The returned column settings. If you omit this parameter, only primary key columns are returned.
timeoutInMillisecond (optional)	int	The request-level query timeout in milliseconds. The default value is `-1`, which does not set a separate query timeout.
routingValues (optional)	`List<PrimaryKey>`	The primary key values for custom routing fields. Omit this parameter if the index does not use custom routing.

Query settings

request.searchQuery is a SearchQuery object that contains the following parameters.

Name	Type	Description
query (required)	Query	The query condition. Set this parameter to `MatchAllQuery` for a match all query.
offset (optional)	Integer	The starting position of the query.
limit (optional)	Integer	The maximum number of rows to return. Set this parameter to `0` to return no rows.
collapse (optional)	Collapse	The field collapse settings, which deduplicate results by a specified field. For configuration details, see Collapse query results.
sort (optional)	Sort	The result sort order. For configuration details, see Sort and paginate results.
trackTotalCount (optional)	int	The expected maximum number of matching rows to count. The default value is `TRACK_TOTAL_COUNT_DISABLED`, which disables counting. Set this parameter to `TRACK_TOTAL_COUNT` to count all matching rows. A smaller value improves query performance.
filter (optional)	SearchFilter	A filter that is applied to the results of `query`.
aggregationList (optional)	`List<Aggregation>`	The aggregation settings. For configuration details, see Aggregation.
groupByList (optional)	`List<GroupBy>`	The grouping settings. For configuration details, see Aggregation.
token (optional)	byte[]	The pagination token. Set this parameter to the `nextToken` value from the previous response to continue reading rows. When you set `token`, the SDK clears `sort` because the token already contains the sort conditions.

Query condition

request.searchQuery.query is a MatchAllQuery object and has no additional parameters. This query type does not support summary and highlighting. For supported query types and configuration details, see Summary and highlighting.

Returned columns

request.columnsToGet is a SearchRequest.ColumnsToGet object that contains the following parameters.

Name	Type	Description
columns (optional)	`List<String>`	The attribute columns to return. Set this parameter only if `returnAll` and `returnAllFromIndex` are both `false`. If you omit this parameter, only primary key columns are returned.
returnAll (optional)	boolean	Specifies whether to return all attribute columns in the table. Default value: `false`.
returnAllFromIndex (optional)	boolean	Specifies whether to return all indexed attribute columns. Default value: `false`. This parameter and `returnAll` cannot both be `true`.

Return values

search returns a SearchResponse object. The following table describes the core fields.

Name	Type	Description
totalCount	long	The number of matching rows. Call `getTotalCount()` to obtain the value. The returned value depends on the `trackTotalCount` setting.
rows	`List<Row>`	The rows returned by this query. Call `getRows()` to obtain the value. The number of rows does not exceed `limit`.
nextToken	byte[]	The next-page token. Call `getNextToken()` to obtain the value. If the value is not `null`, set it as `token` in the next request to continue reading rows.
isAllSuccess	boolean	Indicates whether all index partitions were queried successfully. Call `isAllSuccess()` to obtain the value. If the value is `false`, the response contains partial results and `totalCount` may be less than the actual number of matching rows.