---
id: apache-airflow-providers-apache-hive
version: "9.6.1"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# apache-airflow-providers-apache-hive — Provider package apache-airflow-providers-apache-hive for Apache Airflow

License: permissive · Maintenance: active · Downloads: 385.5K/mo

## What it is and what it does

This is an Apache Airflow provider package that adds Hive support to Airflow workflows. It supplies operators, hooks, and sensors for executing Hive queries, managing Hive tables, and integrating Hive metastore operations into Airflow DAGs. The package wraps pyhive and hmsclient to communicate with Hive servers and the Hive metastore.

You install it on top of an existing Airflow installation (>=2.11.0) to gain the ability to define Hive tasks in your workflows. It requires pandas, jmespath, and the common Airflow provider compatibility layers. Optional extras allow integration with cloud storage (amazon), other databases (mysql, presto, vertica, mssql), and Kerberos authentication (GSSAPI).

Use it for:

- Execute Hive SQL queries as tasks within Airflow DAGs for ETL pipelines
- Query and manage Hive tables as part of scheduled data workflows
- Integrate Hive metastore operations into multi-step Airflow orchestrations
- Build data pipelines that move data between Hive and other systems via Airflow
- Monitor and log Hive query execution within Airflow's centralized task tracking

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Integrates Apache Hive with Apache Airflow, enabling Hive query execution and data operations within Airflow workflows.

Yes, if you run Airflow and need to orchestrate Hive workloads. The package is actively maintained, carries no known vulnerabilities, installs with low friction, and is licensed permissively. It is a standard Airflow provider with production-stable status. Install it only if Hive integration is part of your data pipeline strategy.

## Install

pip install apache-airflow-providers-apache-hive
uv add apache-airflow-providers-apache-hive
poetry add apache-airflow-providers-apache-hive

## Installing apache-airflow-providers-apache-hive

Before you install: Low install friction; distributed as a wheel. Requires apache-airflow >=2.11.0 and six runtime dependencies including hmsclient and pyhive. Actively maintained with a release 6 days old.

License in practice: Apache-2.0 (permissive): you can use, modify, and distribute this package freely in commercial and private projects, provided you retain license notices and include a copy of the license.

Quickstart:

pip install apache-airflow-providers-apache-hive

from airflow.providers.apache.hive.operators.hive import HiveOperator
from airflow import DAG

with DAG('hive_example') as dag:
    hive_task = HiveOperator(
        task_id='run_hive_query',
        hql='SELECT * FROM my_table LIMIT 10',
        hive_cli_conn_id='hive_default'
    )

Requires an existing Airflow installation (>=2.11.0) and a running Hive server with a configured Airflow connection.

Verify before relying:

- Whether optional cross-provider extras (amazon, mysql, presto, etc.) are commonly needed for typical Hive workflows
- Performance characteristics when executing large Hive queries through Airflow
- Specific Hive metastore compatibility or known limitations with particular Hive versions

## Package facts

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 385.5K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

airflow hive provider, airflow hive integration, hive sql tasks airflow, apache hive airflow operator, hive metastore airflow, hive data pipeline airflow, airflow hive connector, airflow-provider, hive-integration, data-orchestration

[View on SkillFed](https://skillfed.io/packages/apache-airflow-providers-apache-hive) · [View on PyPI](https://pypi.org/project/apache-airflow-providers-apache-hive/)