How to connect to Hive database

The Connection Dialog and the fields available there ( host, port, user, database, SSH ) are explained in the Connection dialog page.

DbSchema connects to Hive using the driver from https://github.com/timveil/hive-jdbc-uber-jar

Firewalls & anti-viruses may block database connections. Read How to enable Firewall connections.

You may connect to Hive using Kerberos authentication using the steps described in this article.

To set Java parameters like describe in the article edit the DbSchema.vmoptions file from the same folder as DbSchema.exe:

-Dsun.security.krb5.debug=true
-Djavax.security.auth.useSubjectCredsOnly=false
-Djava.security.krb5.conf="[path-to-kerberos-file]/krb5.ini"

How to Connect to Hive