Error connecting to Hive using JayDeBeApi - Class not found

Question

I am trying to connect to my Hive server using JDBC connection.

I've the following JAR file in my JAVA_HOME:

HIVEJDBC41.jar
hadoop-common.jar

But when I run my code jaydebeapi.connect('org.apache.hive.jdbc.HiveDriver', url)

It gives me the following error:

raise _RUNTIMEEXCEPTION.PYEXC("Class %s not found" % name)
jpype._jexception.RuntimeExceptionPyRaisable: java.lang.RuntimeException: Class org.apache.hive.jdbc.HiveDriver not found

Note: My connection needs to be using JDBC connection.

Anyone knows what I am missing?

Which version of Hive you are using ? – Uday Chauhan May 01 '20 at 12:14 — Uday Chauhan, May 01 '20 at 12:14
currently, it's the latest version 2.3.7 – Pedro Alves May 01 '20 at 14:06 — Pedro Alves, May 01 '20 at 14:06

score 0 · Accepted Answer · answered May 01 '20 at 14:31

0

There is mismatch of JDBC jar version

try hive-jdbc 2.3.7

answered May 01 '20 at 14:31

Uday Chauhan

1,071
1
9
19

It still gives the same error :( The Jar must be on the JAVA_HOME directory, right? Or it must on same folder as Python script? – Pedro Alves May 01 '20 at 15:31
Add the jar into your classpath of project – Uday Chauhan May 01 '20 at 15:45

Error connecting to Hive using JayDeBeApi - Class not found

1 Answers1