Skip to main content

The Hive adapter plugin for dbt

Project description

dbt-hive

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

Getting started

Credits

The initial adapter code was developed by bachng2017 who agreed to transfer the ownership and continue active development. This code base is now being actively developed and maintained by Cloudera.

Requirements

Current version of dbt-hive use dbt-core 1.7.*. We are actively working on supporting the next version of dbt-core 1.8

Python >= 3.8 dbt-core ~= 1.7.* impyla >= 0.18

Install

pip3 install --user dbt-hive

Sample profile

demo_project:
  target: dev
  outputs:
  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 Iceberg
Materialization: View Yes N/A
Materialization: Table Yes Yes
Materialization: Table with Partitions Yes Yes
Materialization: Incremental - Append Yes Yes
Materialization: Incremental - Append with Partitions Yes Yes
Materialization: Incremental - Insert+Overwrite with Partitions Yes No
Materialization: Incremental - Merge Yes Yes
Materialization: Incremental - Merge with Partitions No Yes*
Materialization: Ephemeral No No
Seeds Yes Yes
Tests Yes Yes
Snapshots No No
Documentation Yes No
Authentication: LDAP Yes Yes
Authentication: Kerberos Yes Yes

Incremental

Incremental models are explained in dbt documentation. This section covered the details about the incremental strategy supported by the dbt-hive.

Strategy ACID Table Iceberg Table
Incremental Full-Refresh Yes Yes
Incremental Append Yes Yes
Incremental Append with Partitions Yes Yes
Incremental Insert Overwrite Not recommended without Partitions* Not recommended without Partitions*
Incremental Insert Overwrite with Partitions Yes No
Incremental Merge Yes Yes* (only v2)
Incremental Merge with Partitions No* Yes* (only v2)

Note*:

  1. Incremental Insert overwrite without the partition columns results into completely overwriting the full table and may result in the data-loss. Hence it is not recommended to used. This can happen for Hive ACID, Iceberg v1 & v2 tables.
  2. Incremental Merge for iceberg v1 table is not supported because Iceberg v1 tables are not transactional.
  3. Incremental Merge with partition columns is not supported because Hive ACID tables doesn't support updating values of partition columns.

Support for On-Schema Change strategy in dbt-hive:

Strategy ACID Table Iceberg Table
ignore (default) Supported Supported
fail Supported Supported
append_new_columns Adds new columns Adds new columns
sync_all_columns Adds new columns and updates datatypes but doesn't remove existing columns Adds new columns, updates datatypes and removes existing columns

Tests Coverage

Functional Tests

Name Base Iceberg
Materialization: View Yes N/A
Materialization: Table Yes Yes
Materialization: Table with Partitions Yes Yes
Materialization: Incremental - Append Yes Yes
Materialization: Incremental - Append with Partitions Yes Yes
Materialization: Incremental - Insert+Overwrite with Partitions Yes No
Materialization: Incremental - Merge No No
Materialization: Ephemeral No No
Seeds Yes Yes
Tests Yes Yes
Snapshots No No
Documentation Yes No
Authentication: LDAP Yes Yes
Authentication: Kerberos Yes Yes

Note: Kerberos is only qualified on Unix platform.

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.7.0.tar.gz (33.9 kB view hashes)

Uploaded Source

Built Distribution

dbt_hive-1.7.0-py3-none-any.whl (54.2 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