---
name: Apache Hive
menu: Connecting to Databases
route: /docs/databases/hive
index: 6
version: 1
---

## Apache Hive

The [pyhive](https://pypi.org/project/PyHive/) library is the recommended way to connect to Hive through SQLAlchemy.

The expected connection string is formatted as follows:

```
hive://hive@{hostname}:{port}/{database}
```
