Apache Doris Python Client (Custom Build)
A Apache Doris client for the Python programming language.
This is a custom build with relaxed dependency constraints (sqlalchemy-utils removed as it's not actually used in the code).
Apache Doris is a high-performance, real-time analytical database based on MPP architecture, known for its extreme speed and ease of use. It only requires a sub-second response time to return query results under massive data and can support not only high-concurrent point query scenarios but also high-throughput complex analysis scenarios.
Installation
pip install pydoris-custom
Or install from source:
pip install .
SQLAlchemy Usage
To connect to doris using SQLAlchemy, use a connection string (URL) following this pattern:
- User: User Name
- Password: Password
- Host: doris FE Host
- Port: doris FE port
- Catalog: Catalog Name
- Database: Database Name
Here's what the connection string looks like:
doris://<User>:<Password>@<Host>:<Port>/<Database>
pydoris://<User>:<Password>@<Host>:<Port>/<Database>
doris://<User>:<Password>@<Host>:<Port>/<Catalog>.<Database>
pydoris://<User>:<Password>@<Host>:<Port>/<Catalog>.<Database>
Example
It is recommended to use python 3.x to connect to the doris database, eg:
from sqlalchemy import create_engine
from sqlalchemy.schema import Table, MetaData
from sqlalchemy.sql.expression import select, text
engine = create_engine('doris://root:xxx@localhost:9030/hive_catalog.hive_db')
connection = engine.connect()
rows = connection.execute(text("SELECT * FROM hive_table")).fetchall()
Differences from Official Package
This custom build removes the sqlalchemy-utils dependency which is not actually used in the code.
Metadata
Release files for pydoris-custom 1.1.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| pydoris_custom-1.1.0.tar.gz | 7.5 kB | Without provenance | Details for pydoris_custom-1.1.0.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| pydoris_custom-1.1.0-py3-none-any.whl | Python 3 | none | any | Details for pydoris_custom-1.1.0-py3-none-any.whl |
Total release size: 16.5 kB
Release files / pydoris_custom-1.1.0.tar.gz
| Download URL | pydoris_custom-1.1.0.tar.gz |
|---|---|
| Size | 7.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
c15258d8115b50ed855bc3897b8cbb1639a5bbeb34861ce8662bacdde58ca155
|
|
BLAKE2b-256 checksum How to use checksums |
9f6705c9310aca1fbf315b7bdae4dbc32e241e53abff6e541d1b3ad1127c73fd
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.10.16
|
Release files / pydoris_custom-1.1.0-py3-none-any.whl
| Download URL | pydoris_custom-1.1.0-py3-none-any.whl |
|---|---|
| Size | 9.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
7dee602acfdae385e75692703ae1020d8e99d4244f40ad23a519cea8eab71fec
|
|
BLAKE2b-256 checksum How to use checksums |
0fed17899ca1e7a9051e29fea1de4f9fc2f3f51c4c430af212d7edcf3d758e1b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.10.16
|
Security for pydoris-custom 1.1.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.