Data queries

Basic capabilities

ApsaraDB for SelectDB supports the standard SQL syntax and is compatible with MySQL. ApsaraDB for SelectDB supports the connections over the MySQL protocol and is highly compatible with the MySQL ecosystem. Therefore, you can connect to an ApsaraDB for SelectDB instance by using tools that are compatible with the MySQL ecosystem, such as command-line tools, Java Database Connectivity (JDBC) or Open Database Connectivity (ODBC) drivers, or 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 queries such as multi-table join queries, subqueries, and queries that contain window functions by executing SQL statements. This reduces costs.

Advanced capabilities

Query acceleration

To provide high-performance data analysis services, 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 the query plan and execution process to provide out-of-the-box and high-performance data analysis services.

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 and can be connected to a large number of external data sources, including data lakes such as Hive, Iceberg, and Hudi, and databases such as MySQL and Elasticsearch. This allows you to analyze data with ease. You can quickly access and analyze the data that is stored in the external data sources based on catalogs. This way, you can manage and analyze data in a more flexible and comprehensive way.

ApsaraDB for SelectDB also provides table-valued functions (TVFs), which allows you to map file data in common remote storage such as Amazon Simple Storage Service (Amazon S3) and Hadoop Distributed File System (HDFS) to tables in ApsaraDB for SelectDB. This way, you can analyze the file data with ease.

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 use data import tools to import data from a variety of data sources, including Alibaba Cloud data sources and self-managed data sources, to ApsaraDB for SelectDB instances. ApsaraDB for SelectDB provides stable, efficient, and easy-to-use data integration solutions.

Based on visualized data integration solutions, ApsaraDB for SelectDB can be seamlessly integrated with visualization tools that are compatible with the MySQL ecosystem. This improves the efficiency of data development and visualized analysis.

For more information about the complete list of integration solutions that are supported by ApsaraDB for SelectDB, see Data lakehouse.

Data types

The data types that are supported by ApsaraDB for SelectDB are compatible with those supported by MySQL. ApsaraDB for SelectDB supports a subset of the data types that are supported by MySQL. For more information about the supported data types, see Data types supported by ApsaraDB for SelectDB.