Design and Manage Apache Hive Databases Visually with DbSchema

DbSchema lets you design, manage, and document Apache Hive databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the Apache Hive database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

DbSchema Database Designer

Download DbSchema Download Apache Hive JDBC Driver

Desktop GUI for Apache Hive Data Warehouse Schemas

Apache Hive organizes Hadoop HDFS data into databases, tables, and partitions stored in the Hive metastore. While Hive supports a SQL-like query language (HiveQL), navigating the metastore and understanding the full schema structure typically requires beeline or a Hue web interface. DbSchema connects to Hive via HiveServer2 and provides a desktop GUI for visualizing the metastore schema, running HiveQL queries, and generating documentation for the whole data warehouse team.

Visual Schema Explorer for the Hive Metastore

DbSchema reads the Hive metastore through the HiveServer2 JDBC interface and presents databases, tables, partitions, and column definitions as an interactive schema diagram. Data engineers and analysts can quickly explore the Hive schema structure without using the beeline CLI or Hue.

Building HiveQL queries visually against Apache Hive tables in DbSchema

Browse Hive Table Data Interactively

DbSchema's data explorer connects to HiveServer2 and lets you browse table contents, apply column filters, and paginate through results from any Hive table. This gives analysts a quick way to inspect data without writing full HiveQL SELECT statements for every table inspection task.

Browsing Apache Hive table data in DbSchema's data explorer

HiveQL Editor for Data Warehouse Queries

The DbSchema SQL editor supports HiveQL syntax, including partitioned table queries, ORC/Parquet format hints, and Hive-specific functions. Run HiveQL queries against your cluster and inspect result sets from a desktop client — no need to maintain a Hue or Zeppelin notebook for every ad-hoc query.

Running HiveQL queries in DbSchema's SQL editor connected to Apache Hive

Connecting DbSchema to Apache Hive

HiveServer2 listens on port 10000 by default. The JDBC URL for a standard connection is: jdbc:hive2://host:10000/default. For Kerberized clusters, use: jdbc:hive2://host:10000/default;principal=hive/host@REALM. Download the Hive JDBC driver bundle (hive-jdbc-*.jar plus its dependencies) from the Hive distribution or Maven Central, then add it via DbSchema's driver manager. For CDH or HDP deployments, use the vendor-provided JDBC driver from Cloudera or Hortonworks for best compatibility.

Why DbSchema for Apache Hive

  • Explore the Hive metastore schema visually without beeline or Hue
  • Run HiveQL queries from a desktop client with result set browsing
  • Document Hive data warehouse schemas for BI and analytics teams
  • Browse Hive table data interactively with filtering and pagination
  • Connect to both Kerberized and standard HiveServer2 instances