HIVE --- zeppelin安装

谁践踏了优雅 2024-03-26 15:37 58阅读 0赞

**目录**

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

解压

改名

修改配置文件

编辑zeppelin-site.xml—将配置文件的ip地址和端口号进行修改

编辑 zeppelin-env.sh—添加JDK和Hadoop环境

配置环境变量

刷新环境变量

拷贝Hive文件

拷贝外部文件

启动zeppelin

启动Hadoop&Hive

可视化界面

使用zeppelin

第一步：点击右上角的anonymous选择interpreter

第二步：选择create编辑

第三步：Interpreter Name & Interpreter group & Properties编辑

测试

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

zeppelin安装是基于Hadoop和Hive基础上进行

[Hadoop安装教程][Hadoop]

[Hive安装教程][Hive]

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

![b572a2d9eb5446bcb51e7914260ef37b.png][]

![c5c481a5ad624b5c980fad3e6d54abc1.png][]

### 解压 ###

> \[root@hadoop3 install\]\# tar -zxf zeppelin-0.10.0-bin-all.tgz -C ../soft/

### 改名 ###

> \[root@hadoop3 install\]\# cd ../soft/  
> \[root@hadoop3 soft\]\# mv zeppelin-0.10.0-bin-all/ zeppelin

### 修改配置文件 ###

#### 编辑zeppelin-site.xml—将配置文件的ip地址和端口号进行修改 ####

> \[root@hadoop3 soft\]\# cd /opt/soft/zeppelin/conf
> 
> \[root@hadoop3 conf\]\# cp zeppelin-site.xml.template zeppelin-site.xml
> 
> \[root@hadoop3 conf\]\# cp zeppelin-env.sh.template zeppelin-env.sh
> 
> \[root@hadoop3 conf\]\# vim ./zeppelin-site.xml

<property>
      <name>zeppelin.server.addr</name>
      <value>192.168.152.192</value>
      <description>Server binding address</description>
    </property>
    
    <property>
      <name>zeppelin.server.port</name>
      <value>8090</value>
      <description>Server port.</description>
    </property>

#### 编辑 zeppelin-env.sh—添加JDK和Hadoop环境 ####

> \[root@hadoop3 conf\]\# vim ./zeppelin-env.sh

export JAVA_HOME=/opt/soft/jdk180
    export HADOOP_HOME=/opt/soft/hadoop313
    export HADOOP_CONF_DIR=/opt/soft/hadoop313/etc/hadoop

![17330ffd4da6462fb66bb1d17e312ea6.png][]

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

> \[root@hadoop3 conf\]\# vim /etc/profile

#ZEPPELIN_HOME
    export ZEPPELIN_HOME=/opt/soft/zeppelin
    export PATH=$PATH:$ZEPPELIN_HOME/bin

### 刷新环境变量 ###

> \[root@hadoop3 conf\]\# source /etc/profile

### 拷贝Hive文件 ###

> \[root@hadoop conf\]\# cp /opt/soft/hive312/conf/hive-site.xml ./
> 
> **切换目录**
> 
> \[root@hadoop3 conf\]\# cd ../interpreter/jdbc/  
> \[root@hadoop3 jdbc\]\# pwd  
> /opt/soft/zeppelin/interpreter/jdbc
> 
> \# 拷贝文件  
> \[root@hadoop3 jdbc\]\# cp /opt/soft/hadoop313/share/hadoop/common/hadoop-common-3.1..3.jar ./  
> \[root@hadoop3 jdbc\]\# cp /opt/soft/hive312/lib/curator-client-2.12.0.jar ./  
> \[root@hadoop3 jdbc\]\# cp /opt/soft/hive312/lib/guava-27.0-jre.jar ./  
> \[root@hadoop3 jdbc\]\# cp /opt/soft/hive312/lib/hive-common-3.1.2.jar ./  
> \[root@hadoop3 jdbc\]\# cp /opt/soft/hive312/lib/hive-jdbc-3.1.2.jar ./  
> \[root@hadoop3 jdbc\]\# cp /opt/soft/hive312/lib/hive-serde-3.1.2.jar ./  
> \[root@hadoop3 jdbc\]\# cp /opt/soft/hive312/lib/hive-service-3.1.2.jar ./  
> \[root@hadoop3 jdbc\]\# cp /opt/soft/hive312/lib/hive-service-rpc-3.1.2.jar ./  
> \[root@hadoop3 jdbc\]\# cp /opt/soft/hive312/lib/libthrift-0.9.3.jar ./  
> \[root@hadoop3 jdbc\]\# cp /opt/soft/hive312/lib/protobuf-java-2.5.0.jar ./

