hive2.3.7安装

1.安装包下载

https://mirrors.tuna.tsinghua.edu.cn/apache/hive/hive-2.3.7/

2.上传安装包以及mysql驱动包

scp Downloads/apache-hive-2.3.7-bin.tar.gz root@hadoop003:/root/
scp Downloads/mysql-connector-java-5.1.47.jar root@hadoop003:/root/

3.解压安装包

[root@hadoop003 ~]# tar -zxvf apache-hive-2.3.7-bin.tar.gz -C /usr/local/cluster/
[root@hadoop003 ~]# chown hadoop:hadoop -R /usr/local/cluster/apache-hive-2.3.7-bin/
[root@hadoop003 lib]# mv ~/mysql-connector-java-5.1.47.jar /usr/local/cluster/apache-hive-2.3.7-bin/lib/
[root@hadoop003 lib]# chown hadoop:hadoop mysql-connector-java-5.1.47.jar

4.增加hive-site.xml

# vim hive-site.xml
<configuration>
        <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://hadoop002:3306/hive_metastore?createDatabaseIfNotExist=true</value>
        <description>JDBC connect string for a JDBC metastore</description>
        </property>
        <property>
        <name>javax.jdo.option.ConnectionDriverName</name>
        <value>com.mysql.jdbc.Driver</value>
        <description>Driver class name for a JDBC metastore</description>
        </property>
        <property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>root</value>
        <description>username to use against metastore database</description>
        </property>
        <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>KoiioK12#</value>
        <description>password to use against metastore database</description>
        </property>
</configuration>

5.配置hive_home

vim /etc/profile
export HIVE_HOME=/usr/local/cluster/apache-hive-2.3.7-bin
export PATH=$PATH:$HIVE_HOME/bin

6.初始化元数据库

[hadoop@hadoop003 ~]$ schematool -dbType mysql -initSchema

7.启动hive客户端

hive
#创建测试库
hive> create database test;

8.界面查看hdfs文件