Hive Installation (HDP)

• MySQL 5.6
  • CREATE USER 'hive'@'localhost' IDENTIFIED BY 'bigdata';
  • GRANT ALL PRIVILEGES ON *.* TO 'hive'@'localhost';
  • CREATE USER 'hive'@'%' IDENTIFIED BY 'bigdata';
  • GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%';
  • CREATE USER 'hive'@'test.com' IDENTIFIED BY 'bigdata';
    • be sure the hostname is the host where you installed hive metastore
  • GRANT ALL PRIVILEGES ON *.* TO 'hive'@'test.com';
  • FLUSH PRIVILEGES;
• ambari web -> add service -> choose hive and tez -> assign masters -> assgin slaves and clients
• customize services
  • hive -> advanced -> hive metastore -> hive database -> existing mysql database -> database host, database name, username, password -> test connection
• configure identities -> review -> install, start and test -> summary -> complete