The SQLAlchemy is the Python SQL Toolkit and Object Relational Mapper. The primary purpose of this is to have a working dialect for Qubole Presto and Hive that can be used with Apache Superset. This uses Qubole JDBC driver to connect to Qubole Presto/Hive.
Prerequisites
JDK 8 or later
Python 3.x
Installation
Download the Qubole JDBC driver (version 2.3 or later) from here
Set the environment variable QUBOLE_JDBC_JAR_PATH pointing to JDBC JAR location with absolute path
Example:
export QUBOLE_JDBC_JAR_PATH=/Users/testuser/qubolejdbc/qds-jdbc-2.3.0.jar
Install the sqlalchemy-qubole package. The package is available on PyPI
$ pip install sqlalchemy-qubole
Note: Ensure pip is pointing to Python3 OR use pip3 instead as this package supports Python 3.x version
Example of SQLAlchemy URIs to connect to Qubole
Presto Dialect:
qubole+presto://presto/presto_cluster?endpoint=https://api.qubole.com;password=<API-TOKEN>;catalog_name=hive
Hive Dialect:
qubole+hive://hive/hadoop2?endpoint=https://api.qubole.com;password=<API-TOKEN>
Default Dialect: By default, Qubole dialect points to presto.
qubole://presto/presto_cluster?endpoint=https://api.qubole.com;password=<API-TOKEN>;catalog_name=hive
Reporting Bugs
Want to report a bug or request a feature? Please contact Qubole Support.
1 maintainer
Metadata
1 maintainer
Release files for sqlalchemy-qubole 1.0.8
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sqlalchemy_qubole-1.0.8.tar.gz | 7.0 kB | Details |
Release files / sqlalchemy_qubole-1.0.8.tar.gz
| Download URL | sqlalchemy_qubole-1.0.8.tar.gz |
|---|---|
| Size | 7.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
9151c4fe301f1e0c98a64f966c78044a44efadaef62fe3d00314626e633ce848
|
|
BLAKE2b-256 checksum How to use checksums |
6ea2feda32ddedb4da6bb18abb2f2a8cbc99d9d4d9c0f7fa65785151b0d18518
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.8.8
|
