How to Connect to Hive

Connecting to the database will require to enter the host, port, database user and password as explained in the Connection Dialog.

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.

Connect using Kerberos Authentication

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"