All Products
Search

This Product

    Tablestore:Methods for using SQL query

    Document Center

    Tablestore:Methods for using SQL query

    Last Updated:Mar 11, 2025

    You can use SQL query in the Tablestore console or by using the Tablestore CLI, Tablestore SDKs, or Java Database Connectivity (JDBC). This topic describes the methods that are available to use SQL query and the scenarios in which you can use the methods.

    Methods

    The following table describes the methods that are available to use Tablestore SQL query. Select a method based on your business requirements.

    Method

    Description

    Scenario

    References

    Tablestore console

    Perform SQL query operations on a small amount of data or to check or debug data by using the GUI.

    This method is suitable for administrators and developers who want to query and verify a small amount of data.

    Use the Tablestore console

    Tablestore CLI

    Use the Tablestore CLI to perform SQL query operations on a small amount of data or to check or debug data.

    This method is suitable for users who are familiar with the command line and who want to query and verify a small amount of data.

    SDK

    Tablestore SDKs provide a wide range of programming interfaces in various programming languages to facilitate integration with business logic. You can use Tablestore SDKs to build data-driven applications.

    You can use the Tablestore SDK for mainstream programming languages, such as Java, Go, Python, or Node.js to perform SQL query operations.

    This method is suitable for application developers who access Tablestore by using programming tools.

    Use Tablestore SDKs

    JDBC

    JDBC is the standard database connection interface in the Java ecosystem. You can use JDBC to build applications that require frequent interaction with databases.

    You can use JDBC, Hibernate, or MyBatis to perform Tablestore SQL query operations.

    This method is suitable for applications developed by using Java, such as enterprise applications and web applications.

    Tablestore driver for Go

    When you build high-performance services, using the Tablestore driver for Go to perform SQL query operations enhances development efficiency.

    This method is suitable for applications that are developed by using the Go programming language.

    Use the Tablestore driver for Go

    After you connect Tablestore to DataWorks or Data Management (DMS), you can also execute SQL statements to query data. For more information, see Connect Tablestore to big data platforms.