Tool list · Data governance

    Best 20 Data Catalog, Lineage & Governance Tools for Hive SQL (2026)

    Discover the 20 best open-source and managed data catalog, data lineage, and data governance tools for Hive SQL: how each one catalogs Hive SQL metadata, traces table and column lineage, and governs access. 19 trace column-level lineage.

    By Ari Bajo - data engineer turned writer.

    Updated on November 16, 2026

    Tools list

    Collibra

    AI control plane for data and AI governance that connects to Hive through a JDBC connection on Edge with a Technical Lineage for Hive capability, or parses HiveQL files from storage, for data lineage.

    My Opinion

    Best for enterprises with Hive on Hadoop that want HiveQL lineage stitched to downstream warehouses and BI.

    Collate

    Managed enterprise data platform built on OpenMetadata that connects to HiveServer2 with LDAP or Kerberos, or reads a MySQL or Postgres metastore directly, ingests schemas and tables, builds data lineage, and profiles tables.

    My Opinion

    Best for Hadoop-era Hive estates that want a managed catalog with lineage and a hybrid runner behind Kerberos.

    Informatica IDMC by Salesforce

    AI-powered data management cloud from Salesforce that extracts Hive databases, tables, external tables and views into its data catalog through the Hive connector, and profiles external tables stored as Avro, Parquet, JSON or delimited files.

    My Opinion

    Best for Hadoop estates that want Hive external tables profiled and classified before or during a move to the cloud.

    Alation

    Data intelligence platform that catalogs Hive 2 and 3 schemas, tables, views and columns over Kerberos, ZooKeeper or basic connections, and ingests file-based query logs for popularity and table-level data lineage.

    My Opinion

    Best for Kerberized Hadoop-era Hive estates that want usage and table-level lineage from query log files in an enterprise catalog.

    Atlan

    Context layer for AI built on a data catalog that connects to HiveServer2 with Kerberos or password auth, directly or via a self-deployed runtime, and crawls Hive databases, tables, views, materialized views and columns.

    My Opinion

    Best for Kerberized on-premises Hadoop clusters that need Hive tables in the same catalog as cloud warehouses.

    DataHub Cloud

    Managed SaaS platform built on DataHub Core that runs Hive ingestion from a remote executor inside on-premises networks, maps view and storage data lineage, and adds schema assertions with Slack or Teams alerts.

    My Opinion

    Best for on-premises Hive estates that need a managed catalog without opening HiveServer2 to the internet.

    OvalEdge

    Unified data governance platform that crawls Hive schemas, tables, views and columns over JDBC, profiles data, offers a query sheet and data preview, and builds automatic data lineage alongside manual lineage.

    My Opinion

    Best for Hive users who want profiling and data preview next to lineage, with connection credentials kept in a credential manager.

    Ataccama ONE

    Data trust platform with a data catalog and data quality rules that catalogs Apache Hive 3.1 and 4.x for its Spark processing engine, and connects ONE Desktop to Cloudera Hive over JDBC with Kerberos.

    My Opinion

    Best for Cloudera Hadoop shops that need data quality processing on Hive tables via Spark.

    Dawiso

    Data catalog and AI context layer that connects to HiveServer2, runs SHOW and DESCRIBE to catalog databases, tables, views, partitions and UDFs with storage details, and derives view-level data lineage from view definitions.

    My Opinion

    Best for Hadoop data lakes on Hive 3 or 4 that want SerDe, location and partitioning details visible without opening Beeline.

    Data.World by ServiceNow

    Enterprise data catalog and knowledge graph platform that runs an on-premises collector with username and password auth to harvest Hive tables with size and row stats, view SQL, and view column lineage.

    My Opinion

    Best for Hadoop teams that can run a collector inside the network; a separate Hive Metastore collector also exists.

    Secoda by Atlassian

    AI platform for data and analytics built on a governance catalog that reads Apache Hive through HiveServer2 or a MySQL metastore, adding tables and columns with types and comments to the data catalog.

    My Opinion

    Best for Hadoop teams that can't expose HiveServer2 but can grant read access to the MySQL metastore; the docs list no Hive lineage.

    Entropy Data

    Data product marketplace that uses an open-source Hive connector, shipped as a Docker image, to sync Hive Metastore schemas and tables into its data catalog and apply Hive permissions when access is approved.

    My Opinion

    Best for Hive teams that want data product access approvals enforced as Hive permissions.

    Anjana Data

    Data and AI governance platform that connects to Hive over JDBC, including Kerberos-secured Cloudera CDH 6 and CDP 7 clusters, imports tables and columns into its data catalog, and samples data with masking.

    My Opinion

    Best for on-premises Cloudera Hadoop estates that need a self-hosted governance catalog with Kerberos support.

    Semarchy

    Multi-domain MDM platform that connects to Hive through Semarchy xDI, its data integration product, which reverse-engineers Hive databases into xDI metadata, loads through HDFS or Sqoop, and supports Kerberos, for MDM flows.

    My Opinion

    Best for Hadoop teams that still feed or consume master data through Hive tables on a Kerberized cluster.

    IBM Knowledge Catalog

    Data catalog and governance layer of IBM watsonx.data Intelligence that imports Hive tables for enrichment and quality rules, and runs a lineage import over JDBC that reads the Hive metastore, views and HiveQL scripts.

    My Opinion

    Best for Hadoop estates that want HiveQL lineage and quality rules, except on FIPS-compliant deployments where Hive lineage import is not supported.

    OpenMetadata

    Open-source unified metadata platform that connects to Hive with LDAP or Kerberos, or through a MySQL or Postgres metastore, ingests schemas and tables into its data catalog, and runs profiler and data quality tests.

    My Opinion

    Best for Hive and Hadoop teams that want an open-source data catalog with self-hosted ingestion near the cluster.

    DataHub Core

    Open-source context platform for data and AI agents that connects to HiveServer2, ingests databases, tables and views, builds view and column-level data lineage, and can emit lineage to underlying storage paths.

    My Opinion

    Best for Hadoop teams that want Hive views traced to their storage locations in a self-hosted open-source catalog.

    Solidatus

    Data lineage platform whose JDBC connector, with a separately added Hive driver, extracts Hive schemas, tables, views and columns, and parses scripts and view definitions for column-level lineage.

    cataloglineagecompliance
    My Opinion

    Best for Hadoop estates that need Hive view and script lineage tied into enterprise lineage models before or during migration.

    Foundational

    Data control plane that reads the Hive Metastore's PostgreSQL database with a read-only user, lists databases, tables and columns, and adds them to its data lineage and downstream impact analysis without touching table data.

    My Opinion

    Best for Hadoop teams with Spark or HiveQL code in Git that run their Hive Metastore on PostgreSQL.

    Oracle Cloud Infrastructure (OCI) Data Catalog

    Managed metadata catalog for Oracle Cloud that harvests Apache Hive and Cloudera CDH 5.4+ databases, tables and columns into a data catalog, and also offers its own Hive-compatible metastore for Spark jobs on Oracle Cloud.

    Oracle-nativecatalog
    My Opinion

    Best for Hadoop or Cloudera users moving Hive workloads to Oracle Cloud who want one metastore and catalog.

    Evaluating data tools in 2026?

    I curate the most comprehensive lists of data tools, up-to-date comparison tables, and actionable market guides for data teams. More useful than a Gartner report. More reliable than asking AI. Next up: Data FinOps.

    By Ari Bajo - data engineer turned writer.

    Compare data governance tools

    The guide and the comparison tables behind this list.

    How I check every fact

    Checked against vendor docs

    I check each feature, integration and price against the vendor's docs, pricing page or GitHub repository, and link the fact to that source.

    Open to vendor corrections

    Vendors and users can send corrections. I verify them against the docs before changing anything, and every page shows when it was last updated.

    Spot a mistake? Send a correction →

    Frequently Asked Questions

    Does Hive SQL have its own data catalog?
    Partly: the Hive Metastore stores table schemas, and on Cloudera, Apache Atlas adds classification and lineage on top. Both are technical tools. The catalogs on this page read the Hive Metastore and add search, ownership, and lineage across the rest of your stack. Read more on my data quality tool market guide.
    Which data catalog tools trace column-level lineage for Hive SQL?
    19 of the 20 tools on this page support column-level lineage in our feature matrix: Collibra, Collate, Informatica IDMC by Salesforce, Alation, Atlan, DataHub Cloud, OvalEdge, Ataccama ONE, Dawiso, Data.World by ServiceNow, Secoda by Atlassian, Anjana Data, Semarchy, IBM Knowledge Catalog, OpenMetadata, DataHub Core, Solidatus, Foundational, and Oracle Cloud Infrastructure (OCI) Data Catalog. Check each tool's Hive SQL docs (linked on its card) for which Hive SQL objects it parses.
    Which open-source data catalogs work with Hive SQL?
    OpenMetadata and DataHub Core are open source and connect to Hive SQL. More options are on the open-source data governance tools list.
    How can I edit this tools list?
    If you think a tool belongs here or you want to suggest an edit, I would love to hear from you. You can fill out the feedback form or DM on LinkedIn.