Download Hive JDBC Driver
Download the Hive JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.
About the Hive JDBC driver
A JDBC driver is a Java .jar library that lets applications connect to Hive.
DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation.
Driver files are usually published by the database vendor or an open-source project.
JDBC URL format
Host, port, database name, and SSL options are passed in a URL starting with jdbc:.
Each Hive driver uses its own syntax — see the connection details below.
The Hive JDBC driver
Apache Hive is a data warehouse system built on Hadoop, enabling SQL-like queries (HiveQL) over large datasets stored in HDFS or cloud object storage. It is widely used for batch ETL processing, data lake querying, and as a metastore for Spark and Presto/Trino workloads.
We use the Hive Uber driver. The JDBC source code is located on https://github.com/timveil/hive-jdbc-uber-jarThe driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.
DbSchema and Apache Hive
DbSchema connects to Hive via the Hive Uber JDBC driver and renders Hive tables, partitions, and views in the schema diagram. Use the SQL Editor to write HiveQL with partition filters and bucketing hints for optimal query performance.
Test the driver with DbSchema
Connect Hive, build your first ER diagram in minutes. No account required.
Download driver & DbSchema
Get the Hive driver zip below and install DbSchema for Windows, macOS, or Linux.
Register the .jar
In DbSchema, open Driver Manager, add the extracted JAR, and paste your JDBC URL.
Design & document
Reverse engineer Hive, edit the model visually, and publish schema documentation.
Use Hive visually in DbSchema
After the JDBC driver connects, you get ER diagrams, SQL editor, schema sync, and HTML documentation in one desktop app. Compare DbSchema editions.
ER diagrams
Reverse engineer Hive into an interactive diagram and edit structures visually.
SQL & query builder
Run SQL with autocomplete or compose queries without writing every join by hand.
Schema documentation
Export HTML docs your team can browse without installing DbSchema.
Full Hive guide
Connection tips, ports, SSL, and schema design workflows on the database landing page.
Related JDBC drivers
Other drivers teams often configure alongside Hive.
Apache Drill JDBC
Apache Druid JDBC
Apache Ignite JDBC
Apache Pinot JDBC
Apache Solr JDBC
Dremio JDBC
Related databases
Teams working with Hive often use these engines too. Explore dedicated guides and JDBC setup for each.