Apache Doris

https://doris.apache.org/

Apache Doris is a high-performance real-time analytical database.

Installation

Required packages: mysqlclientmysqlclientpydoris

Drivers

mysqlclientRecommended

mysql-connector-python

PyPI Package: mysqlclient

mysql://{username}:{password}@{host}/{database}

Recommended driver. May fail with caching_sha2_password auth.

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 79/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Troubleshooting

Common error messages you may encounter when connecting to or querying Apache Doris, along with their causes and solutions.

Authentication1 error

Connection3 errors

Query1 error

Compatible Databases

The following databases are compatible with the Apache Doris driver:

VeloDB

VeloDB is a fully-managed cloud service and enterprise distribution built on Apache Doris. It provides real-time analytics and search with enterprise security and support. It provides SaaS and BYOC offers on AWS, GCP, and Azure.

doris://{username}:{password}@{host}:{port}/{catalog}.{database}

SelectDB

SelectDB is a fully-managed cloud service and enterprise distribution built on Apache Doris. It provides real-time analytics and search with enterprise security and support. It provides SaaS and BYOC offers on Aliyun, Tencent Cloud, and Huawei Cloud.

doris://{username}:{password}@{host}:{port}/{catalog}.{database}

Help improve this documentation by editing the engine spec:

Edit doris.py