hive 1.1.0搭建

系统：centOS6.5 x86_64

hive版本：apache-hive-1.1.0-cdh5.7.0

JDK版本：1.7

1、下载cdh版本的hive

http://archive.cloudera.com/cdh5/cdh/5/

2、解压、配置环境变量

tar -zxvf apache-hive-1.1.0-cdh5.7.0-bin.tar.gz

vi /etc/profile

export HIVE_HOME=/opt/software/hive

export PATH=${HIVE_HOME}/bin:${PATH}

3 Hive配置修改
hive-env.sh
HADOOP_HOME=/opt/software/hadoop
hive-site.xml   统一元数据管理
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
    <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://hadoop001:3306/hive?createDatabaseIfNotExist=true</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>123456</value>
    </property>
</configuration>

4 下载mysql驱动包到$HIVE_HOME/lib
https://dev.mysql.com/downloads/connector/j/

备注：这里使用mysql作为元数据数据库，必须确认登陆用户的登陆权限，否则会报错。

报错：java.sql.SQLException: Access denied for user 'root'@'hadoop001' (using password: YES)

grant all privileges on hive.* to root@'%' identified by '123456';
SET PASSWORD FOR root@hadoop001 = PASSWORD('123456'); 
flush privileges;

【来自@若泽大数据】