Connecting to Apache Hive

For information on the available WHL and TAR.GZ files for supported environments, and how to install the appropriate file for your Python distribution, see Package Installation.

For information on the module to import, and how to configure the necessary connection properties in a connection string, see Establishing a Connection.

Other available connection properties can be used to configure other aspects of the connector capabilities.

Python Version Support

The CData Python Connector for Apache Hive can be installed and used in various Python 3.8, 3.9, 3.10, and 3.11 distributions.

Apache Hive Version Support

The connector models Apache Hive instances as relational databases. Hive versions 0.11.0 and above are supported. The connector leverages the HiveServer2 Thrift API, to enable bidirectional access to Apache Hive data through SQL.

See Also

• Using the Connector: Establish connections and query Apache Hive through Python code.
• From SQLAlchemy: Use SQLAlchemy to establish a connection with dialect URL, and interact with Apache Hive data using mapped classes and Sessions.