Hive元数据配置到MySQL

cp /opt/software/mysql-connector-java-5.1.37.jar $HIVE_HOME/lib
vi $HIVE_HOME/conf/hive-site.xml

#添加
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

 
 
 javax.jdo.option.ConnectionURL
 jdbc:mysql://hadoop102:3306/metastore?useSSL=false

 
 
 javax.jdo.option.ConnectionDriverName
 com.mysql.jdbc.Driver


 
 javax.jdo.option.ConnectionUserName
 root
 
 
 
 javax.jdo.option.ConnectionPassword
 ****** #注意修改

 
 
 hive.metastore.schema.verification
 false

 
 
 hive.metastore.event.db.notification.api.auth
 false
 
 
 
hive.metastore.warehouse.dir
 /user/hive/warehouse
 


#登录mysql
mysql -uroot -p
mysql> create database metastore;
mysql> quit;

#初始化元数据库
schematool -initSchema -dbType mysql -verbose