OceanBase is a distributed relational database.
Installation
Required packages: mysqlclientoceanbase_py
Drivers
mysqlclientRecommended
mysql-connector-python
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
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Troubleshooting
Common error messages you may encounter when connecting to or querying OceanBase, along with their causes and solutions.