此文是基于上一篇文章:Hive环境搭建及测试
一、root用户下:上传mysql安装包(mysql-5.5.32.tar.gz)到/install目录下,并解压安装;
二、hadoop用户下:上传mysql驱动包(mysql-connector-java-3.0.17-ga-bin.jar )到/software/hive-1.2.2/lib
修改Hive的配置文件:
vi /software/hive-1.2.2/conf/hive-site.xml
更改数据库连接方式:
394
395 javax.jdo.option.ConnectionURL
396
397 jdbc:mysql://192.168.154.134:3306/hive?createDatabaseIfNotExist=true&characterEncoding=utf8
398 JDBC connect string for a JDBC metastore
399
更改驱动:
789
790 javax.jdo.option.ConnectionDriverName
791
792 com.mysql.jdbc.Driver
793 Driver class name for a JDBC metastore
794
更改登陆名:
815
816 javax.jdo.option.ConnectionUserName
817
818 root
819 Username to use against metastore database
820
更改登录密码:
379
380 javax.jdo.option.ConnectionPassword
381
382 123456
383 password to use against metastore database
384
更改日志格式是二进制格式:
vi /etc/my.cnf
52 #binlog_format=mixed53 binlog_format=row
三、测试安装是否成功:
root用户下:
cd /software/mysql-5.5.32/sbin
lsof -i:3306 //查看是否启动成功
cd /software/mysql-5.5.32/bin
./mysql -uroot -p123456 -e "drop database if exists hive;create database hive character set latin1" //必须为latin1;因为hive不支持utf-8
./mysql -uroot -p123456 -e "show databases;"//显示是否成功创建数据库