Hive installation (HDP)

1. mysql-connector-java (skip this step if you have installed it at 'HDP 2.3 installation')
   1. 2015.07.28 -> HDP 2.3 installation -> mysql-connector-java
   2. ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar
2. RDB configuration
   1. mysql -u root -p
   2. CREATE USER ‘hive’@’localhost’ IDENTIFIED BY ‘hroqkf’;
   3. GRANT ALL PRIVILEGES ON *.* TO 'hive'@'localhost'; 
   4. CREATE USER ‘hive’@’%’ IDENTIFIED BY ‘hroqkf’; 
   5. GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%'; 
   6. CREATE USER 'hive'@'bigdata-dev03.co.kr'IDENTIFIED BY 'hroqkf'; 
      1. be sure the hostname is the host where you installed hive metastore.
   7. GRANT ALL PRIVILEGES ON *.* TO 'hive'@'bigdata-dev03.co.kr'; 
   8. FLUSH PRIVILEGES;
   9. CREATE DATABASE hive;
3. ambari web -> add service -> choose hive and tez -> assign masters -> assgin slaves and clients
4. customize services
1. hive -> advanced -> hive metastore -> hive database -> existing mysql database -> database host, database name, username, password -> test connection
5. configure identities -> review -> install, start and test -> summary -> complete