Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

SQuirrel SQL Client can´t establish a session to Hive


SQuirrel SQL Client can´t establish a session to Hive

New Contributor

Hi, I´m trying to configure SQuirrel SQL Client to connect to Hive. Hive is running in a kerberized HDP cluster on RHEL. I have tested to add different Hive JDBC drivers but I cannot get SQuirrel to establish a successful SQL Connection. Currently I get the following error message in SQuirrel when I try to connect:

java.lang.NoSuchMethodError:org.apache.hadoop.hive.common.auth.HiveAuthUtils.getSocketTransport(Ljava/lang/String;II)Lorg/apache/hive/org/apache/thrift/transport/TTransport; at org.apache.hive.jdbc.HiveConnection.createUnderlyingTransport( at org.apache.hive.jdbc.HiveConnection.createBinaryTransport( at org.apache.hive.jdbc.HiveConnection.openTransport( at org.apache.hive.jdbc.HiveConnection.<init>( at org.apache.hive.jdbc.HiveDriver.connect( at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection( at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect( at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000( at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$ at java.util.concurrent.Executors$ at at java.util.concurrent.ThreadPoolExecutor.runWorker( at java.util.concurrent.ThreadPoolExecutor$ at

The connection URL´s that I have tested look like this: jdbc:hive2://<hostname>:10000/default;principal=hive/<hostname>@<REALM>;auth-kerberos



The software versions:

SQuirrel SQL Client (version 3.9.0)

HDP (version

Hive (version

It seems to be related to the JDBC driver. What .jar files and file versions should I use for the driver? Regards,