Use Tablestore SQL query with Python SDK - Tablestore - Alibaba Cloud Documentation Center

This topic explains how to perform SQL query operations using the Tablestore SDK for Python.

Notes

The Tablestore SDK for Python supports SQL query features from version 5.4.2 onwards. Please ensure you have installed the correct version of the Python SDK to use this feature.

For more information, see the historical iterations of the Python SDK.

Feature list

Operation	Description
Create mapping table	Create a mapping relationship for an existing table or index using the `CREATE TABLE` statement.
Update mapping table	Add or delete property columns for an existing mapping table using the `ALTER TABLE` statement.
Delete mapping table	Delete a mapping relationship using the `DROP MAPPING TABLE` statement.
List mapping tables	List the mapping tables in the current database using the `SHOW TABLES` statement.
Query table description	Query the table description, such as field names and field types, using the `DESCRIBE` statement.
Query index description	Query the index description of a table using the `SHOW INDEX` statement.
Query data	Query data in the table using the `SELECT` statement.