hive2.1.1的安装

hive2.1.1的安装

一、下载安装包并解压

下载地址http://mirror.bit.edu.cn/apache/hive/

tar -zxvf apache-hive-2.1.1-bin.tar.gz -C /usr/local/
mv /usr/local/apache-hive-2.1.1-bin.tar.gz /usr/local/hive-2.1.1

二、添加环境变量

vi /etc/profile在末尾添加

# hive environment
export HIVE_HOME=/usr/local/hive-2.1.1
export HIVE_CONF_DIR=$HIVE_HOME/conf
export PATH=$HIVE_HOME/bin:$PATH
export CLASSPATH=$CLASSPATH:$HIVE_HOME/lib

三、安装mysql

yum install mysql mysql-server

出现错误：

No package mysql-server available.

解决办法：

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
yum install mysql mysql-server mysql-libs mysql-server

四、添加hive用户并设置

1.创建hive用户和密码(与hive的hive-site.xml配置文件里的用户名和密码一致)

mysql> create user 'hive'@'%' IDENTIFIED BY 'hive';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%' WITH GRANT OPTION;
mysql> grant all on *.* to 'hive'@'spark1' identified by 'hive';
mysql> grant all on *.* to 'hive'@'localhost' identified by 'hive';
mysql>flush privileges; //刷新系统权限表

2.修改mysql root密码

$ mysql -u root -p
Enter password: ******
mysql> use mysql;
mysql> update user set password=password('新密码') where user='root';
mysql>flush privileges; //刷新系统权限表

五、hive配置文件设置/usr/local/hive-2.1.1/conf

修改hive安装目录下conf下的hive-env.sh和hive-site.xml这两个配置文件

1.hive-env.sh

2.hive-site.xml

然后，把MySQL的JDBC驱动包（我使用的是mysql-connector-java-5.1.18-bin.jar，从
http://mirrors.sohu.com/mysql/Connector-J/下载并解压后可以找到）复制到Hive的lib目录下。

六、启动hive

首先，在master中启动start-all.sh

$ start-all.sh

启动Hive shell
Hive2.1的启动需要先执行schematool命令进行初始化

schematool -dbType mysql -initSchema

然后，在命令行敲击hive即可。

错误及总结

1.Underlying cause: java.sql.SQLException : Access denied for user ‘hive’@’spark1’

grant all on *.* to 'hive'@'spark1' identified by 'hive';
grant all on *.* to 'hive'@'localhost' identified by 'hive';
flush privileges;