CCA131 : Task Scenario-27

Problem Scenario 27: You have been given below information. You need to setup Hive Service on CDH cluster. You have to use MySQL as a metastore RDBMS database and not PostGreSQL embedded database.

-          MySQL Repo File

http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

-    Update Command for Repo

sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

yum update

-    Also install MySQL Java Connector

mysql-connector-java

-    Enable MySQL secure connection : mysql_secure_installation

-    Assign nodes as below