1、安装mysql
mysql的安装请参考这篇文章：Linux centos安装mysql5.6/5.7（官网）
2、下载&安装hive
wget http://mirror.bit.edu.cn/apache/hive/hive-1.2.2/apache-hive-1.2.2-bin.tar.gz
tar -zxvf apache-hive-1.2.2-bin.tar.gz
cd /usr/local/SoftWare/Env
ln -s /usr/local/SoftWare/apache-hive-1.2.2-bin hive
cd hive/
mkdir iotmp
vim conf/hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://hadoop:3306/hive_metadata?createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>Username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
<description>password to use against metastore database</description>
</property>
<property>
<name>hive.cli.print.current.db</name>
<value>true</value>
</property>
</configuration>
3、下载JDBC驱动
wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.46.tar.gz
4、复制JDBC驱动到hive的lib目录
tar -zxvf mysql-connector-java-5.1.46.tar.gz
cp mysql-connector-java-5.1.46/mysql-connector-java-5.1.46-bin.jar hive/lib/
5、添加环境变量
vim /etc/profile
#HIVE SETTING START
export HIVE_HOME=/usr/local/Env/hive
export PATH=$PATH:$HIVE_HOME/bin
#HIVE SETTING STOP
使环境变量生效：source /etc/profile
6、启动hive
启动hadoop：
hadoop的安装，请参考这篇文章Hadoop单节点集群环境搭建
cd /usr/local/Env/Hadoop/hadoop-2.6.5/sbin/
./start-all.sh
hive
错误：
原因：Hive的jline和Hadoop的不一致
解决办法：
rm -rf Hadoop/hadoop-2.6.5/share/hadoop/yarn/lib/jline-0.9.94.jar
cp hive/lib/jline-2.12.jar Hadoop/hadoop-2.6.5/share/hadoop/yarn/lib/
成功提示：
