Skip to main content

The Hive adapter plugin for dbt

Project description


The dbt-hive adapter allows you to use dbt along with Apache Hive and Cloudera Data Platform

Getting started


The initial adapter code was developed by bachng2017 who agreed to transfer the ownership and continute active development. This code base is now being activiely developed and maintained by Innovation Accelerator team in Cloudera.


Python >= 3.8

dbt-core ~= 1.1.0

impyla >= 0.18a5


Clone the repository

cd dbt-hive
pip3 install --user .

or install from pypip

pip3 install --user dbt-hive

Sample profile

  target: dev
    type: hive
    auth_type: LDAP
    user: [username]
    password: [password]
    schema: [schema]
    host: [hive-meta-store-host]
    port: 443
    http_path: [http-path]
    thread: 1

Supported features

Name Supported
Materialization: Table Yes
Materialization: View Yes
Materialization: Incremental - Append Yes
Materialization: Incremental - Insert+Overwrite Yes
Materialization: Incremental - Merge No
Materialization: Ephemeral No
Seeds Yes
Tests Yes
Snapshots No
Documentation Yes
Authentication: LDAP Yes
Authentication: Kerberos No

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbt-hive-1.1.1.tar.gz (22.0 kB view hashes)

Uploaded Source

Built Distribution

dbt_hive-1.1.1-py3-none-any.whl (31.6 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page