All Products
Search
Document Center

Tablestore:Basic query

Last Updated:Feb 11, 2025

This topic describes basic query types provided by search indexes.

Query type

Description

Match all query

This query matches all rows in a table to query the total number of rows in the table or return multiple random rows.

Term query

This query uses exact matches to retrieve data from a data table. A term query is similar to a query based on string matching.

Terms query

This query allows you to specify multiple keywords to search for the rows that match at least one of the keywords. A row of data is returned if the column value matches at least one of the keywords. Terms queries can be used in the same manner as the IN operator in SQL statements.

Range query

This query retrieves data that falls within the specified range from a table.

Exists query

This query is also called NULL query or NULL-value query, which is used in sparse data to determine whether a column of a row exists.

Fuzzy query

The search indexes of Tablestore support the wildcard query, prefix query, and suffix query features to meet your fuzzy query requirements in different scenarios. You can select an appropriate query method based on your business requirements.

  • Wildcard query: This query retrieves data that matches a string containing wildcard characters. This feature is similar to the LIKE operator in traditional relational databases. You can specify a string that contains asterisks (*) and question marks (?) to perform wildcard queries.

  • Prefix query: This query retrieves data that contains the specified prefix from a data table.

  • Suffix query: This query retrieves data that contains the specified suffix from a data table.

Geo query

Geo queries are classified into the following types: geo-distance query, geo-bounding box query, and geo-polygon query.

  • Geo-distance query: This query allows you to specify a circular geographical area that is defined by a central point and a radius as a query condition. Tablestore returns the rows in which the value of the specified field falls within the circular geographical area.

  • Geo-bounding box query: This query allows you to specify a rectangular geographical area as a query condition. Tablestore returns the rows in which the value of the specified field falls within the rectangular geographical area.

  • Geo-polygon query: This query allows you to specify a polygon geographical area as a query condition. Tablestore returns the rows in which the value of the specified field falls within the polygon geographical area.

Nested query

This query retrieves the data in the child rows of Nested fields.

Perform sorting and paging

You can predefine a sorting method when you create a search index or specify a sorting method when you use the search index to query data. This way, the rows that meet the query conditions are returned based on the order that you predefined or specified.

If a large number of rows are included in the response, you can locate data by configuring the limit and offset parameters or by using tokens.

Collapse (distinct)

This query collapses the result set based on a specific column to display data of the specified type only once in the returned results, ensuring the diversity of the result types.