Data queries

Basic capabilities

ApsaraDB for SelectDB supports the standard SQL syntax and is compatible with MySQL. ApsaraDB for SelectDB uses the MySQL protocol, so you can connect to an instance by using MySQL-compatible tools such as command-line tools, Java Database Connectivity (JDBC) or Open Database Connectivity (ODBC) drivers, and visualization tools. You can also use programming languages such as C, C++, Python, Java, and Shell to develop applications that query ApsaraDB for SelectDB.

ApsaraDB for SelectDB allows you to filter, sort, and aggregate data in a single table and perform multi-table join queries, subqueries, and window function queries by using SQL statements. This reduces costs.

Advanced capabilities

Query acceleration

ApsaraDB for SelectDB uses query optimization technologies, including the Nereids query optimizer that is developed based on the Cascades framework, the pipeline execution engine, high-concurrency point queries, materialized views, index-based acceleration, and join query optimization. In most cases, ApsaraDB for SelectDB automatically optimizes query plans and execution to deliver high-performance analytics out of the box.

You can also improve query performance to meet your business requirements. For more information, see Query acceleration.

Data lakehouse

ApsaraDB for SelectDB provides the multi-catalog feature to connect to external data sources, including data lakes such as Hive, Iceberg, and Hudi, and databases such as MySQL and Elasticsearch. You can access and analyze data stored in external data sources through catalogs for flexible, unified data management.

ApsaraDB for SelectDB also provides table-valued functions (TVFs) to map file data in remote storage such as Amazon Simple Storage Service (Amazon S3) and Hadoop Distributed File System (HDFS) to tables, so you can query file data directly.

For more information about the external data sources that are supported by ApsaraDB for SelectDB, see Data lakehouse.

Ecosystem integration

ApsaraDB for SelectDB supports data import and visualized data integration solutions.

You can import data from Alibaba Cloud data sources and self-managed data sources into ApsaraDB for SelectDB instances by using data import tools.

ApsaraDB for SelectDB integrates with MySQL-compatible visualization tools for streamlined data development and visual analysis.

For the complete list of supported integration solutions, see Data lakehouse.

Data types

ApsaraDB for SelectDB supports data types compatible with MySQL. ApsaraDB for SelectDB supports a subset of MySQL data types. For more information, see Data types supported by ApsaraDB for SelectDB.