一、前提条件
1、已经搭建好hadoop或hadoop集群环境
二、安装步骤
1、下载hive安装包
[http://www.apache.org/dyn/closer.cgi/hive/]
2、上传解压 到 /home/hadoop目录下: /home/hadoop/hive
3、 编辑/etc/profile,配置HIVE_HOME
export HIVE_HOME=/home/hadoop/hive-x.y.z
export PATH=PATH:HIVE_HOME/bin
4、进入$HIVE_HOME/conf文件夹下配置hive-env.sh
在文件的中指定hadoop的安装路径
HADOOP_HOME=/home/hadoop/hadoop-2.8.3
5、配置 $HIVE_HOME/conf/hive-site.xml 文件
详细可参考:[https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin]
<?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://[host name]:3306/[database name]</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>ab123456</value>
</property>
</configuration>
6、配置Mysql
创建数据库:create database hive;
创建用户:create user 'hivedba' identified by 'ab123456';
授权用户:grant all privileges on hive.* to 'hivedba'@'%' identified by 'ab123456';
拷贝mysql链接驱动到: $HIVE_HOME/lib目录下
(jar驱动下载地址:[https://dev.mysql.com/downloads/connector/j/]
7、启动
输入:hive