All Products
Search

This Product

    Dataphin:DataService: Supported data sources and compute engines

    Document Center

    Dataphin:DataService: Supported data sources and compute engines

    Last Updated:Jul 31, 2026

    This topic covers the data sources supported by data service for creating service units or APIs, and the compute engines supported by logical table APIs.

    Legend

    Y indicates the feature is supported by the data source or compute engine;N indicates it is not.

    Limits

    Only direct connection data sources can be created, updated, or deleted using APIs.

    Supported data sources for Data Service

    • Direct connection data source APIs support both synchronous and asynchronous call modes. If a data source supports asynchronous calls, this is noted.

    • Support for row-level security, pagination, and returning the total count differs between service units and direct connection data source APIs:

      • If support for row-level security, pagination, or returning the total count is marked as 'Y', both the API and the service unit support the feature. Exceptions where only the API or the service unit offers support are explicitly noted.

      • If support for row-level security, pagination, or returning the total count is marked as 'N', neither the API nor the service unit supports the feature.

    • For synchronous calls, an API can return a maximum of 10,000 records per response. However, the total number of records is unlimited for either synchronous or asynchronous calls.

    • Specifically, logical table APIs support pagination.

    • If a data source supports transactions, this is noted.

    Data source

    Data source version

    Service unit

    Direct data source API

    Row-level permission

    Pagination

    Total count

    CUD operations

    Big data storage

    MaxCompute

    /

    N

    Y (asynchronous mode only)

    N

    N

    Y

    N

    Hive (Hudi, Iceberg, Paimon)

    • CDH 5.x Hive 1.1.0

    • E-MapReduce 3.x Hive 2.3.5

    • E-MapReduce 5.x Hive 3.1.x

    • CDH 6.x Hive 2.1.1

    • FusionInsight 8.x Hive 3.1.0

    • CDP 7.x Hive 3.1.3

    • AsiaInfo DP 5.x Hive 3.1.0

    N

    Y (asynchronous mode only)

    Y

    N

    Y

    N

    Hologres

    /

    Y

    Y

    Y

    Y

    Y

    N

    Impala

    • CDH 5: 2.11.0

    • CDH 6: 3.2.0

    • CDP 7.1.3: 3.4.0

    • E-MapReduce 3.x: 3.4.0

    • E-MapReduce 5.x: 3.4.0

    • E-MapReduce 5.x: 4.2.0

    N

    Y

    N

    Y

    Y

    N

    TDH Inceptor

    • 6.2.x

    • 9.3.x

    N

    Y (both synchronous and asynchronous modes)

    N

    Y

    Y

    N

    Doris

    /

    Y

    Y (both synchronous and asynchronous modes)

    N

    Y

    Y

    N

    SelectDB

    V3.x

    Y

    Y (both synchronous and asynchronous modes)

    Y

    Y

    Y

    N

    TDengine

    /

    N

    Y

    N

    Y

    Y

    N

    StarRocks

    /

    N

    Y (both synchronous and asynchronous modes)

    Y

    Y

    Y

    N

    Databricks

    2.6.40

    N

    Y (both synchronous and asynchronous modes)

    N

    Y

    Y

    N

    Amazon Redshift

    1.0.x

    Y

    Y (both synchronous and asynchronous modes)

    N

    Y

    Y

    N

    DolphinDB

    v2.00.11.2

    N

    Y (both synchronous and asynchronous modes)

    N

    Y

    Y

    N

    Relational database

    PolarDB-X 2.0

    /

    Y

    Y (both synchronous and asynchronous modes)

    N

    Y

    Y

    N

    MySQL

    • MySQL 5.1.43

    • MySQL 5.6/5.7

    • MySQL 8

    • ApsaraDB RDS for MySQL

    Y

    Y

    Y

    Y

    Y

    Y (with transactions)

    SAP HANA

    /

    N

    Y

    N

    N

    N

    N

    Microsoft SQL Server

    /

    Y

    Y

    Y

    Y

    Y

    Y (with transactions)

    PostgreSQL

    /

    Y

    Y

    Y

    Y

    Y

    Y (with transactions)

    AnalyticDB for MySQL 2.0

    /

    Y

    N

    Y

    Y (service units only)

    Y (service units only)

    N

    AnalyticDB for MySQL 3.0

    /

    Y

    Y (both synchronous and asynchronous modes)

    Y

    Y

    Y

    N

    AnalyticDB for PostgreSQL

    /

    Y

    N

    Y

    Y (service units only)

    Y (service units only)

    N

    OceanBase

    /

    Y

    Y (both synchronous and asynchronous modes)

    N

    Y

    Y

    N

    Oracle

    • Oracle 11g

    • Oracle 12c

    • Oracle 18c

    • Oracle 19c

    • Oracle 21c

    • Oracle 23c

    Y

    Y

    Y

    Y

    Y

    Y (with transactions)

    ClickHouse

    /

    N

    Y

    Y

    Y

    Y

    N

    Dameng Database (versions 3.13.12 and 3.14.4 only)

    /

    Y

    Y

    N

    Y

    Y

    N

    GBase 8c

    /

    Y

    Y (both synchronous and asynchronous modes)

    N

    Y

    Y

    N

    GaussDB (DWS)

    /

    N

    Y

    Y

    Y

    Y

    N

    Amazon RDS for PostgreSQL

    /

    Y

    Y

    Y (service units only)

    Y

    Y

    N

    Amazon RDS for MySQL

    • MySQL 5.6/5.7

    • MySQL 8

    Y

    Y

    Y (service units only)

    Y

    Y

    N

    Amazon RDS for SQL Server

    /

    Y

    Y

    Y (service units only)

    Y

    Y

    N

    Amazon RDS for Oracle

    • Oracle 19c

    • Oracle 21c

    Y

    Y

    Y (service units only)

    Y

    Y

    N

    GBase 8a

    /

    Y

    Y (both synchronous and asynchronous modes)

    N

    Y

    Y

    N

    TDSQL for MySQL

    /

    Y

    Y (both synchronous and asynchronous modes)

    Y

    Y

    Y

    N

    TDSQL for PostgreSQL

    /

    Y

    Y (both synchronous and asynchronous modes)

    Y

    Y

    Y

    N

    NoSQL

    Elasticsearch

    • Elasticsearch 6.x

    • Elasticsearch 7.x

    • Elasticsearch 8.x

    Y

    Y

    N

    Y (service units only)

    Y (service units only)

    N

    HBase

    • HBase 0.94

    • HBase 1.1.x

    • HBase 2.x

    Y

    Y

    N

    N

    N

    N

    MongoDB

    • MongoDB 3.2

    • MongoDB 3.4+

    Y

    N

    N

    Y (service units only)

    Y (service units only)

    N

    Lindorm (wide table)

    /

    N

    Y

    N

    Y

    Y

    N

    OpenSearch

    2.x

    N

    Y

    N

    Y

    Y

    N

    Supported compute engines

    Compute engine

    Logical table API

    MaxCompute

    Y

    CDH5.x, CDH6.x

    Y

    Cloudera Data Platform 7.x

    Y

    AsiaInfo DP 5.3

    Y

    AnalyticDB for PostgreSQL

    Y