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
Gateway |
Master101 |
Hive Metastore |
Master101 |
WebHcat Server |
Master101 |
HiveServer2 |
Master101 |