hive和MySQL数据源配置_hive配置mysql数据源作为元数据库

1.install mysql

yum install mysql

yum install mysql-server

yum install mysql-devel

chgrp -R mysql /var/lib/mysql

chmod -R 770 /var/lib/mysql

service mysqld start

mysql

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret_password');

2.安装hive

2，解压tar -zxvf hive-0.7.0.tar.gz(注意文件用户权限，和hadoop不一致要修改)

3,配置conf/hive-env.sh.template

export HADOOP_HOME=/usr/local/hadoop-0.20.203.0

export HIVE_HOME =/usr/local/hadoop-0.20.203.0/hive-0.8.1

export JAVA_HOME=/usr/local/jdk1.6.0_25

4,在hive目录下执行bin/hive测试成功是否

Hive history file=/tmp/tmg/hive_job_log_tmg_201105241042_506926685.txt

hive>

执行show tables;

OK

Time taken: 1.482 seconds

安装完成，是不是很easy!

3.配置hive元数据库

修改配置文件hive-site.xml

javax.jdo.option.ConnectionURL

jdbc:mysql://172.16.80.19:3306/hive?createDatabaseIfNotExist=true

JDBC connect string for a JDBC metastore

javax.jdo.option.ConnectionDriverName

com.mysql.jdbc.Driver

Driver class name for a JDBC metastore

javax.jdo.option.ConnectionUserName

root

username to use against metastore database

javax.jdo.option.ConnectionPassword

zone2009

password to use against metastore database

下载mysql driver到hive-home/lib目录下

启动hive --service hwi

执行

http://ip:9999/hwi

能正常看到如下：

后台会提示mysql数据库创建成功。