hadoop集群中安装hive+mysql

一、安装MySQL
详情请看http://blog.csdn.net/intelligebce/article/details/78481214
二、hive安装及其配置
去官网下载tar包，放在Linux系统中解压即可
1、配置hive-site.xml(没有这个文件可以直接创建)


javax.jdo.option.ConnectionURL
jdbc:mysql://localhost: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
root
password to use against metastore database


2、配置HIVE_HOME环境变量 vi conf/hive-env.sh 配置其中的$hadoop-home

三、安装hive和mysq完成后，将mysql的连接jar包拷贝到$HIVE_HOME/lib目录下