Hive HA (HDP)

1. prerequisite
   1. The relational database that backs the Hive Metastore itself should also be made highly available using best practices defined for the database system in use
2. metastore
   1. ambari web -> services -> hive -> service antions -> add hive metastore -> choose host -> restart realted services
      
   2. install RDB client on the host where you installed hive metastore
      1. install MariaDB
      1. http://mungeol-heo.blogspot.kr/2015/07/mariadb.html
   3. RDB setting
      1. mysql -u root -p
      2. CREATE USER 'hive'@'bigdata-dev02.co.kr'IDENTIFIED BY 'hroqkf'; 
         1. be sure the hostname is the host where you installed hive metastore.
      3. GRANT ALL PRIVILEGES ON *.* TO 'hive'@'bigdata-dev02.co.kr'; 
      4. FLUSH PRIVILEGES;
         
3. hiveserver2
   1. ambari web -> services -> hive -> service antions -> add hiveserver2 -> choose host -> restart realted services
4. webhcat
   1. ambari web -> hosts -> click hostname -> add -> webhcat server -> restart realted services