All Products
Search
Document Center

Tablestore:SQL query

Last Updated:Nov 03, 2023

This topic describes how to use the SQL query feature by using Tablestore SDK for Python.

Important

Tablestore SDK for Python V5.4.2 and later support the SQL query feature. Make sure that you install the latest version of Tablestore SDK for Python if you want to use the SQL query feature. For more information, see Version history of Tablestore SDK for Python.

Operation

Description

Create mapping tables

You can execute the CREATE TABLE statement to create a mapping table for an existing table or search index.

Delete mapping tables

You can execute the DROP MAPPING TABLE statement to delete mapping tables that are created for tables.

Query the names of tables

You can execute the SHOW TABLES statement to query the names of tables in the current database.

Query information about tables

You can execute the DESCRIBE statement to query the information about tables, such as the field names and field types.

Query index information about tables

You can execute the SHOW INDEX statement to query the index information about tables.

Query data

You can execute the SELECT statement to query data in a table.