05-06-2017 05:41 AM
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?
05-06-2017 06:57 PM - edited 05-06-2017 06:58 PM
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
copy the connector jar to the Hive lib folder
05-08-2017 05:32 PM - edited 05-08-2017 05:36 PM
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
05-08-2017 09:07 PM
05-10-2017 04:08 AM
"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.