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:
mysqlclientmysql://{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
Compatible Databases
The following databases are compatible with the StarRocks driver:
CelerDataCelerData 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 |