Support Questions
Find answers, ask questions, and share your expertise

couldn't find /usr/lib/hive/lib for mysql connector jar file

Solved Go to solution
Highlighted

couldn't find /usr/lib/hive/lib for mysql connector jar file

Rising Star

Dear all,

 

I installed cloudera 5.11 using Path A installation with Hive and sparks, I am trying to set up external database by following the guide for metastore external database setup, however I couldn't find the path to store the mysql connector jar file, has anyone face the same issue before?

 

https://www.cloudera.com/documentation/enterprise/5-8-x/topics/cdh_ig_hive_metastore_configure.html

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: couldn't find /usr/lib/hive/lib for mysql connector jar file

Rising Star

I think I found the folder in Ubuntu, it is under /usr/share/cmf/common_jars, the mysql-connector-java-5.1.15.jar is there already.

 

View solution in original post

7 REPLIES 7
Highlighted

Re: couldn't find /usr/lib/hive/lib for mysql connector jar file

Champion

@yongie

 

The default path to store mysql connector is /usr/share/java/

Highlighted

Re: couldn't find /usr/lib/hive/lib for mysql connector jar file

Rising Star

I have found the mysql connector jar file under /usr/share/java but /usr/lib/hive/lib doesn't seem to be in the system.

Highlighted

Re: couldn't find /usr/lib/hive/lib for mysql connector jar file

Champion

 

You can create a soft link for connector in the hive library directory 

 

ln -s /usr/share/java/mysql-connector-java.jar $HIVE_HOME/lib/mysql-connector-java.jar

or 

 

copy the connector jar to the Hive lib  folder 

 

 

 

 

Highlighted

Re: couldn't find /usr/lib/hive/lib for mysql connector jar file

Rising Star

I think I found the folder in Ubuntu, it is under /usr/share/cmf/common_jars, the mysql-connector-java-5.1.15.jar is there already.

 

View solution in original post

Highlighted

Re: couldn't find /usr/lib/hive/lib for mysql connector jar file

Champion

Yes it comes by default APT package   5.5 and 5.6 version 

I heard there are some issue with 5.5 OS comptability I might be wrong but upgrade to 5.6 if you want 

 

*** Removing the old 
sudo apt-get purge mysql-server-5.5 mysql-client-5.5
 
sudo apt-get autoremove


*** Installing the new 
 sudo apt-get install mysql-server-5.6 mysql-client-5.6

 

 

Highlighted

Re: couldn't find /usr/lib/hive/lib for mysql connector jar file

Rising Star
Thanks for the information, will upgrade as soon as possible, at the mean time I am still exploring how to get external DB done on hive, oozie and those monitoring DB
Highlighted

Re: couldn't find /usr/lib/hive/lib for mysql connector jar file

Champion

"I am still exploring how to get external DB done on hive, oozie and those monitoring DB "

 

Can you please elborate more sorry , I can certainly give you more information.