This topic describes the basic query types supported by search indexes when you use Tablestore SDK for Python to query data.
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 contains the specified prefix from a data table. | |
This query retrieves data that falls within the specified range. | |
This query retrieves data that matches a string containing wildcard characters. | |
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. | |
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. | |
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. |