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

HIVE with DBVisualiser or SQuirrel SQL client

HIVE with DBVisualiser or SQuirrel SQL client

Contributor

Error : An error occured while establishing the connection. Type: java.lang.NoClassDefFoundError Message: org/apache/http/config/Lookup

Which jar file is missing?

  • commons-codec-1.4.jar
  • commons-collections-3.2.1.jar
  • commons-configuration-1.6.jar
  • commons-lang-2.6.jar
  • commons-logging-1.1.3.jar
  • guava-11.0.2.jar
  • hadoop-common-2.4.0.2.1.7.0-784.jar
  • hive-common-0.13.0.2.1.7.0-784.jar
  • hive-jdbc-0.13.0.2.1.7.0-784.jar
  • hive-service-0.13.0.2.1.7.0-784.jar
  • httpclient-4.2.5.jar
  • httpcore-4.2.5.jar
  • libthrift-0.9.0.jar
  • log4j-1.2.16.jar
  • slf4j-api-1.7.5.jar
  • slf4j-log4j12-1.7.5.jar
18 REPLIES 18

Re: HIVE with DBVisualiser or SQuirrel SQL client

Re: HIVE with DBVisualiser or SQuirrel SQL client

Re: HIVE with DBVisualiser or SQuirrel SQL client

Contributor

@Neeraj @Ancil McBarnett Thanks for your inputs! I was already looking at the solutions provided here but still getting different new errors

I was able to successfully register the driver but problem arises when I connect to Hive

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.RuntimeException: Illegal Hadoop Version: Unknown (expected A.B.* format) at java.util.concurrent.FutureTask.report(Unknown Source) at

2186-jars.png

Re: HIVE with DBVisualiser or SQuirrel SQL client

Contributor

this is what I use in command line

beeline -u "jdbc:hive2://<HIVESERVER>:10000/default;principal=hive/_HOST@XXXX"

Re: HIVE with DBVisualiser or SQuirrel SQL client

@AR

Try this

Are you using this for kerberos?

HDP 2.3

You'll only need 2 jar files for the JDBC Client with HDP 2.3

# From /usr/hdp/current/hive-client hive-jdbc.jar (should be a symlink to the hive-jdbc-xxx-standalone.jar) # From /usr/hdp/current/hadoop-client hadoop-common.jar (hadoop-common-....jar)

Re: HIVE with DBVisualiser or SQuirrel SQL client

@AR FYI : I just test dbvisualizer and it worked with only above jars

2187-screen-shot-2016-02-16-at-34215-pm.png

2188-screen-shot-2016-02-16-at-34347-pm.png

Re: HIVE with DBVisualiser or SQuirrel SQL client

Contributor

@ Neeraj thanks again for the screenshot ...are you connecting to the secured cluster?

Not sure how to connect with kerberised cluster (i mean using keytabs (hive principals) ?

Am getting this error:

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Could not open client transport with JDBC Uri:

Peer indicated failure: Unsupported mechanism type PLAIN at java.util.concurrent.FutureTask.report(Unknown Source)

Re: HIVE with DBVisualiser or SQuirrel SQL client

No but try this

jdbc url: jdbc:hive2://hs2:10000/default;principal=hive/hs2@realm

Should add auth.jar

MIT client ---> Get the ticket from KDC

Re: HIVE with DBVisualiser or SQuirrel SQL client

Contributor
@Neeraj Sabharwal

Thanks Neeraj...let me try

Don't have an account?
Coming from Hortonworks? Activate your account here