This topic describes basic query types provided by search indexes.
Query type | Description |
This query matches all rows in a table to query the total number of rows in the table or return multiple random rows. | |
This query uses exact matches to retrieve data from a data table. A term query is similar to a query based on string matching. | |
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. | |
This query retrieves data that falls within the specified range from a table. | |
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. | |
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.
| |
Geo queries are classified into the following types: geo-distance query, geo-bounding box query, and geo-polygon query.
| |
This query retrieves the data in the child rows of Nested fields. | |
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. | |
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. |