Hadoop组件Hive部署

1.安装Mysql数据库

#解压
[root@master app]# tar -xvf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar
 
#删除自带的数据库
[root@master app]# yum remove mariadb-libs-5.5.56-2.el7.x86_64

#依次运行下面命令安装MySQL服务
[root@master app]# rpm -ivh mysql-community-common-5.7.12-1.el6.x86_64.rpm 
[root@master app]# rpm -ivh mysql-community-libs-5.7.12-1.el6.x86_64.rpm
[root@master app]# rpm -ivh mysql-community-client-5.7.12-1.el6.x86_64.rpm 
[root@master app]# rpm -ivh mysql-community-server-5.7.12-1.el6.x86_64.rpm

#停止MySQL服务
[root@master app]# systemctl stop mysqld
#初始化数据库
[root@master app]# mysqld --initialize --console
#目录授权
[root@master app]# chown -R mysql:mysql /var/lib/mysql
#启动服务
[root@master app]# systemctl start mysqld
#查看临时密码登录数据库修改密码
[root@master app]# cat /var/log/mysqld.log
mysql> alter USER 'root'@'localhost' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.00 sec)
#设置访问权限
mysql> grant all privileges on *.* to root@'%' identified by '123456';
Query OK, 0 rows affected, 1 warning (0.00 sec)

2.Hive搭建

#解压并修改名字
[root@master app]# tar apache-hive-1.1.0-bin.tar.gz 
[root@master app]# mv apache-hive-1.1.0-bin hive
#编辑hive-site.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>123456</value>
        </property>
</configuration>

#添加MySQL驱动到hive/lib目录下
[root@master home]# cp mysql-connector-java-5.1.39.jar /app/hive/lib/

#将hive目录下的lib目录里的jline拷贝到hadoop目录下share/hadoop/yarn/lib中

[root@master lib]# cp jline-2.12.jar /app/hadoop/share/hadoop/yarn/lib/

3.启动Hive

[root@master bin]# ./hive