Data Lake Analytics (DLA) supports data sources of most Alibaba Cloud services. The following table lists the compatibility matrix for data sources and SQL statements of DLA. The data sources are continuously optimized to support more SQL statements.
RDS databases include ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, ApsaraDB RDS for SQL Server, and PolarDB O. The SQL statements supported by PolarDB are the same as those supported by RDS databases.
| Data Source\ Feature | SELECT | INSERT INTO | INSERT OVERWRITE | CREATE TABLE LIKE MAPPING | MSCK REPAIR DATABASE | MSCK REPAIR TABLE | ADD COLUMN |
|---|---|---|---|---|---|---|---|
| OSS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| RDS | ✓ | ✓ | ✗ | ✓ | ✓ | ✗ | ✗ |
| OTS | ✓ | ✓ | ✗ | ✗ | ✓ | ✗ | ✓ |
| ODPS | ✓ | ✓ | ✗ | ✓ | ✓ | ✗ | ✗ |
| ADB-MySQL 2.0 | ✓ | ✓ | ✗ | ✗ | ✓ | ✗ | ✗ |
| ADB-MySQL 3.0 | ✓ | ✓ | ✓ | ✗ | ✓ | ✗ | ✗ |
| ADB-PG | ✓ | ✓ | ✓ | ✗ | ✓ | ✗ | ✗ |
| MongoDB | ✓ | ✓ | ✗ | ✗ | ✗ | ✗ | ✗ |
| Redis | ✓ | ✓ | ✗ | ✓ | ✓ | ✗ | ✗ |