解压缩hive
1.将上传的hive-0.13.1-cdh5.3.6.tar.gz移动到hadoop102的/usr/local目录下
2.解压缩hive安装包
tar -zxvf hive-0.13.1-cdh5.3.6.tar.gz
3、配置hive相关的环境变量
vi /etc/profile
export HIVE_HOME=/usr/local/hive-0.13.1-cdh5.3.6
export PATH=$PATH:$HIVE_HOME/bin
source /etc/profile
安装mysql
1、在hadoop102上安装mysql
2、使用yum安装mysql server
yum install -y mysql-server
service mysqld start
chkconfig mysqld on
3、使用yum安装mysql connector
yum install -y mysql-connector-java
4、将mysql connector拷贝到hive的lib包中
cp /usr/share/java/mysql-connector-java-5.1.17.jar /usr/local/hive-0.13.1-cdh5.3.6/lib/
5、在mysql上创建hive元数据库,创建hive账号,并进行授权
create database if not exists hive_metadata;
grant all privileges on hive_metadata.* to 'hive'@'%' identified by 'hive';
grant all privileges on hive_metadata.* to 'hive'@'localhost' identified by 'hive';
grant all privileges on hive_metadata.* to 'hive'@'hadoop102' identified by 'hive';
flush privileges;
use hive_metadata;
配置
1.配置hive-site.xml
将conf下的hive-default.xml.template改为hive-site.xml,使用以下命令
mv hive-default.xml.template hive-site.xml
添加以下的配置,以便于连接mysql数据库
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://hadoop102:3306/hive_metadata?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>hive</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hive</value>
</property>
2.配置hive-env.sh和hive-config.sh
1)使用命令将hive-env.sh.template改为hive-env.sh
mv hive-env.sh.template hive-env.sh
配置hive-env.sh文件
(a)配置HADOOP_HOME路径
export HADOOP_HOME=/usr/local/hadoop-2.5.0-cdh5.3.6
(b)配置HIVE_CONF_DIR路径
export HIVE_CONF_DIR=/usr/local/hive-0.13.1-cdh5.3.6/conf
2)配置hive-config.sh
vi /usr/local/hive/bin/hive-config.sh
export JAVA_HOME=/usr/java/latest
export HIVE_HOME=/usr/local/hive-0.13.1-cdh5.3.6
export HADOOP_HOME=/usr/local/hadoop-2.5.0-cdh5.3.6
验证hive是否安装成功
直接输入hive命令,可以进入hive命令行