Linux(CentOS7)安装Hive

布满荆棘的人生 2021-12-10 01:13 484阅读 0赞

# 一、准备安装包 #

*  apache-hive-1.0.0-bin.tar.gz
 *  mysql-connector-java-5.1.40-bin.jar

可以到我的网盘下载：链接: [https://pan.baidu.com/s/1pL0\_0PMKtqH-iMznP1pdCw][https_pan.baidu.com_s_1pL0_0PMKtqH-iMznP1pdCw] 提取码: sj5n

# 二、安装mysql #

这里不再赘述，如果未安装，可以参考下面两篇博文：  
[CentOS7 yum方式 安装MySQL5.7][CentOS7 yum_ _MySQL5.7]  
[CentOS7.4 RPM方式安装mysql5.7][CentOS7.4 RPM_mysql5.7]

# 三、安装Hive #

## 3.1 解压hive安装包 ##

tar -zxvf apache-hive-1.0.0-bin.tar.gz

## 3.2 移动安装包到/usr/local ##

mv apache-hive-1.0.0-bin /usr/local/hive

## 3.3 拷贝数据库连接依赖 ##

cp mysql-connector-java-5.1.40-bin.jar /usr/local/hive/lib/

## 3.4 新增配置文件hive-site.xml ##

vim conf/hive-site.xml

![打开hive-site.xml][hive-site.xml]

<?xml version="1.0"?>
    <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
    <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>
    <property>
      <name>hive.metastore.warehouse.dir</name>
      <value>/user/hive/warehouse</value>
    </property>
    <property>
      <name>hive.metastore.local</name>
      <value>true</value>
    </property>
    </configuration>

# 四、修改环境变量 #

## 4.1 编辑环境变量 ##

vim /etc/profile

export HIVE_HOME=/usr/local/hive
    export PATH=.:$HIVE_HOME/bin:$PATH

![profile文件][profile]

## 4.2 使环境变量生效 ##

source /etc/profile

# 五、运行hive并查看效果 #

## 5.1 运行hive ##

hive

![hive命令运行效果][hive]

## 5.2 查看效果 ##

查看本机的mysql数据库，发现已经生成hive数据库。  
![hive数据库][hive 1]至此，hive已经成功安装。

[https_pan.baidu.com_s_1pL0_0PMKtqH-iMznP1pdCw]: https://pan.baidu.com/s/1pL0_0PMKtqH-iMznP1pdCw
[CentOS7 yum_ _MySQL5.7]: https://blog.csdn.net/zhuimeng_by/article/details/90715129
[CentOS7.4 RPM_mysql5.7]: https://blog.csdn.net/zhuimeng_by/article/details/83653605
[hive-site.xml]: /images/20211209/7014a36973c3465f92daf6dea09464df.png
[profile]: /images/20211209/faeb072bf7b647debd1ba3abca54ecb3.png
[hive]: /images/20211209/f3cc72a69c9e457cbc29b76fb9b4ed4d.png
[hive 1]: /images/20211209/99b7c67d9be74a8e89c593090ab0cda3.png