HIVE 安装测试「建议收藏」

0. Hive源码包下载

http://mirror.bit.edu.cn/apache/hive/

1. 集群环境

Master 192.168.124.134

Slave1 192.168.124.128

Slave2 192.168.124.133

2. 下载软件包

#Master

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

3. 修改Hive配置文件

#Master

cd apache-hive-1.2.2-bin/conf

vim hive.xml

<configuration>

<property>

<name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:mysql://master: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>hadoop</value>

</property>

</configuration>

4. 增加环境变量

#Master、Slave1、Slave2

vim ~/.bashrc

export HIVE_HOME=/opt/apache-hive-1.2.2-bin

export PATH=$HIVE_HOME/bin:$PATH

#刷新环境变量

source ~/.bashrc

5. 安装MySQL

#Master

yum -y install mysql-server

chkconfig –add mysql

service mysqld start

#配置MySQL Root用户密码

mysqladmin -uroot password hadoop

6. 安装MySQL连接工具

#Master

1）下载安装包

wget https://cdn.mysql.com//Downloads/Connector-J/mysql-connector-java-5.1.44.tar.gz

tar zxvf mysql-connector-java-5.1.44.tar.gz

2）复制连接库文件

cp mysql-connector-java-5.1.44/mysql-connector-java-5.1.44-bin.jar /usr/local/src/apache-hive-1.2.2-bin/lib

7. 拷贝安装包

#Master

scp -r /usr/local/src/apache-hive-1.2.2-bin root@slave1:/usr/local/src/apache-hive-1.2.2-bin

scp -r /usr/local/src/apache-hive-1.2.2-bin root@slave2:/usr/local/src/apache-hive-1.2.2-bin

8. 启动Hive服务

#Master

hive

hive的元数据存储数据库指定成mysql

创建root管理员：

mysqladmin -u root password 123456

登录：

mysql -u root -p输入密码即可。

忘记密码：

service mysqld stop

mysqld_safe –user=root –skip-grant-tables

mysql -u root

use mysql

update user set password=password(“new_pass”) where user=”root”;

flush privileges;

service mysql start启动mysql

进入mysql

mysql -uroot -p //默认没有密码

为hive建立相应的用户以及密码

CREATE USER ‘hive’ IDENTIFIED BY ‘mysql’;

–添加不成功就执行下flush privileges;

授权hive用户访问权限

GRANT ALL PRIVILEGES ON *.* TO ‘hive’@’%’ WITH GRANT OPTION;

设置mysql 开机启动

chkconfig mysqld on