Connecting to Hive via SSH

Hello,

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.2.6.3.7-7)
Driver: Hive JDBC (version 1.2.1000.2.6.3.7-7)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.2.1000.2.6.3.7-7 by Apache Hive
jdbc:hive2://hosts:>

 

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!

Driver:

Connection General Tab:

SSH Settings:

 

1 comment

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 https://intellij-support.jetbrains.com/hc/en-us/community/posts/360000034784/comments/360000029784.

0

Please sign in to leave a comment.