开启hadoop集群
将Hive压缩包解压到/root/bigdata目录下
```bash tar -zxvf apache-hive-3.1.1-bin.tar.gz -C /root/bigdata/
## 配置Hive
1. 进入到hive安装目录下的conf目录
2. ```bash
root@master:~/bigdata/apache-hive-3.1.1-bin# cd /root/bigdata/apache-hive-3.1.1-bin/conf
新建hite-site.xml文件
```bash root@master:~/bigdata/apache-hive-3.1.1-bin/conf# vim hive-site.xml
5. 添加以下内容
6. ```bash
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>hive.metastore.local</name>
<value>true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hadming</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://master:3306/hadoopDB?characterEncoding=UTF-8</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
</configuration>
配置环境变量hive-env.sh
```
root@master:/bigdata/apache-hive-3.1.1-bin/conf# cp hive-env.sh.template hive-env.sh
root@master:/bigdata/apache-hive-3.1.1-bin/conf# vim hive-env.sh
9. 将HADOOP_HOME路径添或修改如下:
10. ```
HADOOP_HOME=/root/bigdata/hadoop-3.1.1
使用生效:
``` root@master:~/bigdata/apache-hive-3.1.1-bin/conf# source hive-env.sh
13. 配置环境变量/etc/profile,加入HIVE的路径
14. ```
root@master:~/bigdata/apache-hive-3.1.1-bin# vim /etc/profile
添加如下代码:
```
export HIVE_HOME=/root/bigdata/apache-hive-3.1.1-bin export PATH=PATH:HIVE_HOME/bin
17. ![](https://strongwillpro.oss-cn-beijing.aliyuncs.com/img/20221025201927.png)
18. ![](https://strongwillpro.oss-cn-beijing.aliyuncs.com/img/20221025202105.png)
19. 使用生效:
root@master:~/bigdata/apache-hive-3.1.1-bin# source /etc/profile
20. 配置hive-config.sh文件
21. ```bash
root@master:~/bigdata/apache-hive-3.1.1-bin/bin# vim hive-config.sh
在末尾添加以下代码:
```bash export JAVA_HOME=/root/bigdata/jdk1.8.0_191 export HADOOP_HOME=/root/bigdata/hadoop-3.1.1 export HIVE_HOME=/root/bigdata/apache-hive-3.1.1-bin
24. 复制MySQL的驱动程序
25. ![](https://strongwillpro.oss-cn-beijing.aliyuncs.com/img/20221025202742.png)
26. ```bash
创建目录source:
root@master:~/bigdata# mkdir source
将MySQL驱动程序解压至source目录下
```bash root@master:~/downloads# dpkg -X mysql-connector-java_8.0.14-1ubuntu18.04_all.deb /root/bigdata/source
30. 切换目录并找到mysql-connector-java-8.0.14.jar文件(MySQL驱动),将其复制到HIVE安装文件的lib目录下。
31. ```
root@master:~/downloads# cd /root/bigdata/source/usr/share/java
root@master:~/bigdata/source/usr/share/java# cp mysql-connector-java-8.0.14.jar /root/bigdata/apache-hive-3.1.1-bin/lib/
元数据初始化,进入到hive的bin目录下,执行schematool 命令
```bash root@master:~/bigdata/apache-hive-3.1.1-bin/bin# ./schematool -initSchema -dbType mysql
34. ![](https://strongwillpro.oss-cn-beijing.aliyuncs.com/img/20221025202955.png)
35. ![](https://strongwillpro.oss-cn-beijing.aliyuncs.com/img/20221025203003.png)
## 启动Hive
```bash
root@master:~/bigdata/apache-hive-3.1.1-bin/bin# hive
注:第一次输入hive命令时我出现以下错误:(在机房没有这个错误)
打开环境变量文件,重新生效一下,就可以了
root@master:~/bigdata/apache-hive-3.1.1-bin/bin# vim /etc/profile
root@master:~/bigdata/apache-hive-3.1.1-bin/bin# source /etc/profile