06-23-2017 09:31 AM
I am totally lost , where do I have to place the MYSQL JDBC driver when my cluster is managed by cloduera manager . also I am in the middle of Cloudera manager installation where I mentioned to HIVE as to have a custom database .
I have downloaded and installed mysql database 5.7.8
created hive user and database metastore
gave all the permission to the user.
I am stuck up when it comes to placing the JDBC jar where do i place it so that Cloduera manager will recogonize other it complains saying JDBC driver not found in the host-name
Between also I dont see any usr/lib/hive directory being created .
i only see /etc/hive/conf
any help is highy appreciable
06-25-2017 11:27 PM
06-26-2017 06:30 AM
Sorry for the confusion , I am trying to make HIVE use mysql database as Metastore .
So I guess i need to say that it is mysql-connector-java.jar .
So having said that I should place that .jar file under /user/share/java / to make Cloduera manager recgonize and pick it up not complain . Correct me if I am wrong.
06-26-2017 02:01 PM
For Hive, it is the Hive Metastore server (and not Cloudera Manager) that needs access to the JDBC driver to talk to the database.
As mentioned in the documentation, JDBC driver needs to be installed on the Cloudera Manager Server host, as well as hosts to which you assign the Hive Metastore Server, Activity Monitor, Reports Manager, Hue Server, Sentry Server, Cloudera Navigator Audit Server, and Cloudera Navigator Metadata Server roles.
for details on the location.
06-27-2017 05:05 AM
07-14-2017 09:28 PM
Sorry for the brutal late response.
Could you clarify the below
1 . if I use The JDK that is included in the Cloudera Manager 5 repositories
Do i have to manually add JAVA_HOME in any of the Cloudera manager configuration files
if so where is the location of those files ?
2 . Thanks for the clarification on mysql driver on usr/share/java for HMS
3 . Thrid , I Would like to know if /usr/share/java is the location for HMS then could you tell me where should those mysql jdbc jar be placed for Cloudera manager to recogonize because i am plaining to have all those cloudera manager service like Activity Monitor, Reports Manager, Cloudera Navigator Audit Server, and Cloudera Navigator Metadata Server to be in mysql database not use the postgres database that ships along .
Thanks for any information its really going to help in my prod box.
07-16-2017 11:06 PM