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
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: