How-to: Install hive with mysql metastore

本篇文章主要介绍了"How-to: Install hive with mysql metastore"，主要涉及到方面的内容，对于MySql感兴趣的同学可以参考一下： Install mysqlInstall mysql connector:$ curl -L 'http://www.mysql.com/get/Downloa...

1. Install mysql
2. Install mysql connector:
   $ curl -L 'http://www.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.31.tar.gz/from/http://mysql.he.net/' | tar xz
   $ sudo cp mysql-connector-java-5.1.31/mysql-connector-java-5.1.31-bin.jar ${HIVE_HOME}/lib/
3. Create database and user:
   mysql> CREATE DATABASE metastore;
   mysql> USE metastore;
   mysql> SOURCE ${HIVE_HOME}/scripts/metastore/upgrade/mysql/hive-schema-0.13.0.mysql.sql;
4. Grant to hive user(hive is user and metastorehost is hive node hostname):
   mysql> CREATE USER 'hive'@'metastorehost' IDENTIFIED BY 'mypassword';
   mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'hive'@'metastorehost';
   mysql> GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES,EXECUTE ON metastore.* TO 'hive'@'metastorehost';
   mysql> GRANT ALL PRIVILEGES ON *.* TO hive@"metastorehost " IDENTIFIED BY "mypassword" WITH GRANT OPTION;
   mysql> FLUSH PRIVILEGES;
   mysql> quit;
5. Update hive-site.xml, take host 172.31.34.11 and hive user hive11 as example:
   
     javax.jdo.option.ConnectionURL
     jdbc:mysql://10.18.6.157:3306/metastore
   
   
     javax.jdo.option.ConnectionDriverName
     com.mysql.jdbc.Driver
   
   
     javax.jdo.option.ConnectionUserName
     hive11
   
   
     javax.jdo.option.ConnectionPassword
     hive11
   
   
     datanucleus.autoCreateSchema
     true
     creates necessary schema on a startup if one doesn't exist. set this to false, after creating it once
   
    
         datanucleus.autoCreateTables
         true
    
    
       datanucleus.autoCreateColumns
       true
    
   
     datanucleus.autoStartMechanismMode
     checked
     throw exception if metadata tables are incorrect
   
   
     datanucleus.fixedDatastore
     true
   
   
     hive.metastore.schema.verification
     false
   
6. Start hive to check:
   {HIVE_HOME}/bin/hive

相关图片

相关文章