Hive

[amotl]

About

Apache Hive stores Hive Tables.

Details

There is an official SQLAlchemy dialect ¹ by CDATA, but that is not FOSS. However, we discovered sqlalchemy_hive.py ² by @jingw et al.

Footnotes

1. https://www.cdata.com/kb/tech/hive-python-sqlalchemy.rst ↩

2. https://github.com/apache/kyuubi/blob/master/python/pyhive/sqlalchemy_hive.py ↩

[amotl]

Information about how to use Hive with Docker is available here.

• https://hive.apache.org/development/quickstart/
• https://github.com/apache/hive/blob/master/packaging/src/docker/docker-compose.yml

docker run --rm --name hive4 -p 10000:10000 -p 10002:10002 --env SERVICE_NAME=hiveserver2 apache/hive:4.2.0
docker exec -it hive4 beeline -u 'jdbc:hive2://localhost:10000/'