hive metastore mysql_hive-(1)使用Mysql作为Hive的metastore基本配置

1 . 首先安装好Mysql，如何安装可参考https://www.cnblogs.com/ealenxie/p/9260051.html；下载好HIVE后，解压到 /application/apache-hive-1.2.2-bin

2 . 新增配置环境变量

#HIVE

export HIVE_HOME=/application/apache-hive-1.2.2-bin

#PATH

export PATH=.:${JAVA_HOME}/bin:${HADOOP_HOME}/bin:${MYSQL_HOME}/bin:${HIVE_HOME}/bin:$PATH

3 . 下载mysql-connector-java的jar包 : 将其放进去 /application/apache-hive-1.2.2-bin/lib/

4 . 检查yarn的lib是否有老版本的jline.jar，如果有就删除，然后执行

cp /application/apache-hive-1.2.2-bin/lib/jline-2.12.jar /application/hadoop-2.6.5/share/hadoop/yarn/lib/jline-2.12.jar

5 . 建立hive的相关运行和配置的目录 : 我这里是建立在 /home/cache/hive下面，再新建两个目录operation_logs，resources

即 : /home/cache/hive/operation_logs 和/home/cache/hive/resources

6 . 配置/application/apache-hive-1.2.2-bin/conf/hive-site.xml文件 ，注意hive里面默认是hive-default.xml.template ,复制为hive-site.xml；hive默认为derby数据库，需要把相关信息调整为mysql数据库。

1) . 将所有文件里面的所有的${system:java.io.tmpdir}/${system:user.name} 替换成 /home/cache/hive；${system:java.io.tmpdir}/${hive.session.id}_resources 替换成 /home/cache/hive/resources

2) . 修改(注意是修改)的配置信息如下：

javax.jdo.option.ConnectionURL

jdbc:mysql://localhost:3306/hive_mysql?createDatabaseIfNotExist=true

JDBC connect string fora JDBC metastore

javax.jdo.option.ConnectionDriverName

com.mysql.jdbc.Driver

Driver class name for aJDBC metastore

javax.jdo.option.ConnectionUserName

yourname

username to use againstmetastore database

javax.jdo.option.ConnectionPassword

yourpass

password to use againstmetastore database

7 . 配置/application/apache-hive-1.2.2-bin/conf/hive-env.sh文件，同理template :

# Set HADOOP_HOME to point to a specific hadoop installdirectory

export HADOOP_HOME=/application/hadoop-2.6.5# Hive Configuration Directory can be controlled by:

export HIVE_CONF_DIR=/application/apache-hive-1.2.2-bin/conf

8 . 首次启动初始化schema :

schematool -dbType mysql -initSchema

9 . 启动hadoop，和hive :

cd /application/hadoop-2.6.5/sbin

start-dfs.shstart-yarn.shhive

至此，使用Mysql作为Hive的metastore已经基本配置好了。