Tablestore:.NET SDK

Feature type

Operation

Description

Data table operations

Create a data table

Create a data table to store data. You can configure auto-increment primary key columns when you create a data table.

Update table configurations

Updates the configurations of a data table.

List data tables

View the names of all data tables in an instance.

Query table information

Queries the configurations of a data table.

Delete a data table

Delete a specified data table.

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.

Filter

Filter the read results on the server side based on the conditions in the filter to determine the data to return.

Conditional update

Update data in a table only when the data meets the update conditions. Otherwise, the data update fails and an error is returned.

Atomic counter

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

Search index

Create a search index

Create a search index for a data table.

List search indexes

Query 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

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

Delete a search index

Delete a specified search index.

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 include one or more sub-query conditions to determine whether data meets the query conditions based on the sub-query conditions.

Sorting and pagination

When you query data using a search index, you can obtain the returned data in a specified order. When the number of returned rows is large, you can quickly locate the required data by using offset-based pagination or token-based pagination.

Aggregation

You can perform operations such as finding the minimum value, finding the maximum value, calculating the sum, calculating the average, counting rows, counting distinct rows, grouping by field values, grouping by range, grouping by geographical location, and grouping by filter conditions. Multiple aggregation features can be combined to meet complex query requirements.

Full-text index

Tablestore provides match query and phrase query to implement full-text index features. Queries match data based on tokenization.

Parallel export

When you do not care about the order of the entire result set, you can use the parallel export feature to return all matched data at a faster speed.

Secondary index

Create a secondary index

Create a secondary index for a data table.

Read data using a secondary index

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 a secondary index

Delete a specified secondary index from a data table.

SQL query

Create a mapping table

Create a mapping table for an existing table or index.

Update attribute columns in a mapping table

Add or remove attribute columns in an existing mapping table.

Delete a mapping table

Delete one or more mapping tables.

List mapping tables

List the mapping tables in the current database.

Query table description

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

Query index description

Query the index description of a table.

Query data

You can use the SELECT syntax to query data in a table.