Tablestore:Python SDK

Feature type

Operation

Description

Data table operations

Create data tables

Create a data table.

Update table configurations

Update the configurations of a data table.

List table names

View the names of all data tables in an instance.

Query table description information

Query the configurations of a data table.

Delete data tables

Delete a specified data table.

Auto-increment primary key column

After you set a primary key column that is not a partition key in a data table to an auto-increment column, you do not need to specify a specific value for the auto-increment column when you write data. Tablestore automatically generates the value for the auto-increment column.Tablestore

Conditional update

Update data in a table only when the specified conditions are met. Otherwise, the update fails and an error is reported.

Local transaction

After you enable local transaction for a data table, you can create a local transaction based on a partition key value.

Atomic counter

The atomic counter feature allows you to specify a column as an atomic counter and perform atomic counter operations on the column.

Filter

Filter the read results on the server side to return only the rows that meet the filter conditions.

Basic data operations

Write data

Write data to the data table.

Read data

Read data from the data table.

Delete data

Delete data from the data table.

Search index

Create search indexes

Create a search index for a data table.

List search indexes

List search indexes that are created for a table.

Update search index configurations

Update the time to live (TTL) of a search index.

Query search index description information

Query the description of a search index, including the information about the fields in the search index and configurations of the search index.

Delete search indexes

Delete a specified search index.

Lifecycle management

Delete historical data or extend the retention period of data in a search index based on business requirements.

Basic query

Basic query types include match all query, term query, terms query, prefix query, range query, wildcard query, exists query, collapse (deduplicate), geo query, and nested query.

Boolean query

Query conditions can contain one or more subconditions. Data is returned when the subconditions are met.

Sorting and pagination

When you use a search index to query data, you can specify a sorting method for the returned data. When the number of returned rows is large, you can use offset-based pagination or token-based pagination to quickly locate the required data.

Aggregation

You can perform operations such as finding minimum values, finding maximum values, summing, finding average values, counting rows, counting distinct values, grouping by field values, grouping by range, grouping by geographical location, and grouping by filter. Multiple aggregation features can be used together to meet complex query requirements.

Full-text index

Full-text index features include match query, match phrase query, and summary and highlighting.

Vector search

You can use the k-nearest neighbor (KNN) vector query feature to perform an approximate nearest neighbor search based on vectors. This way, you can find data items that have the highest similarity to the vector that you want to query in a large-scale dataset.

Parallel scan

When you do not need to sort the entire result set, you can use the parallel scan feature to return all matched data at a faster speed.

Secondary index

Create secondary indexes

Create a secondary index for a data table.

Read data by using secondary indexes

You can query data in a secondary index by reading a single row of data or reading data whose primary key values are within a specific range. If the required attribute columns are included in the secondary index, data can be directly read from the secondary index. Otherwise, data must be read from the data table.

Delete secondary indexes

Delete a specified secondary index from a data table.

SQL query

Create mapping tables

Create mapping relationships for existing tables or indexes.

Update attribute columns of mapping tables

Add or remove attribute columns in an existing mapping table.

Delete mapping tables

Delete one or more mapping tables.

List table names

List the mapping tables in the current database.

Query table description information

Query the description information of a table, such as field names and field types.

Query index description information

Query the index description information of a table.

Query data

Query data in a table.

Feature type

Operation

Description

Time series table operations

Create time series tables

Create a time series table.

Update time series tables

Update the time series table or time series metadata configuration.

List time series tables

View the names and configuration information of all time series tables in an instance.

Query time series table description information

Query the information about a time series table, such as the TTL configuration.

Delete time series tables

Delete a specified time series table.

Time series data operations

Write time series data

Write time series data to a time series table. Batch write is supported.

Query time series data

Query the time series data that meets the specified conditions in a specific time series.

Time series operations

Retrieve time series

Specify multiple conditions to retrieve time series information, such as measure names and data source information.

Update time series

Update time series metadata. Batch update is supported.

Delete time series

Delete time series metadata. Batch delete is supported.

SQL query

Create mapping tables

Create mapping relationships for existing tables or indexes.

Update attribute columns of mapping tables

Add or remove attribute columns in an existing mapping table.

Delete mapping tables

Delete one or more mapping tables.

List table names

List the mapping tables in the current database.

Query table description information

Query the description information of a table, such as field names and field types.

Query index description information

Query the index description information of a table.

Query data

Query data in a table.