hive 的mysql元数据配置

1. 下载MySQL的驱动包
   cd /home/software/apache-hive-1.2.0-bin/lib
   wget http://bj-yzjd.ufile.cn-north-02.ucloud.cn/mysql-connector-java-5.1.38-bin.jar
2. 编辑hive-site.xml
   cd …/conf
   vim hive-site.xml
   添加：
   
   
   javax.jdo.option.ConnectionURL
   jdbc:mysql://hadoop01:3306/hive?createDatabaseIfNotExist=true
   
   
   javax.jdo.option.ConnectionDriverName
   com.mysql.jdbc.Driver
   
   
   javax.jdo.option.ConnectionUserName
   root
   
   
   javax.jdo.option.ConnectionPassword
   root
   
   
3. 进入MySQL，执行
   grant all privileges on . to ‘root’@‘hadoop01’ identified by ‘root’ with grant option;
   grant all on . to ‘root’@’%’ identified by ‘root’;
   flush privileges;
   create database hive character set latin1;
4. 进入Hive安装目录的bin目录下
   cd …/bin
   sh hive

如果启动失败，从第三个错误开始查看
出现READ COMMITTED or UNREAD COMMITTED，解决方案：
vim /usr/my.cnf
添加：
binlog_format=mixed
重启MySQL
service mysql restart