基于MySQL元数据的Hive的安装和简单测试

引言：　Hive是一种强大的数据仓库查询语言，类似SQL，本文将介绍如何搭建Hive的开发测试环境。

1. 什么是Hive

2. 按照Ｈive的准备条件

2.1 Hadoop集群环境已经安装完毕

３. 安装步骤

3.1 下载Ｈｉｖｅ包：apache-hive-0.13.1-bin.tar.gz

3.2 将其解压到/opt目录下

　　　tar xzvf apache-hive-0.13.1-bin.tar.gz

3.3 设置环境变量

export HIVE_HOME=/opt/apache-hive-0.13

export PATH=$PATH:$HIVE_HOME/bin

export CLASSPATH=$CLASSPATH:$HIVE_HOME/bin

3.4. 修改hive-env.xml，复制hive-env.xml.template.

# Set HADOOP_HOME to point to a specific hadoop install directory

HADOOP_HOME=/opt/hadoop-1.2.1

# Hive Configuration Directory can be controlled by:

export HIVE_CONF_DIR=/opt/apache-hive-0.13/conf

3.5 修改hive-site.xml,主要修改数据库的连接信息.

hive.metastore.uris
thrift://127.0.0.1:9083
Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.

javax.jdo.option.ConnectionURL
jdbc:mysql://BladeStone-Laptop: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
hive
username to use against metastore database

javax.jdo.option.ConnectionPassword
123456
password to use against metastore database

3.6 安装ｍｙｓｑｌ数据库(Ubuntu系统)

sudo apt-get install mysql-server

3.7 创建mysql用户hive

3.8 在mysql中创建hive数据库