Hadoop学习之Hive

一、Hive的安装

1.下载安装包

2.上传

3.解压

二、修改配置文件 

1.在新文件中添加hadoop路径

 

 2.配置hive-site.xml文件内容

<configuration>

       <property>

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

              <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>

            <description>Mysql连接协议</description>

       </property>

        

       <property>

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

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

              <description>JDBC驱动</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>JJ12315kk.</value>

              <description>password to use against metastore database</description>

       </property>

</configuration>

三、上传mysql驱动

 

四、启动Hive 

1.尝试启动hive报错

2.将hadoop下高版本guava复制到hive目录下 

3.初始化hive下的mysql 

4.启动成功（但是有警告）

五、使用hive 

1.输入命令查看数据库

运行无误，安装成功