### 拷贝外部文件 ###

![在这里插入图片描述][4b4e1fd849ef47ea8ea30aa5572cbbde.png]

![c80aa99a9d7344f188f4329b823da868.png][]

### 启动zeppelin ###

> \[root@hadoop3 jdbc\]\# zeppelin-daemon.sh start  
> Log dir doesn't exist, create /opt/soft/zeppelin/logs  
> Pid dir doesn't exist, create /opt/soft/zeppelin/run  
> Zeppelin start \[ OK \]

### 启动Hadoop&Hive ###

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

### 可视化界面 ###

打开浏览器输入 IP地址+端口号

例如 192.168.152.192:10000

![c0ac0bbd40504ac7bdc517ec4b186430.png][]

出现上面界面则为成功

### 使用zeppelin ###

#### 第一步：点击右上角的anonymous选择interpreter ####

![0ad0a03c4aba40cea9349191b17aaec2.png][]

#### 第二步：选择create   ![b07895c9730048668dc3e4e0d9794a34.png][] ####

#### 第三步：**Interpreter Name & Interpreter group & Properties**![7e17753adbb940f8a8c4ca59c907a9a2.png][] ####

### 测试 ###

> %hive --- 执行Hive SQL语句
> 
> %hive
> 
> show databases;

![64dc272bfc87405d8cf73f784e32c7ed.png][]

> %sh --- 执行Linux命令
> 
> %sh  
> ls /opt/soft/
> 
> cd /opt/install;  
> ls

![f426a22640df4e6eaafd52c97f39f7ef.png][]

[Hadoop]: https://blog.csdn.net/qq_57151931/article/details/128995078?spm=1001.2014.3001.5502
[Hive]: https://blog.csdn.net/qq_57151931/article/details/129060943?spm=1001.2014.3001.5502
[b572a2d9eb5446bcb51e7914260ef37b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/997955f41e62461b90e5c4ded5dc30a6.png
[c5c481a5ad624b5c980fad3e6d54abc1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/d65172b82b804d9baf6ab5923a7ffb8d.png
[17330ffd4da6462fb66bb1d17e312ea6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/6b86e07b575e4e24afcfa150699bb211.png
[4b4e1fd849ef47ea8ea30aa5572cbbde.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/d3596638dc2c4345ad232581f4dfdfe1.png
[c80aa99a9d7344f188f4329b823da868.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/60c78cf36c674a52a7e62ea8b5afde7c.png
[c0ac0bbd40504ac7bdc517ec4b186430.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/15046fb639a64695a9cfa5acd9432cf7.png
[0ad0a03c4aba40cea9349191b17aaec2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/721edfff521144149c7e5fddf225c539.png
[b07895c9730048668dc3e4e0d9794a34.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/6b350c827e604251bc5e77d0a5391dd5.png
[7e17753adbb940f8a8c4ca59c907a9a2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/b6f757d517494398804494df079618b1.png
[64dc272bfc87405d8cf73f784e32c7ed.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/c93e5dcd3781401e90a203af6db3654d.png
[f426a22640df4e6eaafd52c97f39f7ef.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/ff4fcc79c78b43e5baa663afc8cc5abd.png