Connecting to Hive via SSH


Usually in my everyday work in order to query our Kerberized Hive Cluster I'm using puTTY.

The way i do that is quite simple:

1. Connecting to Host with the following information: host:22

2. Once to window pops I'm asked for my login and than password so I enter it


3. Pasting jdbc url: beeline -u "jdbc:hive2://hosts:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2"

4. After few seconds I'm connected to the cluster and I'm able to query Hive tables

Connecting to jdbc:hive2://hosts:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Connected to: Apache Hive (version 1.2.1000.
Driver: Hive JDBC (version 1.2.1000.
Beeline version 1.2.1000. by Apache Hive


To make this experience more user friendly I tried to use Data Grip to do the same, but I'm having some issues.

I downloaded Hive Driver and created a connection with ssh tunnel. Below you can find my settings and an error. SSH URL and JDBC are for sure valid. Tried JDBC URL with both beeline and without as seen below. Any ideas how can I tackle this? Thanks!


Connection General Tab:

SSH Settings:


1 comment
Comment actions Permalink

You do not have URL template defined for the custom JDBC driver. It is needed for IDE to find the host/port/database from the URL Please check


Please sign in to leave a comment.