Hive安装指南

第一步：下载

我下载的是2.0.1版本的，下载地址如下

http://mirror.symnds.com/software/Apache/hive/hive-2.0.1/apache-hive-2.0.1-bin.tar.gz

---

第二部： 安装mysql，作为hive metadata的存储，我安装了mariaDB 5.5 版本

安装办法
增加MariaDB的repo

cd /etc/yum.repo.d/
vim MariaDB.repo
# MariaDB 5.5 CentOS repository list - created 2013-08-23 13:08 UTC 
# http://mariadb.org/mariadb/repositories/ 
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5/centos6-amd64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1


yum install MariaDB-server

---

第三步 修改MariaDB的配置

启动mysql服务
service mysql start
Root用户，密码123456
mysqladmin -u root password ‘123456’
进入mysql
mysql -u root -p 
新建hive数据库
create database hive DEFAULT CHARACTER SET utf8;
赋予登陆权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY ‘123456’ WITH GRANT OPTION;

---

第四步

解压hive，保证hadoop环境变量已配置好，否则会无法调用hadoop

---

第五步 配置hive环境变量

vim /etc/profile
增加
export HIVE_HOME=/home/lee/hive
export PATH=$HIVE_HOME/bin:$PATH

---

第六步 修改 hive的配置文件

cp hive.default.xml.template hive.xml
主要修改以下属性（由于hive.xml实在属性太多，这里提供vim的一些方法
Vim查找  / eg：/word  既查找word ，按n查找下一个
Vim 跳转到制定行，在命令行中直接输入行数

    <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://16.187.94.183:3306/hive?characterEncoding=UTF-8</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>mysql</value>
</property>

---

第七步 将mysql的jdbc驱动包复制到Hive的lib下

mysql-connector-java-5.0.8-bin.jar

---

第八步 初始化hive数据库

schematool -dbType mysql -initSchema

---

第九步 新建iotmp文件

mkdir iotmp
在hive-site.xml修改以下属性，否则报错
<property>
    <name>hive.querylog.location</name>
    <value>/home /hive/apache-hive-2.0.1-bin/iotmp</value>
    <description>Location of Hive run time structured log file</description>
  </property>
<property>
    <name>hive.exec.local.scratchdir</name>
    <value>/home /hive/apache-hive-2.0.1-bin/iotmp</value>
    <description>Local scratch space for Hive jobs</description>
  </property>
<property>
<property>
    <name>hive.downloaded.resources.dir</name>
    <value>/home /hive/apache-hive-2.0.1-bin/iotmp</value>
    <description>Temporary local directory for added resources in the remote file system.</description>
  </property>

---

第十步 测试

[root@hadooplee3 yum.repos.d]# hive
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/hive/apache-hive-2.0.1-bin/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/hadoop/hadoop-2.7.2/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]

Logging initialized using configuration in jar:file:/home/hive/apache-hive-2.0.1-bin/lib/hive-common-2.0.1.jar!/hive-log4j2.properties
Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. tez, spark) or using Hive 1.X releases.
hive>

成功~