Data Service supports specific data sources for creating service units and APIs, and specific compute engines for logical table APIs.
Legend
Y indicates that the feature is supported; N indicates that the feature is not supported.
Limits
Only direct data source APIs support create, update, and delete (CUD) operations.
Supported data sources
-
Direct data source APIs support both synchronous and asynchronous invocation. Asynchronous support is noted where applicable.
-
Row-level security, pagination, and total count support varies between service units and direct data source APIs:
-
Y indicates that both APIs and service units support the feature. If only one supports it, this is explicitly stated.
-
N indicates that neither APIs nor service units support the feature.
-
-
A synchronous call returns a maximum of 10,000 results per response. The total number of queryable results is unlimited for both synchronous and asynchronous calls.
-
Logical table APIs support pagination.
-
Transaction support is noted where applicable.
|
Data source |
Data source version |
Service unit |
Direct API |
Row-level security |
Paginated query |
Total count |
CUD operations |
|
|
Big data storage |
MaxCompute |
/ |
N |
Y (asynchronous call mode only) |
N |
N |
Y |
N |
|
Hive (Hudi, Iceberg, Paimon) |
|
N |
Y (asynchronous call mode only) |
Y |
N |
Y |
N |
|
|
Hologres |
/ |
Y |
Y |
Y |
Y |
Y |
N |
|
|
Impala |
|
N |
Y |
N |
Y |
Y |
N |
|
|
TDH Inceptor |
|
N |
Y (supports synchronous and asynchronous modes) |
N |
Y |
Y |
N |
|
|
Doris |
/ |
Y |
Y (supports synchronous and asynchronous modes) |
N |
Y |
Y |
N |
|
|
SelectDB |
V3.x |
Y |
Y (supports synchronous and asynchronous modes) |
Y |
Y |
Y |
N |
|
|
TDengine |
/ |
N |
Y |
N |
Y |
Y |
N |
|
|
StarRocks |
/ |
N |
Y (supports synchronous and asynchronous modes) |
Y |
Y |
Y |
N |
|
|
Databricks |
2.6.40 |
N |
Y (supports synchronous and asynchronous modes) |
N |
Y |
Y |
N |
|
|
Amazon Redshift |
1.0.x |
Y |
Y (supports synchronous and asynchronous modes) |
N |
Y |
Y |
N |
|
|
DolphinDB |
v2.00.11.2 |
N |
Y (supports synchronous and asynchronous modes) |
N |
Y |
Y |
N |
|
|
Relational database |
PolarDB-X 2.0 |
/ |
Y |
Y (supports synchronous and asynchronous modes) |
N |
Y |
Y |
N |
|
MySQL |
|
Y |
Y |
Y |
Y |
Y |
Y (supports transactions) |
|
|
SAP HANA |
/ |
N |
Y |
N |
N |
N |
N |
|
|
Microsoft SQL Server |
/ |
Y |
Y |
Y |
Y |
Y |
Y (supports transactions) |
|
|
PostgreSQL |
/ |
Y |
Y |
Y |
Y |
Y |
Y (supports transactions) |
|
|
AnalyticDB for MySQL 2.0 |
/ |
Y |
N |
Y |
Y (service units only) |
Y (service units only) |
N |
|
|
AnalyticDB for MySQL 3.0 |
/ |
Y |
N |
Y |
Y (service units only) |
Y (service units only) |
N |
|
|
AnalyticDB for PostgreSQL |
/ |
Y |
N |
Y |
Y (service units only) |
Y (service units only) |
N |
|
|
OceanBase |
/ |
Y |
Y (supports synchronous and asynchronous modes) |
N |
Y |
Y |
N |
|
|
Oracle |
|
Y |
Y |
Y |
Y |
Y |
Y (supports transactions) |
|
|
ClickHouse |
/ |
N |
Y |
Y |
Y |
Y |
N |
|
|
DM Database (v3.13.12 and v3.14.4 only) |
/ |
Y |
Y |
N |
Y |
Y |
N |
|
|
GBase 8c |
/ |
Y |
Y (supports 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 |
|
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 |
|
Y |
Y |
Y (service units only) |
Y |
Y |
N |
|
|
GBase 8a |
/ |
Y |
Y (supports synchronous and asynchronous modes) |
N |
Y |
Y |
N |
|
|
NoSQL |
Elasticsearch |
|
Y |
Y |
N |
Y (service units only) |
Y (service units only) |
N |
|
HBase |
|
Y |
Y |
N |
N |
N |
N |
|
|
MongoDB |
|
Y |
N |
N |
Y (service units only) |
Y (service units only) |
N |
|
|
Lindorm (wide-column) |
/ |
N |
Y |
N |
Y |
Y |
N |
|
|
OpenSearch |
2.x |
N |
Y |
N |
Y |
Y |
N |
|
Compute engine support
|
Compute engine |
Logical table API |
|
MaxCompute |
Y |
|
CDH 5.x and CDH 6.x |
Y |
|
Cloudera Data Platform 7.x |
Y |
|
AsiaInfo DP 5.3 |
Y |
|
AnalyticDB for PostgreSQL |
Y |