Quick BI:Data source function item list

Data source

Supported function items

Initialize SQL

Upload file

Custom week

HINT statement

Data reporting

Complex table reporting

System built-in function

Trend/multidimensional analysis table (average/accumulation)

Database data source

MySQL

✅

✅

✅

✅

✅

✅

✅

Alibaba MaxCompute

✅

✅

✅

✅

✅

✅

Alibaba AnalyticDB for MySQL 2.0

✅

Alibaba AnalyticDB for MySQL 3.0

✅

✅

✅

✅

✅

✅

✅

SQL Server

✅

✅

✅

✅

✅

✅

✅

✅

PostgreSQL

✅

✅

✅

✅

✅

✅

✅

✅

Alibaba Hologres

✅

✅

✅

✅

✅

✅

✅

✅

ClickHouse

✅

✅

✅

✅

✅

✅

Alibaba AnalyticDB for PostgreSQL

✅

✅

✅

✅

✅

✅

Presto

✅

✅

✅

✅

✅

Alibaba PolarDB for MySQL

✅

✅

✅

✅

✅

✅

✅

Oracle

✅

✅

✅

✅

✅

✅

✅

Hive

✅

✅

✅

✅

Alibaba PolarDB distributed version (DRDS, Alibaba PolarDB-X)

✅

✅

✅

Alibaba PolarDB for PostgreSQL

✅

✅

✅

✅

✅

SAP HANA

Alibaba PolarDB for Oracle (formerly PPAS)

✅

✅

✅

✅

✅

Hbase

Vertica

Impala (not supported by EMR)

✅

✅

✅

✅

Spark SQL

✅

✅

✅

✅

Apache Doris

✅

✅

✅

✅

Dameng (DM)

✅

✅

✅

StarRocks

✅

✅

✅

✅

✅

✅

TDSQL-H LibraDB

Lindorm

Alibaba SLS

IBM DB2 LUW

OceanBase

SAP IQ (Sybase IQ)

SAP HANA

✅

Kingbase

Gbase 8a

✅

Snowflake

Kylin

MongoDB

SelectDB

TiDB

✅

✅

MariaDB

✅

✅

GaussDB

GaussDB(DWS)

Elasticsearch

Shentong

✅

Application data source

Dataphin

✅ (under JDBC connection)

✅