hadoop hive 搭建的其他方法

1. Hive搭建

1）将apache-hive-3.1.2-bin.tar.gz压缩包放在/opt/software路径下

 

2）、[root@hadoop100 ~]# cd /opt/software

3）、解压apache-hive-3.1.2-bin.tar.gz到/opt/module/路径下

[root@hadoop100 software]# tar -zxvf apache-hive-3.1.2-bin.tar.gz -C /opt/module/

4）、进入解压之后的apache-hive-3.1.2-bin路径下的conf/文件夹下

[root@hadoop100 module]# cd /opt/module/apache-hive-3.1.2-bin/conf/

5）、创建并编辑hive-site.xml文件，输入以下内容：

注意：下列标红部分为按自己VMnet8的IP及数据库账号密码进行配置

[root@hadoop100 conf]# vi hive-site.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?>                            

<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>                                                        

<configuration>                                                                                    

  <!-- jdbc 连接的 URL -->                                                        

  <property>                                                                                    

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

                                                                                        <value>jdbc:mysql://192.168.1.5:3306/hive?useSSL=false&characterEncoding=utf8&a                            mp;serverTimezone=UTC</value>                                                                                    

  </property>                                                                                    

  <!-- jdbc 连接的 Driver-->                                                        

  <property>                                                                                                        

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

    <value>com.mysql.cj.jdbc.Driver</value>                                                    

  </property>                                                                                                        

  <!-- jdbc 连接的 username-->                                                    

  <property>                                                                                                        

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

    <value>root</value>                                                                                                        

  </property>                                                                                                        

  <!-- jdbc 连接的 password -->                                                                                                        

  <property>                                                                                                        

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

    <value>123456</value>                                                                                                        

  </property>                                                                                                        

  <!-- Hive 元数据存储版本的验证 -->                                                                                                        

  <property>                                                                                                        

    <name>hive.metastore.schema.verification</name>                                                    

    <value>false</value>                                                                                                        

  </property>                                                                                                        

  <!--元数据存储授权-->                                                                                                        

  <property>                                                                                                        

    <name>hive.metastore.event.db.notification.api.auth</name>                                                    

    <value>false</value>                                                                                                        

  </property>                                                                                                        

  <!-- 指定存储元数据要连接的地址 -->                                                                                                        

  <property>