StarRocks

https://www.starrocks.io/

StarRocks is a high-performance analytical database for real-time analytics.

Installation

Required packages: mysqlclientstarrocks

Drivers

mysqlclientRecommended

mysql-connector-python

starrocksRecommended

mysqlclient

PyMySQL

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: 69/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 StarRocks, along with their causes and solutions.

Authentication1 error

Connection1 error

Compatible Databases

The following databases are compatible with the StarRocks driver:

CelerData

CelerData is a fully-managed cloud analytics service built on StarRocks. It provides instant elasticity, automatic scaling, and enterprise features.

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

Parameters:

Parameter	Description
username	CelerData username
password	CelerData password
host	CelerData cluster endpoint
port	Query port (default 9030)
catalog	Catalog name
database	Database name

Help improve this documentation by editing the engine spec:

Edit starrocks.py