HIVE 安装

冷不防 2024-03-27 18:11 15阅读 0赞

**目录**

启动hadoop

把hive压缩包拷贝到虚拟机里面

解压

改名

配置环境变量

新建一个hive-site.xml文件，并编辑

配置文件

添加jar包

初始化mysql

启动hive

创建数据库

使用数据库

创建表

添加数据

查看数据

删除表

--------------------

[安装虚拟机][Link 1]

[安装JDK][JDK]

[安装Hadoop][Hadoop]

[安装MySQL][MySQL]

[安装mysql（YUM源方式）][mysql_YUM]

### 启动hadoop ###

> \[root@hadoop3 install\]\# start-all.sh

### 把hive压缩包拷贝到虚拟机里面 ###

### 解压 ###

> \[root@hadoop3 install\]\# tar -zxvf apache-hive-3.1.2-bin.tar.gz -C ../sof

### 改名 ###

> \[root@hadoop3 soft\]\# mv /opt/soft/apache-hive-3.1.2-bin/ /opt/soft/hive312

### 配置环境变量 ###

> \[root@hadoop3 soft\]\# vim /etc/profile
> 
> 在里面加入下面的代码
> 
>     #HIVE_HOME
>     export HIVE_HOME=/opt/soft/hive312
>     export PATH=$PATH:$HIVE_HOME/bin

### 新建一个hive-site.xml文件，并编辑 ###

> \[root@hadoop3 opt\]\# cd /opt/soft/hive312/conf/  
> \[root@hadoop3 conf\]\# touch hive-site.xml  
> \[root@hadoop3 conf\]\# vim hive-site.xml

#### 配置文件 ####

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
    <configuration>
      <property>
        <name>hive.metastore.warehouse.dir</name>
        <value>/opt/soft/hive312/warehouse</value>
      </property>
      <property>
        <name>hive.metastore.db.type</name>
        <value>mysql</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://192.168.78.141:3306/hive143?createDatabaseIfNotExist=true</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionDriverName</name>
        <value>com.mysql.cj.jdbc.Driver</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>root</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>root</value>
      </property>
      <property>
        <name>hive.metastore.schema.verification</name>
        <value>false</value>
    	<description>关闭schema验证</description>
      </property>
      <property>
        <name>hive.cli.print.current.db</name>
        <value>true</value>
    	<description>提示当前数据库名</description>
      </property>
      <property>
        <name>hive.cli.print.header</name>
        <value>true</value>
    	<description>查询输出时带列名一起输出</description>
      </property>
    </configuration>

**TIP：**

### ![eaa96b86ee60400b8f601707736a0d7e.png][] ###

### 添加jar包 ###

在hive312下面添加一个mysql-connector-java jar包![ae1ee9dae97f4f4db47db281b46e2fc3.png][]

### 初始化mysql ###

> \[root@hadoop3 conf\]\# schematool -dbType mysql -initSchema

### 启动hive ###

> 直接输入hive即可
> 
> \[root@hadoop3 conf\]\# hive  
> ![89aadcee25fe42009c09eda8349ae2d9.png][]
> 
> 出现hi(default)> 即成功

#### 创建数据库 ####

> hive (default)> create database test;

#### 使用数据库 ####

> hive (default)> use test;

#### 创建表 ####

> hive (test)> show tables a;

#### 添加数据 ####

> hive (test)> insert into a values(1,"张三三");

#### 查看数据 ####

> hive (test)> select \* from a;  
> ![d075c44c7af04f6592d65f2b06cd4df2.png][]

#### 删除表 ####

> hive (test)> drop table a;  
> ![7f3d968024364674b36a1dfe27f81c27.png][]

[Link 1]: https://blog.csdn.net/qq_57151931/article/details/127983737?spm=1001.2014.3001.5502
[JDK]: https://blog.csdn.net/qq_57151931/article/details/128969249?spm=1001.2014.3001.5501
[Hadoop]: https://blog.csdn.net/qq_57151931/article/details/128995078?spm=1001.2014.3001.5501
[MySQL]: https://blog.csdn.net/qq_57151931/article/details/128103095?spm=1001.2014.3001.5501
[mysql_YUM]: https://blog.csdn.net/qq_57151931/article/details/128130660?spm=1001.2014.3001.5501
[eaa96b86ee60400b8f601707736a0d7e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/27/e1cbe3a82ff64dab81827a554ed7dcd5.png
[ae1ee9dae97f4f4db47db281b46e2fc3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/27/9bced178344d4efbbd915b289cce7ef2.png
[89aadcee25fe42009c09eda8349ae2d9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/27/650d9de0da1a444c9520feea218b9bbf.png
[d075c44c7af04f6592d65f2b06cd4df2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/27/47c5b0ed663541b9a096bb21759cb798.png
[7f3d968024364674b36a1dfe27f81c27.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/27/41d59d1bb4794f39be94bba31d6f396f.png